The WHERE clause has to precede the GROUP BY clause.

Cheers!

Jeff Moden (11/9/2015)

---

Jacob Wilkins (11/9/2015)

---

Keep in mind sp_spaceused doesn't report the size of a clustered index as part of "index_size". If the table in question has (is) a clustered index,...

Keep in mind sp_spaceused doesn't report the size of a clustered index as part of "index_size". If the table in question has (is) a clustered index, and you're trying to...

sys.dm_db_index_usage_stats also has information on heaps.

That's easy enough to confirm:

CREATE TABLE MyTemporaryHeap (id int)

--Let's perform a user update

INSERT INTO MyTemporaryHeap

SELECT 1

SELECT last_user_lookup, last_user_scan, last_user_seek, last_user_update

FROM sys.dm_db_index_usage_stats

WHERE database_id=DB_ID() AND object_id=OBJECT_ID('MyTemporaryHeap')

--Now...

I'll just throw another +1 to the "I think you should avoid syntax errors". Sure, you could fix the CREATE statements offered, but that's quite a stretch. Even then, "should"...

Thanks, good...

You can use PATINDEX and SUBSTRING do something like this.

The trick would just be to make sure you've identified a pattern or set of patterns that captures all instances of...

Well, just to be clear, there's no way to control the duration of an automatic checkpoint.

For a manual checkpoint, you can specify a target duration. From https://msdn.microsoft.com/en-us/library/ms188748.aspx:

checkpoint_duration

Specifies the requested amount...

I typically prefer keeping the drives under 2 TB (partially because I work a lot with virtual machines in VMware, and past 2 TB adding space to a drive requires...

You can just query sys.indexes for that, looking for the object_id of your table, a type=1 (clustered), and is_unique=0.

Something like this:

CREATE TABLE YourTable (ID int)

CREATE CLUSTERED INDEX CI_YourTable_ID ON YourTable...

If the goal is just to take the employee's original start date, add 20 years, and then add any days they were inactive, then here's another way, using J Livingston's...

If I'm understanding this correctly ,that's just because when only 1 row is returned for a LID after the WHERE clause criteria are applied, then the 1-row LIDs trivially have...

I'm glad we could help!

It may be rather academic, but there is at least one case where EXISTS is nicer than a JOIN.

The potential (emphasis on potential) performance advantage that EXISTS has is the...

One way is to CROSS JOIN the users and all possible IDs, and then use NOT EXISTS to only return those possible combinations that don't have a match in the...