Count has no place in an IF EXISTS check. EXISTS doesn't care about the columns, hence why SELECT 1 is often...

IF EXISTS (SELECT 1 FROM TableName)

...

Alan.B (4/10/2015)

---

Ok, quick update... I did some research on this - it appears that sys.partitions does not guarantee an accurate row count. According to Microsoft, the rows column in sys.partitions...

You don't need a TOP 1 in an EXISTS subquery.

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 = p.object_id)

WHERE...

No, you want the equality first and inequality second and it does not depend on cardinality and distribution of the data.

If you put the equality first and the inequality second,...

A good backup.

Extended events or the sys.dm_db_session_space_usage DMV which tracks tempDB usage per session (not per table, just overall space...

Luis Cazares (4/10/2015)

---

Someone just mentioned that you could have 2 clustered indexes on a table. But I'm sure he's high. 😀

http://www.sqlservercentral.com/Forums/FindPost1676220.aspx

But, think about it, what if you're in situation where,...

Work deadlines and other stuff. Sorry, will do better next month

I could use a few other phrases at...

RonKyle (4/10/2015)

---

assuming the table is not a heap (which it shouldn't be, right?), why would it (at least as a general rule)...

Furthermore, you have a non-optimal query form.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

In that case they're pretty much going to behave much the same way for any query that filters on person_id. Use the...

Grant Fritchey (4/10/2015)

---

RonKyle (4/10/2015)

---

Interesting. I haven't personally made much use of include indexes since they do make the indexes bigger and I'm not convinced the performance gains are significant....