Tag Archives: sql server

Searching for Plans

Posted on April 23, 2015 by way0utwest

Today’s editorial was originally published on Sept 13, 2010. It is being re-run as Steve is away at training. I was re-reading Conor Cunningham’s “Does Join Order Matter?” recently and found this quote in the post that stood out. As … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Searching for Plans

Embrace Stored Procedures

Posted on April 20, 2015 by way0utwest

I’ve read a lot of pieces on stored procedures. Most of the articles were for using stored procedures, quite a few were against their use, and a handful with extreme opinions. This piece from Rob Conery, while perhaps NSFW, is one … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Embrace Stored Procedures

ALTER SCHEMA TO ADD PERMISSIONS

Posted on March 18, 2015 by way0utwest

I’m sure some of you have wanted to do this: ALTER SCHEMA Steve AUTHORIZATION Steve You realize this doesn’t work, and you can’t grant the user Steve, rights to his schema after it’s created. You can do this: CREATE SCHEMA … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on ALTER SCHEMA TO ADD PERMISSIONS

The Demo Setup–Attaching Databases with Powershell

Posted on March 16, 2015 by way0utwest

I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases. TL;DR I have a script that detaches all user databases from a SQL Server instance and then reattches certain ones. Full script at … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment