Steve Hindmarsh's SQL Blog - All Comments

Weekly Challenges – 3/27/11 « SQL Feather and Quill

Weekly Challenges – 3/27/11 « SQL Feather and Quill — Mon, 28 Mar 2011 04:14:06 GMT

Pingback from Weekly Challenges – 3/27/11 « SQL Feather and Quill

re: Do you send output from sys.dm_exec_query_stats to your developers ?

thomas.pullen — Wed, 23 Mar 2011 15:19:41 GMT

Very nice Steve, very handy and a good idea.

Tom

Twitter Trackbacks for The Exceptional EXCEPT clause - Steve Hindmarsh's SQL Blog [sqlblogcasts.com] on Topsy.com

Fri, 04 Feb 2011 12:10:33 GMT

Pingback from Twitter Trackbacks for The Exceptional EXCEPT clause - Steve Hindmarsh's SQL Blog [sqlblogcasts.com] on Topsy.com

re: Free Microsoft one day BI Seminar in Reading

DavidWimbush — Fri, 28 Jan 2011 15:07:05 GMT

Thanks for the tip-off, Steve. I hadn't seen this one but now, thanks to you, I'm going.

The under-used OVER clause!

Martin Bell UK SQL Server MVP — Sun, 23 Jan 2011 13:38:04 GMT

You may be familiary with using the OVER clause with a ranking function, but how many people know it can be used with an aggregate function?

re: The overlooked OUTPUT clause

steveh99999 — Fri, 21 Jan 2011 14:28:21 GMT

Very true Colin, the other 'new feature' I see being ingnored surprisingly ofen is TRY..CATCH - is this just my experience ?

re: The overlooked OUTPUT clause

GrumpyOldDBA — Fri, 21 Jan 2011 13:20:16 GMT

It's a vital part of merge too. I'm sometimes surprised on how slowly new aspects/features are used - we often update to the newest versions but remain enshrined in the constraints and code of the version we used three generations ago.

SQL Server Blogs and news for the week 21/01/11 | John Sansom - SQL Server DBA in the UK

Fri, 21 Jan 2011 11:47:57 GMT

Pingback from SQL Server Blogs and news for the week 21/01/11 | John Sansom - SQL Server DBA in the UK

re: The overlooked OUTPUT clause

MartinBell — Tue, 18 Jan 2011 21:47:37 GMT

I've get several blog posts on OUTPUT. The great thing about using OUTPUT is that you can often get rid of triggers by using it, this can makes code more transparent.

SQL Server Links and news for the week 01/10/10 | John Sansom - SQL Server DBA in the UK

Fri, 08 Oct 2010 10:53:52 GMT

Pingback from SQL Server Links and news for the week 01/10/10 | John Sansom - SQL Server DBA in the UK