GilaMonster (4/13/2015)

---

IF EXISTS (SELECT 1 FROM TableName)

...

GilaMonster (4/13/2015)

---

Sean Lange (4/10/2015)

---

sql-lover (4/10/2015)

---

Is this an accurate way to get row count?

SELECT

t.name table_name,

s.name schema_name,

p.rows AS total_rows

FROM sys.tables t

join sys.schemas s on (t.schema_id = s.schema_id)

join sys.partitions p on (t.object_id =...

Eirikur Eiriksson (4/11/2015)

---

sql-lover (4/11/2015)

---

Eirikur Eiriksson (4/11/2015)

---

sql-lover (4/11/2015)

---

Grant Fritchey (4/11/2015)

---

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the...

Eirikur Eiriksson (4/11/2015)

---

sql-lover (4/11/2015)

---

Grant Fritchey (4/11/2015)

---

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to do...

Grant Fritchey (4/11/2015)

---

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to do it is COUNT....

Thanks for the responses so far.

I need 100% certainty. The DMV/count is needed to identify the table(s) with an empty set. A massive DDL change will be deployed against those...

I know this won't answer your question but why you are still running SQL 2000? If I was you, I would put all my effort and convince upper management that...

I've been using it for several years now, it does not allow you that, by...

I fixed it. Even though I wrote the query in 3 different ways the performance did not improve, in fact, it got worse. I always try to fix performance issues...

Eirikur Eiriksson (3/31/2015)

---

Post the full query, the table structure...

There is an ORDER BY , but I did not post it. But the TOP and ORDER BY are there just for testing. They actually do not exist in the...

Luis Cazares (3/31/2015)

---

As previously said, you can use a cross apply.

I'm leaving both options. Note that the join needs to calculate all the values before joining and that's why it...

I am trying to eliminate the subselect.

Anyway, I was able to convert it to an INNER join, but it actually performs slower.

Found the answer via Google:

https://technet.microsoft.com/library/Cc917715

But Aaron confirmed.

I will quote what technet says, the relevant part:

The indexed view can be used in a query execution in two ways. The query can...

Lowell (3/13/2015)

---

i beleive groups are a function of the mails erver, which generates individual copies of the email to people assinged tot eh group that the smtp alias points to;

i...