Monthly Archive: September 2011

SQL Server v.Next (Denali) : Will you use EOMONTH()?

SQL Server v.Next (Denali) : Will you use EOMONTH()?

In Denali we have a new date-related function called EOMONTH() – it comes straight to us from VBA so many Excel and Access users will know exactly what it does. For those that don't,...

Connect Digest : 2011-09-22

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!

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

Bad Habits to Kick : Using shorthand with date/time operations

I've come across quite a bit of code that uses date/time shorthand that can either be confusing or downright dangerous. There are two areas I want to focus on: shorthand for date arithmetic, and...

Cumulative Update #6 for SQL Server 2008 SP2 is available

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

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

Bad Habits to Kick : Using EXEC() instead of sp_executesql

Today in my T-SQL: Bad Habits to Kick session at SQL Saturday #84 in Kalamazoo, a user asked if SQL Server supported anything like bind variables in Oracle when using dynamic SQL. When using...

Why generalizations are dangerous

Why generalizations are dangerous

A couple of years ago, John Sansom wrote a blog post comparing the performance of two different ways to get the maximum value from a column: MAX() and TOP (1). http://www.johnsansom.com/performance-comparison-of-select-top-1-verses-max/ In the conclusion,...

A demo kit for SQL Sentry Plan Explorer

A demo kit for SQL Sentry Plan Explorer

UPDATE 2016-10-07 – This demo kit has been overhauled: https://blogs.sentryone.com/aaronbertrand/plan-explorer-3-0-demo-kit/ Plan Explorer is a free application from SQL Sentry, designed to make execution plan analysis faster and easier. It was developed in response to customer...