SQL Server v.Next (Denali) : Will you use EOMONTH()?
In SQL Server 2012, we have a new date-related built-in function called EOMONTH – it comes straight to us from VBA, so many Excel and Access users will know exactly what it does. For...
In SQL Server 2012, we have a new date-related built-in function called EOMONTH – it comes straight to us from VBA, so many Excel and Access users will know exactly what it does. For...
Where is SYSDATE()? I've talked about this one before, but due to a recent conversation about building a datetime value from separate date/time columns or variables, it may be worth bringing up again. When...
In some circles I'm known as "the Connect guy" because I've filed a heck of a lot of suggestions and bugs that I've envisioned or encountered, and I'm often willing to file an issue...
Read about some date/time shorthand you should avoid.
Last night, the SQL Server Release Services Team published Cumulative Update #6 for SQL Server 2008 SP2: http://support.microsoft.com/kb/2582285 There are 13 fixes listed, and the build # is 10.00.4321. NOTE: This cumulative update is...
This evening Microsoft released cumulative update #16 for SQL Server 2008 SP1: http://support.microsoft.com/kb/2582282/ There are only seven fixes listed, and the build # is 10.00.2850. NOTE: This update is NOT for SQL Server 2008...
See why you should use sp_executesql instead of EXEC() for running dynamic SQL strings.
See an example that defies a generalization about performance of getting the largest value in a column.
UPDATE 2016-10-07 – This demo kit has been overhauled: https://sentryone.com/blog/aaronbertrand/plan-explorer-3-0-demo-kit