It really has nothing to do with SQL itself, it is simple logic.

Let's look at the first part of the WHERE clause:

This part is...

Also, is it possible that data may be deleted that may result in sequence numbers changing? Such as id 221777 in your sample data being deleted. Would 221778...

Okay, but that isn't an advantage. As for using it as a key, by itself, it isn't because it will duplicate with the id it is assigned. What...

Curious, what is the advantage of not having any gaps in the sequence numbers?

😎

My oldest two daughters (a senior and a freshman) go to a high school where every student is issued a laptop. They have a product installed that will locate...

The server-side trace will catch all events that it is set to monitor. It is also designed to limit the impact of tracing a SQL Server which is why...

Here is an example. I backed up the AdventureWorks database to AdventureWorks.bak, and the following code is restoring the database as AdventureWorksDB1:

RESTORE DATABASE [AdventureWorksDB1]

FROM DISK = N'C:\Program Files\Microsoft...

Sounds too much much like physical labor, I'll stick with working with computers. It's just like like working with...

I wish I had a server configured where I could test it out. I'm just going on what I have read about databases and physical design. I think...

I'd also take a close look at each recommendation. You may actually find overlapping indexes that could be merged into a single index.

I also agree heavily with testing all...

I'd say if you can put the nonclustered indexes on a seperate filegroup on a seperate set of disks, you should. You can take advantage of parallel IO's between...

>= dateadd(dd,...

bhovious (8/26/2008)

---

Hey Graeme 🙂 My wife is still in U.S. education (PreKindergarten-1st Grade) and it keeps getting scarier. Teachers are now expected not only to...

Could you provide the DDL (create statements) for the table, some sample data for the tables (in the form of insert statements that can be cut, paste, and run to...

Jeff Moden (8/25/2008)

---

skenzie (8/25/2008)

---

And thanks Jeff for spurring me on, even at my age....heh heh. I'm going to apply for the job but making it clear I have no actual...