The notion that book indexes and table of contents are analogous to SQL clustered index and non-clustered index doesn't match up well with SQL indexes. Both clustered and non-clustered indexes...

Great code but difficult to implement with security concerns.

If available to you: Polybase (SQL 2016) or FileTable(SQL 2012)

I have not yet the pleasure of using Polybase, but have implemented a...

As Ryan pointed out the real problem is with the query dataset not being utilized for subsequent page calls. The cost is in preparing the dataset, not in grabbing a...

Noel,

Gotta thank you for your notion of using OutLook to validate and standardize. Really good.

For simple string parsing I've been experimenting with CROSS APPLY. I like it because, once...

I prefer Information schema when I need a copy of code. But I only use it to search across all objects looking for that something I can't remember which database...

Nice. Big win for maintenance. Smaller so a bit faster to develop. Smaller code a bit better compiler performance. Same query plan, no harm.

Thanks

I'm stunned by the amount of effort required to use SSIS to push data out. Underneath it is simply a connection string, a sql statement, a destination, and some amount...

Great stuff. As to why transpose, here is an OLTP example.

True transpose is useful to simplify several patterns. My fav was a test specification system where new tests came an...