Totally wild stab in the dark, but what's the fill factor on the index?

santoshkal (10/9/2014)

---

If we create composite clustered index on all columns does it effect any thing ??

when i run the query it always taking non clustered index scan on execution plan...

It's hard to argue with that. If you don't need it, don't create it.

The key point is that the execution plan for a batch is created all at once. Even...

That's a measure of an estimate in comparison to measures of other estimates. There...

sqldriver (10/9/2014)

---

Grant Fritchey (10/9/2014)

---

The average range rows and the equivalent range rows seem to be pretty accurately distributed. They're extremely close to being roughly the same, except for that 38...

I wouldn't suggest passing the value as a string. You're potentially taking away the ability of the optimizer to use parameter sniffing (a good thing the majority of the time)...

Just so we're clear, those really are two very different queries. One references a single table. The other references two tables.

I agree with the other comments, but I think...

You can get a determination of the performance and usefulness of an index three ways. First, you measure the time on a given query before and after applying the index....

I like Eddies rules. The one thing I would add is that, unlike 2000, in 2005 and up, you're going to see statement level recompiles, not procedure level recompiles (unless...

The average range rows and the equivalent range rows seem to be pretty accurately distributed. They're extremely close to being roughly the same, except for that 38 outlier.

The statistics are...

You've created 100,000 rows, but they are in 1,000,000 buckets in your hash. That's a lot of empty space that's going to be scanned. I'd guess that's why you're seeing...

Nice work.

And well done on asking for help the best way possible. Keep coming back and asking for help like that and I know you'll receive it on this site.

The one tool I've used for the last fourteen years is SQL Compare[/url]. This is such a common task, it makes sense to get a tool that will do the...

Create a WHILE loop without an exit and keep updating a row over and over. It won't be fast, but you'll see the transaction log grow. Make sure you use...

djj (9/30/2014)

---

SQLRNNR (9/29/2014)

---

Along the same line of thinking, you need to tell them what they want to hear. If you seed the idea and make it theirs, then when...