Like I said, capture the wait statistics that occur during the process. That will tell you what's running slow. You'll have to figure out why.

Look to the row estimates. I'm sure that's probably the issue. The 2014 cardinality estimator is new and if you're seeing differences in execution times, it could be because of...

PHYData DBA (3/16/2015)

---

Grant - I love this article and you are spot on correct.

However I have never read anything that made me think of Star Wars II so much.

You know...

Maybe it's using the IP address. Try that. In general, you won't use the database name to connect from Management Studio. Just the server name. It's also possible you're AD...

The log backup just reclaims the space for committed transactions within the log. It doesn't affect the size of the log at all. If you do need to reduce that...

Dan121 (3/16/2015)

---

Scott, my concern is a size of a row. As Grant said UNIQUEIDENTIFIER is 16 bytes. if I have 503 columns with datatype 'UNIQUEIDENTIFIER' and rows are empty, will...

dan-572483 (3/16/2015)

---

I'm surprised that discussions of whether or not to keep an index seldom include a look at what is generating the query using the index and how important speed...

Without seeing the queries involved, I'm just guessing.

But, it is possible that eve if it's just getting scanned, it's still useful. Let's say your clustered index consists of 1000 pages...

Thanks for the update.

I'd strongly suggest you look into database design and normalization processes. Using referential tables you shouldn't be looking at tables with 100 columns, let alone 10000. Louis Davidson is one...

ricardo_chicas (3/16/2015)

---

Thanks

What is really annoying is that I even trimmed the query as to return the same column where I have the clustered index on..

I know that the solutions provided...

ricardo_chicas (3/16/2015)

---

Yes, those are local variables

The option(recompile) or the optimIze hint work, but, MS SQL shouldn't be doing this, I have a clustered index for a reason, I need to...

The idea behind a cluster is to have two machines, one running all your databases, and one standing by. If something happens to the first machine you get an automatic...

Are @lowerlimit and @upperlimit local variables or parameters? If they're local variables, you're probably seeing, well, the opposite of parameter sniffing. it's using average values rather than specific values against...

I'd probably reverse build on this. If you need to manipulate files and do t-sql, I'd write it in PowerShell and call the T-SQL from there rather than trying to...