Nice script, but I'd argue this isn't using T-SQL. It's using a shell command, which isn't allowed in many places.

Interesting concern. AFAIK, the sparse file doesn't actually allocate the space until it's needed, so while it might report 25GB as a size, it isn't using that space.

Fragmentation? Interesting, I...

Robert Davis (2/15/2012)

---

for example, if someone tells me that they didn't prepare at all, that they just walked in and took all of the Pro level exams, then I...

The only way to do this is if you have a way of marking what new data is. Perhaps some column that marks when things have changed.

There are plenty of people using braindumps, plenty that memorize some things, and plenty that use their knowledge.

A certification isn't worthless. You use the interview to determine if someone actually...

Koen Verbeeck (2/15/2012)

---

If it was an interview question, I sincerely hope for him he didn't pick choice 2...

Go here: http://mslicense.com/

Short answer: contact MS. Ultimately they have the final say since they can sue you for non-compliance.

Longer answer: My reading, and understanding, would be that accessing SQL Server through any...

http://msdn.microsoft.com/en-us/library/ms188670.aspx

Be sure you publish the times of the restores. I assume you'll automate this, which will mean killing connections, so I'd test the restore times of logs, then allow a...

The main SQL Server vendors seem to be Red Gate, Quest, Idera, and SQL Sentry, all of whom have a variety of tools. There are others, but those seem to...

My apologies, this slipped off my radar this morning.

The issue is the person you were trying to send to had a name of " Dev" (pre-pended space) and the other...

Steve Jones - SSC Editor (2/14/2012)

---

Jeff Moden (2/13/2012)

---

Shifting gears, I was going through the posts from "Posts added today" and there had to be two dozen posts from "Site Owners"...

Thanks for the complements and glad you like the site.

T-SQL Tuesday is the second Tuesday of every month, and there's a different host every month. There's a Twitter hashtag of...

How up to date do you need the reporting systems?

A few notes. Replication is great for this, but it can require schema changes. If you don't think GUIDs work for...