Daniel Auger (9/4/2009)

---

Here is a good description of N + 1:

http://nhprof.com/Learn/Alert?name=SelectNPlusOne

EDIT: I will add that Select N + 1 is not a problem that directly stems from using an ORM...

Daniel Auger (9/4/2009)

---

I can see the argument against table level access whether the danger is real or perceived (I think it varies from shop-to-shop). That being the case, it may...

Ah, you know what it might be? One guy in my office (and he's the only one for some reason), has a lot problems with files getting saved with the...

Hmmm... No. I haven't seen that one. Is it possible that there's a difference in the server or database collation? That might lead to something like this.

So this section means that you can not run the Powershell extension on a 2000/2005 instance?

You must use the SQL Server 2008 client components to run SQL Server features for...

Hey Jack,

I haven't tried this on 2005 yet, but I assume you've got to do a seperate install of PowerShell, then the SQL Server extensions. After that, you should be...

Are you running the DTA against the production server? I hope not. If you're running it against another machine, you may need to validate that it has all the exact...

It looks like something in the TSQL, not the network. Can you post the whole query?

luckysql.kinda (9/3/2009)

---

run following commands to clear your cache

DBCC FREEPROCCACHE

DBCC FREESESSIONCACHE

Run your query and inform us how much time does this take? Also use task manager and job monitor to see...

I'd suggest capturing the execution plans to see what is occurring.

However, it sounds like the data was being moved into cache. You can pretty frequently see a query run much...

Could it be a language issue? Is BOL translated...

Elliott W (9/3/2009)

---

I've got kind of an off the wall question, aren't businesses fleeing from states like MA and CA, aren't they even further down than other states in this...

sturner (9/3/2009)

---

Performing a number of DBA type duties can be done sans TSQL, but I would never hire someone as a DBA managing large amounts of critical data unless they...

Running a server side trace is the best thing you do for yourself. Capture the queries as they're made and see which ones run slow and when. Read Gails articles...

Combining views is not dissimiler to joining views or nesting views. It all leads to poor choices by the optimizer due to the complexity of the plan when the optimizer...