You can run the Database Tuning Advisor, but be careful with the recommendations. Go slow and add one index at a time. This will give you some ideas of what's...

Search for dynamic PIVOT or crosstab on the site here. Jeff Moden has a good piece that might help you here.

I suspect the installation failed. Might try repairing the install from setup.

Koen Verbeeck (4/28/2015)

---

Steve Jones - SSC Editor (4/28/2015)

---

Had a funny one today. On the DLM webinar I did with Grant, we had a guy ask how to recover a master...

Server or database level?

here are a few items:

http://www.sqlservercentral.com/scripts/Security/62064/

http://www.sqlservercentral.com/scripts/Security/66129/

Had a funny one today. On the DLM webinar I did with Grant, we had a guy ask how to recover a master database and another one show an error...

rustman (4/28/2015)

---

It is amazing to me how people's career paths can be so different at times and then others are similar...I too started my IT career as a Novell Administrator...

Ralph Hightower (4/28/2015)

---

In the "Understand the True Source of Problems" article:

2 – NOLOCK is required on every query. It makes things run faster.

Instead READ_UNCOMMITTED is suggested.

At one place I worked...

Gary Varga (4/28/2015)

---

I am certain that as an industry that we reduce our productivity over the longer term due to ignoring root cause analysis or, sometimes more frustrating, ignoring the...

Notifications default to the last setting you posted with. It's a simple switch. You post, we use what you last choose. If you change it, we change it for the...

Ah, sorry. Missed that multiple times.

Fixed

Take it and submit something. would like to see something here.

define sales > 0. You have multiple years.

You can add a HAVING clause to the end. Read up on that.

Just a joke on the exercise for better...