Friday, December 31, 2010

Should Stored Procedure name start wi...

Should Stored Procedure name start with SP_ ??? - NO, user defined Stored Procedures, should not start with SP_, as ... http://ping.fm/cm9uh

Thursday, December 30, 2010

List 10 difference between TRUNCATE &...

List 10 difference between TRUNCATE & DELETE statement in SQL Server? http://ping.fm/NmDGT

Wednesday, December 29, 2010

How to trace Deadlock in SQL Server ?...

How to trace Deadlock in SQL Server ? - What is a DEAD LOCK in SQL Server? When two or more transactions conflict in... http://ping.fm/6fdhj

Tuesday, December 28, 2010

Does Mirroring works with FileStream ...

Does Mirroring works with FileStream databases ? - NO, FILESTREAM doesn’t work with mirroring and database Sna... http://ping.fm/atHex

Monday, December 27, 2010

How to Monitor Database Mirroring, SQ...

How to Monitor Database Mirroring, SQL Server? - SQL Server Mirroring can be monitored SQL Server Management Studio ... http://ping.fm/9qKEw

Wednesday, December 22, 2010

What is SQL Server Feature Pack ? - W...

What is SQL Server Feature Pack ? - What is SQL Server Feature Pack ? The Feature Pack is a collection of standalone... http://ping.fm/zlNnn

Tuesday, December 21, 2010

How to perform SQL Server Mirroring M...

How to perform SQL Server Mirroring Manual Failover? - What is SQL Server Mirroring Failover ? When the principal se... http://ping.fm/AiEfQ