![LAG-ging Behind [T-SQL Tuesday #029 - Let's have a SQL Server 2012 party]](http://sqlity.net/en/wp-content/uploads/2012/04/LAG_Example_1_Result-150x118.png)
This article introduces and explains the new LAG function in SQL Server. It also shows how to use it for SQL Server wait time analysis.
Apr 102012
Apr 092012
TitleIndex Internals – How SQL Server stores and accesses data When12.April.2012 um 18:00 Where 70. Treffen der SQL PASS Regionalgruppe Hamburg Gasstraße 6 22761 Hamburg Microsoft Deutschland Geschäftsstelle Hamburg
Apr 072012
Trying to directly calculate MAXINT for the BIGINT data type in SQL Server will either cause an arithmetic overflow error or produce inaccurate values. This article explains how to calculate this value accurately.
Mar 272012
In the March issue of SQL Server Pro Itzik Ben-Gan wrote about an undocumented DBCC command that was recently discovered in the wild by Eladio Rincon (http://www.sqlmag.com/article/sql-server/options-affecting-parallelism-141505). Itzik closed the article by expressing his hope to get this statement documented as it can be very helpfull to database professionals trying to performance tune a query more »
Mar 202012
When thinking about the indexes for update statements it is easy to overlook an important peculiarity in the way SQL Server finds the rows to update before updating them. Those pesky Lookups If you have an UPDATE statement that filters on two columns and you have an index on one of them, you might be more »
