How many rows are in the table ?

How many rows does the query above really return ?

What do your indexes look...

Paul White NZ (4/28/2010)

---

kinzent (4/28/2010)

---

You say "The fact is that data is neither stored nor retreived in precise order" , but when there is a clustered index on one column,will...

apat (4/27/2010)

---

Hey All,

I have one huge table with billions of records. Just curious, If I separate data from that table in 10 tables and create clustered index on all the...

The statistics might affect the chosen query plan.

The query plan might affect the order of the returned rows.

If the order of returned rows is important for you, you MUST specify...

Please dont use the xml-based method if you...

Paul White NZ (4/27/2010)

---

On string splitting and performance:

There was a *huge* thread on this last year on SSC. Florian Reischl was good enough to post a very comprehensive set...

Andy Lucas (4/27/2010)

---

Are you sure that is correct? I get a different result from your original method.

And it takes a lot longer than 29 secs - more like 79 on...

EDIT: Please ignore this post. My performance test was flawed.

It gave totally wrong results because I was using a test table with 1000000 identical strings. With that test data...

I would recommend using an inline table-valued function instead.

Like this:

-- Generate numbers between @start and @end

create function [dbo].[GetRange](@start int, @end int) returns table as

return

select top (@end-@start+1) (row_number() over(order by...

try sys.dm_exec_query_stats

dtipser (4/23/2010)

---

Hi,

I have two databases on SQL Server 2008, one DEV and other QA with the same structure and very similar data inside. I run the same stored procedure in...

OK, I should have known better than to challenge you like...

This is...

Paul White NZ (4/22/2010)

---

I will continue to promote defensive programming practices, and to encourage people not to rely on seemingly dependable observed behaviours of a particular version of the product,...

This thread actually highlights two different but related issues.

Issue 1:

Fact: The behavior of some very specific constant-only expressions in filters has changed between 2005 and 2008.

My opinion: I consider...