Recent Posts

Pages: 1 ... 8 9 [10]
91
SQL Server / Re: What is Different between Primary key and Unique ?
« Last post by Ritesh Shah on September 24, 2012, 05:28:39 PM »
very true, just wanted to add small note: Usually PK creates Clustered index, but you can change this behavior, sometime it happens that your PK doesn't have high selectivity so you might need non-clustered index there and want to have clustered index on some other key. it is completely possible, if you wish.
92
SQL Server / Re: Shortcut keys to switch between grid,text and file
« Last post by Ritesh Shah on September 24, 2012, 05:22:53 PM »
very useful tip, I don't know how many time I used to use this everyday !!!!
93
SQL Server / What is Different between Primary key and Unique ?
« Last post by kaluahir16 on September 24, 2012, 04:24:26 PM »
Primary Key  and Unique Key  both are enforces uniqueness of the column on which they are defined.  But 
1)  Primary Key creates a clustered index on the column  when Unique Key creates a non-clustered index on the column. 
2) Primary Key does not allow Nulls. Unique Key allows only one NULL Value
94
SQL Server / Shortcut keys to switch between grid,text and file
« Last post by BhushanShah on September 24, 2012, 04:17:57 PM »
Results in a grid  : CTRL+D

Results in text format : CTRL+T

Results to a file : CTRL+SHIFT+F


Regards,
Bhushan Shah
95
SQL Server / Difference between a DELETE and TRUNCATE
« Last post by BhushanShah on September 23, 2012, 12:02:09 AM »
1) DELETE returns numbers of rows that is deleted, where as in TRUNCATE does not return any such value.

2) DELETE does not reset the Identity value but TRUNCATE reseeds the
Identity value to first value.

3) You can put a where clause in DELETE but in TRUNCATE where clause
cannot be used, hence the whole table data is truncated.

 4) DELETE is slower than TRUNCATE, as when you execute a DELETE
command  logging is done in Transation-Log,where as for TRUNCATE
command page level logging is done.

5)Last but not least DELETE is a DML
command where as TRUNCATE is a DDL command.



NOTE: DELETE and TRUNCATE COMMANDS CAN BE ROLLED BACK.



Regards,
Bhushan Shah
96
All member of "Quick Learn" / Re: How to call SSRS report from asp.net?
« Last post by BhushanShah on September 22, 2012, 08:40:56 PM »
Sure.
I am working on it.

Regards,
Bhushan Shah
98
SQL Server / MOVED: Email Alert on deadlock in MSSQL
« Last post by Ritesh Shah on September 22, 2012, 07:22:54 PM »
99
SQL Server / MOVED: sql server
« Last post by Ritesh Shah on September 22, 2012, 07:21:47 PM »
100
Ritesh / Re: Email Alert on deadlock in MSSQL
« Last post by Ritesh Shah on September 22, 2012, 07:13:39 PM »
Hi Dinesh,

Tracing Deadlock is not as easy as it seems because there is nothing ready-made where you can query and get all information, you have to have your own monitoring system which alerts you whenever deadlock happens. You can have a look at following article which will help you.

http://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/

Do get back to me if you have any issues or concern?
Pages: 1 ... 8 9 [10]