Read that in SQL 2012 version, the cache Identity values are lost during a sudden restart or service failure. check this [http://msdn.microsoft.com/en-us/library/ms186775.aspx][1] [1]: http://msdn.microsoft.com/en-us/library/ms186775.aspx...

Have you ever tried to write T-SQL code that conforms completely to the ISO standard? Since Microsoft SQL Server's T-SQL standard is based on the ISO standard, doing so is quite possible. Today, I explore the ISO equivalents of the EXISTS keyword - SOME...

using 'Import and Export Data' wizard....

Both SP_who and SP_who2 provides information about the current processes/sessions/users in an SQL servert instance. - SP_WHO: SP_WHO provides information like Session ID, Logged in User id , Host name, session status, blocking process ...

The ROWVERSION column is an auto-incrementing number. The MIN_ACTIVE_ROWVERSION() non-deterministic function can be used to fetch the lowest active ROWVERSION value in the current database....

The ROWVERSION column is an auto-incrementing number. The MIN_ACTIVE_ROWVERSION() non-deterministic function can be used to fetch the lowest active ROWVERSION value in the current database....

Hi, Another approach using LEFT AND RIGHT , select SUM( CAST (LEFT(RIGHT(@i,LEN(@i)-(number-1)),1) AS INt)) from master..spt_values ...

Sql server ignores trailing spaces while comparing using WHERE and HAVING clauses .However this behavior is different for LIKE clause....

Sql server ignores trailing spaces while comparing using WHERE and HAVING clauses .However this behavior is different for LIKE clause....

Have you ever worked on troubleshooting an issue for hours (or maybe days) at an end only to find that somebody else from the team has either faced the issue before or could have helped you with just 10 minutes of their time? This post is based on a rea...