Not quite fineprint, but sure feels like it!
Quotename can be a pretty cool function to simplify your dynamic sql, as...

2015-09-23

384 reads

SQL Server’s TIMESTAMP Is Not What You May Think It Is. - Syndication – WaterOx Consulting

by Chris

WaterOx SQL

TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it...

2015-09-23

984 reads

Pratical Use of a SQL Server Database Snapshot

by Chris

cjsommer.com

I was doing a database code deployment the other night and the first step in the release plan was “Take...

2015-09-29 (first published: 2015-09-23)

7,315 reads

I’m Speaking! SQL Saturday #431 – Spartanburg

by John

John Morehouse | Sqlrus.com

As I’ve mentioned before, living in Louisville offers up great opportunities to various events within the SQL Community. This weekend...

2015-09-23

535 reads

Predicate Order is Critical

by Jason Brimhall

SQL RNNR

I want to drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining...

2015-09-23

53 reads

Predicate Order is Critical

by Jason Brimhall

SQL RNNR

I have mentioned predicate order previously and wanted to make sure I drive home the importance of the predicate order...

2015-09-29 (first published: 2015-09-23)

3,198 reads

“sql_handle” is not a recognized table hints option.

by Kenneth Fisher

SQLStudies

I’ve you’ve run a query similar to the following:
SELECT *
FROM sys.dm_exec_requests
CROSS APPLY sys.dm_exec_sql_text(sql_handle);And gotten an error similar to:
Msg 321, Level...

2015-09-23

1,049 reads