Go to redgate.com. If memory serves, they have a free tool that will read a SQL Server 2000 transaction log file (if your database is using the full or...

GilaMonster (9/3/2008)

---

The problem with this is that the repeated (Column = Variable or variable = constant) expressions confuse the optimiser's estimations of rows affected (on 2005 definitly, not sure about...

What this does (colOne = @num1 or @num1 = 0) does is create a conditional where clause statement. If the value of @num1 = 0, you get all rows...

Geez, get side tracked by work for a couple of minutes and someone beats me to...

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...