Monthly Archives: December 2010

Should Stored Procedure name start with SP_ ???

NO, user defined Stored Procedures, should not start with SP_, as this bring down the performance. SQL Server looks for a stored procedure beginning with "sp_" in the following order: MASTER system database use FQN (Fully Qualified Name) to locate the SP if FQN is not supplied, current database is used with dbo as owner [...]

List 10 difference between TRUNCATE & DELETE statement in SQL Server?

This is a regular interview questions, which is being asked by interviewer for DEV DBA profiles. Here is a extensive list of difference between TUNCATE and DELETE Table statements. TRUNCATE V/s DELETE Truncate Delete TRUNCATE is a DDL command DELETE is a DML command TRUNCATE TABLE always locks the table and page but not each [...]

V44 – Oracle SQL Tutorial – Data Dictionary (Theory)

V44 – Oracle SQL Tutorial – Data Dictionary (Theory)

SQL Tutorial that explains the purpose of the data dictionary and how to query the data dictionary to obtain information about the objects in the user's schema….presented by www.oraclecoach….

V44 – Oracle SQL Tutorial – Data Dictionary (Theory)

V44 – Oracle SQL Tutorial – Data Dictionary (Theory)

SQL Tutorial that explains the purpose of the data dictionary and how to query the data dictionary to obtain information about the objects in the user's schema….presented by www.oraclecoach….

How to trace Deadlock in SQL Server ?

What is a DEAD LOCK in SQL Server? When two or more transactions conflict in such a way that each is waiting for the other before they proceed. For instance, Transaction A might have a lock on Record 1 while trying to write to Record 2, while Transaction B has a lock on Record 2 [...]

How to Do Banded Rows with Report Parameters in SQL Server 2008 Reporting Services

How to Do Banded Rows with Report Parameters in SQL Server 2008 Reporting Services

This video is part of LearnItFirst's SQL Server 2008 Reporting Services course. More information on this video and course is available here: www.learnitfirst.com …

Does Mirroring works with FileStream databases ?

NO, FILESTREAM doesn’t work with mirroring and database Snapshots. FileStream works with Replication, Log Shipping and HADR (SQL Server Denali, 2011)