|
|
-
|
|
In earlier versions of SQL Server, if we want to use stored procedures in OLEDB source command which contains temporary tables we take some workarounds mentioned below
1. http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/65112/
2....
|
|
-
|
|
Adding Distinct keyword hurt the query performance badly, but in real world we need to add Distinct may be because of not properly done normalization or may be we are working on a system which is intentionally designed that way. But, this post is not ab...
|
|
-
|
|
If we have persisted computed columns and the arithabort is set to ON, SQL needs to re-compute the column despite having column marked as computed. The rather bigger issue is the query always scans index, in spite of having proper index. Let’s have a ...
|
|
-
|
|
In SSMS 2005 and SSMS 2008 the method to clear the server name from "connect to server" dialog is to close SSMS and remove mru.dat ( in case of 2005) or SqlStudio.bin ( in case of 2008 and 2008 R2). This method has been documented here.
Below are the d...
|
|
-
|
|
When we use index query hint, we can give the index number or index name. I use an index hint for testing performance purpose only and almost never use it in actual code. I tend to use index numbers in test code. But, till some time ago I used to wonder...
|
|
-
|
|
Earlier I posted a way to open file folder from SSMS by creating external tool. But, it was only opening the file folder in windows explorer and then file needs to be located in that folder which needs some key strokes. So, I changed the command to open...
|
|
-
|
|
This post is created in reference to question asked by Pinal Dave on SQLAuthority. So, If you have not gone through this post, I suggest to read that post first.
XML is good method to combine a string, but when we use the query as described in post and ...
|
|
-
|
|
Today, My friend Nakul has done a nice comparison of sp_helptext v/s OBJECT_DEFINITION in this post. As Nakul's other posts this post is also very well documented and easy to understand.
Before reading this post I was not aware that sp_helptext can be u...
|
|
-
|
|
In one of our applications delta table is used to track changes. This delta table for one entity which also holds information for anything is added/deleted and updated for this entity and so this delta table gets updated by many related tables. For exam...
|
|
-
|
|
Open File Folder or by shortcut ( Alt+T,O, Enter).
If there are any unsaved file, it will first ask to save those files and that's little annoying thing using this workaround....
|
|