Yeah, that does make a slight difference. OK, let's look at it a different way, have you looked at the wait stats on the server? Are you waiting behind statistics...

I'm more than a bit list too. What error are you getting when you add the column to the CTE. Yes, you should be able to add a column to...

Check the server roles. Sounds like they might be sys admin on the box.

You're going to be hard pressed to find a good, comprehensive training program that is also completely free. How about picking up a book? I was one of the authors...

If you're assigning variables from a SELECT statement you just do this:

DECLARE @FirstVariable int, @SecondVariable int, @ThirdVariable int

SELECT @FirstVariable = FirstColumn,

@SecondVariable = SecondColumn,

@ThirdVariable = ThirdColumn

FROM MyTable

But, that query can only...

Usually others say this, but it's my turn. It really sounds like you're completely over your head here. I'd suggest hiring, even part time, a pro, someone who does this...

If the goal was move things off a file group in order to shrink it, yeah, then you have to shrink it. SQL Server won't automatically reclaim space unless you...

If you have auto update of statistics turned off, then your statistics on your indexes and tables are only good when they get created (or when your rebuild an index)....

Brandie Tarvin (4/20/2011)

---

Steve Jones - SSC Editor (4/20/2011)

---

Grant Fritchey (4/20/2011)

---

I can't comment on the kick-back program as it's currently configured. Suffice to say, if you've received a check, you earned...

Stefan Krzywicki (4/20/2011)

---

opc.three (4/20/2011)

---

Stefan Krzywicki (4/20/2011)

---

I went to the latest SQL Server Saturday in Boston and had a great time. I'm mentioning it now because I've been using a little...

Ah, you'll have to build out a rather large script that can go into a given backup and get the file structure out and then automatically figure out where to...

On this one, I'd get in touch with Microsoft. That sounds like you've run into something serious.

Koen Verbeeck (4/20/2011)

---

I was asked to give a PowerPivot demo in the not so distant future.

I haven't really used it before (but I'm the only BI guy available in the...

Nope, a plan guide won't help. Temporary tables have statistics. As the data changes, statistics get updated. When statistics updates meets certain thresholds, you get recompile events firing. If the...

I would not use affinity unless you've already identified a need to share resources with some other service. Just leave it alone.

I would also leave the max degree of parallelism...