+2

dietztm (5/27/2016)

---

People who say they rarely see bias need to be aware that their lack of perception is not evidence that it doesn't exist. In fact, they are the ones...

Thanks for this thorough and well-written piece on a complicated and often misunderstood topic.

- wbrunner

Thanks for the question! I learned something yet again. DENY and GRANT are really tricky.

- webrunner

[EDIT - I did not invent this code, just remembered that I don't remember where I found it :blush: but it proved useful to me.]

I did this for a table...

Lowell (5/25/2016)

---

In my case, i was bitten by the 2./3.0 when i wax using Export-Csv i think, which added -Appen parameter.

I ended up using a command line call to...

Looks like you're correct:

Name ...

Thanks so much for your response. I will check the PS version now.

I just realized the third error could be a side-effect - i.e., if the file name assignment...

I got this right by guessing but still have no idea why it is the correct answer. Thanks for the question and reference, though, I need to read up on...

Great question. Bob is always causing trouble with the SQL Server.

- webrunner

Thank you so much for this script!! I was going crazy trying to figure out why I was printing something that seemed to be getting truncated in the output.

Much appreciated.

-...

Thanks jeff (mason) for your additional feedback. Much appreciated.

- webrunner

Jeff Moden (5/3/2016)

---

Just a bit of a recommendation based solely on personal experience...

I've found that a whole lot of people spend an eternity on collecting "stats". I've also found...

jeff.mason (5/3/2016)

---

This is the mentality that drives me crazy as a DBA. At my last job they were building a dashboard-type of report and wanted me to give them...

GilaMonster (5/3/2016)

---

There are very, very, very few stats, perfmon, SQL or other, that have a single defined threshold value, whether it be universal or just for your server.

There is 'normal...