Would be a good April Fool's question...:-D

SELECT INTO does place locks on system metadata, which can cause issues for users, until the SELECT INTO completes. INSERT INTO can be minimally logged by using a TABLOCK....

100% over couple hundred servers, for DR, maintenance, continuity. SQL 2012 mostly. Data warehouse is all solid state with Kaminario All-Flash Array. 😎

Thanks, it doesn't bother me but I don't want to affect other users! Good to hear someone else has seen this. Thought about creating a job to run...

These don't work with partitioned tables or indexes. It lists everything on separate rows.

COMPUTE isn't supported in SQL 2012, just FYI... 😀

I think a good test would be to see how many people reading this article do not know what a 'Borg' is? Does a techie have to know scifi?...

A nod to the new Bobby Fischer documentary? Enjoyable cartoon, none the less. 😀

Rudy Panigas (1/21/2011)

---

The code will not work on a cluster unless you run it from the node(s) and not from the virtual SQL server.

Give it a try and let...

Grant Fritchey (1/14/2011)

---

homebrew01 (1/14/2011)

---

The 3rd party backup tools "object recovery" would only work if the current backup was taken by them. You can't use them after-the-fact. I know Idera's...

Gitmo, cool! Sean did a great job on that table. I have programmers I show it to that still use SQL date functions against the table. :w00t:...

This is mentioned in my post Calculate U.S. Holidays at [/url]. I just added a column is_workday to Sean's existing script, then made my holiday script. Hope that...

Isn't Voldemort evil? J.K. Rowling must be freelancing...and the MulletDB is hilarious!

Call free weekend is a good Christmas wish! Thanks for your informative website and hard work. 😎

Hey Sean, I still use this wonderful program at work! Last year I added a is_workday column to flag for holidays. And created a script to generate the...