Monday, 5 November 2012
Create a Cursor using Dynamic SQL Query
›
Even though we are advised not to use or to minimize the usage of cursors in SQL, there are times which, it’s the only available option, dep...
4 comments:
Wednesday, 19 September 2012
Introduction to SSDT (SQL Server Data Tools)
›
What is SSDT ? SQL Server Data Tools (SSDT) is a toolset which provides an integrated environment for database developers to carry out all ...
Friday, 31 August 2012
Installing SQL Server Data Tools (SSDT)
›
What is SQL Server Data Tools? SQL Server Data Tools (SSDT) is a toolset which provides an integrated environment for database developers ...
Wednesday, 11 April 2012
Resolved ~ How to get back SSMS ‘Find and Replace’ Alert
›
As you know in SQL Server Management Studio (SSMS), once you have cleared the check box value of ‘Always show this message’, from the ‘Fi...
1 comment:
Thursday, 8 March 2012
Locks and Duration of Transactions in MS SQL Server
›
It is a common argument which I hear among developers these days, regarding SQL locks. Some say that the ‘locks are held for the duration...
2 comments:
Monday, 16 January 2012
Exclusive access could not be obtained because the database is in use ~ Resolved
›
Sometimes this is a common error message that we encounter, when we try to restore a SQL database, which is being used by other users. ...
10 comments:
‹
›
Home
View web version
