Profiler always has some hit to the system when it's in use. If you use the GUI on the server, that's bad (I've nearly brought down a production server...

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

Brandie Tarvin (1/20/2016)

---

Jacob Wilkins (1/19/2016)

---

Eirikur Eiriksson (1/19/2016)

---

GilaMonster (1/19/2016)

---

*sigh* All but one comment on a blog post are of the form 'Did you try X?' 'Have you compared Y?' 'Probably should...

Just checked on my SQL2012 / SSMS 2012, and no, there's still no indication if an index is disabled, until you click into the properties.

Paintball is getting more and more complicated...

I wonder if it'll work with Express or if it needs Enterprise?

Los Angeles

It was easier than I thought, going through the MSDN list of server and database audit action groups and cross-referencing them to the trace audit items I'm required to have...

Now...

Ed Wagner (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

rodjkidd (1/8/2016)

---

Brandie Tarvin (1/8/2016)

---

Here's a funny. The notification algorithm sent me an email from askssc.sqlservercentral.com telling me that I'd been mentioned in someone's query. But I...

I've actually looked at and tested that script to see if it would cover what I need to audit with XEs. The problem is, right up in the comments...

You can start with RESTORE HEADERONLY to get the basic information.

To have it cycle through all the BAK files in a location, you're best bet would be to...

Glancing at the online edition of one of the local Detroit papers, I find out that a golf course I enjoyed playing (although I haven't gone in a couple years...

I did the dumbest thing over this past weekend...

As I had a 4 day weekend (woohoo!) I didn't get to sleep anywhere close to my usual time, instead I was...

BrainDonor (12/30/2015)

---

Brandie Tarvin (12/30/2015)

---

BrainDonor (12/30/2015)

---

Phil Parkin (12/30/2015)

---

Certainly did. And invented a new noun, the "scree-shot"...

Brandie Tarvin (12/30/2015)

---

Ed Wagner (12/29/2015)

---

I'm surprised that Flint didn't make the list. Oh...wait...that's probably because there isn't anyone left in Flint. 😛

Saginaw, for a city of...