Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
LIKE vs PATINDEX
We had a discussion on some of the performance warnings in VSTF like using LIKE(with %) operator. I...
Date: 07/25/2012
How much space are you wasting?
The Below script would provide us the space used by write only indexes. The usage stats from the...
Date: 06/29/2012
LAG’n’LEAD – New T-SQL Features in SQL Server Denali CTP3
Are you tired of doing self joins, just to get the value of a column in the previus/subsequent row,...
Date: 06/29/2012
THROW in Error Handling - Denali
Error handling is now easier with the introduction of the THROW command in SQL Server 2011. Legacy...
Date: 06/29/2012
Deprecated Database Engine Features in SQL Server 2012
These features (https://technet.microsoft.com/en-us/library/ms143729(SQL.110).aspx) are scheduled to...
Date: 06/29/2012
14 New Functions and 1 Changed Function in Denali
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) introduces 14 new built-in functions. These...
Date: 06/29/2012
Dude! What is Microsoft SQL Server ?
Microsoft SQL Server is a relational database server, developed by Microsoft: It is a software...
Date: 06/29/2012
SQL Server 2012 – New Features – Contained Databases
A very common problem that has plagued both the DBAs and developers for a long time is migrating...
Date: 06/29/2012
Monitoring tempdb Transactions and Space usage
As the tempdb database is the common global resource for all the operations going on in SQL Server,...
Date: 04/13/2010
Ranking Functions in SQL Server
SQL Server introduced four different ranking functions either to rank records in a result-set or to...
Date: 03/24/2010
Storage Reporting Tool
If you have multiple servers and want to capture the space availability to plan for future, then...
Date: 03/02/2010
Job Fails on Linked Server - Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274)
Problem: Having a SQL Agent Job, which executes a Stored prcedure to connect to a remote SQL server...
Date: 03/02/2010
Issues with Updatable Subscriptions for Transactional Replication
Careful with Replication type "Updatable Subscriptions for Transactional Replication" when your...
Date: 03/02/2010