patrickmcginnis59 10839 (9/4/2013)

---

I think that the scaling is clearly an interesting issue, with today's tech, I would keep the high proctoring ratios and then utilize technical leverage for the actual...

facemann (9/5/2013)

---

Yes, I guess I do mean to export the data. We have an old VB script that exports all the data and objects once a week. This...

Without knowing what's happening inside those UDF's, it's hard to say whether or not it would affect performance. I'm willing to bet money that there's some type of "security" check...

The most honest suggestion I can make, don't run it at all. The DTA recommendations are usually weak, at best. Sometimes they are down right frighteningly dangerous. I am a...

It doesn't matter if that login doesn't have permission to show execution plans. You can query the dynamic management objects (DMO) to get the plans from cache.

But, I'll bet it...

Honestly, it sounds like you might be way over your head on this one. I'd suggest bringing in someone with SQL Server experience. A good consultant should be able to...

You're already on to the better tool for the job. The index_usage_stats will show you, pretty much, what is being accessed, but, if you have monthly or quarterly or some...

Do you mean an export of the data?

I'd look at Powershell to do this. You can have it walk the user tables of a database and generate export files for...

ScottPletcher (9/4/2013)

---

I admit, this is my pet peeve in physical table design. Identity as clus key is ridiculously over-, and, thus improperly, used. So I get nervous about...

ScottPletcher (9/4/2013)

---

I'd disagree even with...

DaveDB (9/4/2013)

---

Thanks for the reply.

So, would you say that it makes more sense to have a clustered index on a column besides an ID column? Seems like that would be...

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my actual job....

PiMané (9/4/2013)

---

Just one more thing, probably a "stupid" question but here it goes anyway 😉

Temp tables created with SELECT .. INTO #temp FROM ... and then create clustered index ......

Loading & querying XML is expensive, especially with regards to memory. But, if you're already loading it, then it's not that much more expensive to use it twice. However, if...

#temp tables have statistics. It's table variables that do not have statistics.

Here's a question. Will more than one user be running this query? If so, using a permanent table will...