|
|
-
|
|
Warning:- Settings mentioned below are listed by keeping developer workstation in mind. Even if some setting might applicable for live production server, please refrain using the same script or recommendation from this post against SQL production/UAT/QA...
|
|
-
|
|
If SQL agent finds a job running at schedule job start time, agent skips the execution of job until the next scheduled execution time. This can lead to some missing rows. I have tried to demonstrate the same thing below. Step-1 Create a Job with runs e...
|
|
-
|
|
Many times this question comes to me in past and today I got a call from my friend working in previous organization for same thing. Same question is asked in MSDN forum also. So I decided to document this.
We can clear the recent items from the cache by...
|
|
-
|
|
As we know that, No order guaranteed if order by is notf explcitly specified. Below is one more example of this.
Below is the code to pupolate dummy table.
If OBJECT_ID('dbo.testTable') is not null
drop table dbo.testTable
Go
Create table dbo.testTable
( c1 int not null,
c2 int not null,
......
|
|
-
|
|
Output clause has been added to SQL 2005 which can mainly used to grab the identity values. This has been really helpful addition to SQL 2005. You can get more information regarding output clause here.
I have faced couple of incidents in last six months involving use of output clause and trigger wh......
|
|
-
|
|
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....
|
|
-
|
|
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...
|
|
-
|
|
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...
|
|