It does depend on the company. Smaller organizations, depending on what they do, may not ever bother with the credit report. I've worked with companies that didn't.

You'll want to read up on the sqlcmd.exe utility. If you are looking to do things through the command line, it's one method. Another would be to use PowerShell. You...

No, there's no formatting of any kind built into SQL Server Management Studio. It does have syntax coloring, but that's it. Any formatting has to be done through other means.

My...

Don't do the ISNULL mechanism. That's going to lead to straight table scans and will not help your performance at all.

If you do want the equivalent of the default trace, but you want to control it more directly, I'd suggest taking a look at extended events. You can have them...

At best, buffer count hit ratio is just an indication of load. And, as you see with Jonathan's test, it's not even necessarily that. Yeah, a very low number of...

SQLRNNR (2/7/2014)

---

jasona.work (2/7/2014)

---

SQLRNNR (2/7/2014)

---

Kinky??

Um no. Just got back from SQLCruise with Grant and...

wolfkillj (2/7/2014)

---

Word is that there are photos of a shirtless Grant from SQL Cruise,...

Koen Verbeeck (2/7/2014)

---

GilaMonster (2/7/2014)

---

Koen Verbeeck (2/7/2014)

---

Ed Wagner (2/7/2014)

---

That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because we...

g.mclachlan (2/7/2014)

---

Thanks guys. i think if I knew what to use them for, then I might be in a better position to choose.

We are a National Library and have...

Thanks. That was a fun discussion. Greg is a great guy.

EXACTLY!

It's going to be a hybridized world, partially hosted locally, partially externally, and partially through various services. It's happening right now and shows every sign of accelerating. I am all...

TheSQLGuru (2/5/2014)

---

Grant Fritchey (2/5/2014)

---

But the FAST (50) hint is also going to impact what gets delivered by the optimizer. It's likely to see what you're seeing, a seek where a...

Assuming I understand the question, yes, that's not only possible, it's the right way to get the job done.

But the FAST (50) hint is also going to impact what gets delivered by the optimizer. It's likely to see what you're seeing, a seek where a scan would serve...