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...
Monthly Archive: September 2011
Connect Digest : 2011-09-22
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...
Want your bug fixed? File a good bug!
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...
Bad Habits to Kick : Using shorthand with date/time operations
Read about some date/time shorthand you should avoid.
Cumulative Update #6 for SQL Server 2008 SP2 is available
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...
Cumulative Update #16 for SQL Server 2008 SP1 is available
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...
Bad Habits to Kick : Using EXEC() instead of sp_executesql
See why you should use sp_executesql instead of EXEC() for running dynamic SQL strings.
Why generalizations are dangerous
See an example that defies a generalization about performance of getting the largest value in a column.
A demo kit for SQL Sentry Plan Explorer
UPDATE 2016-10-07 – This demo kit has been overhauled: https://sentryone.com/blog/aaronbertrand/plan-explorer-3-0-demo-kit