One thing I missedin your post.

A tran log backup doesn't shrink the log. It just truncates and discards the inactive portion of the log that it has backed up. The...

Pleasure. Are you all sorted now?

In my opinion, hyperthreading ahould not be enabled on a server that will be running SQL. Multi cores are fine.

Hyperthreading doesn't give two independent cores though SQL assumes them...

You should rebuild all your indexes after shrinking a database, as a shrink causes very high fragmentation. This rebuild will probably cause the databases to grow again.

The thing is, databases...

Pleasure

Yeah. The varxxx datatypes have 2 bytes extra to store the data size

By...

Null and not null datatypes are the same...

karthikeyan (1/4/2008)

---

The SQL NULL value represents a null or empty value in a database column. The NULL value is distinct from all valid values for a given data type. For...

What do you mean by trigger on an application? Triggers are placed on tables and views.

Nisha (1/4/2008)

---

Ok.. Here's my query:

SELECT * FROM [MyDateTable]

WHERE StartDate >= CONVERT(DATETIME, '02/01/2007')

AND StartDate <= CONVERT(DATETIME, '01/04/2008')

This works fine, Jeff! Which is why I was saying, I used...

So that changes made by one user don't affect another concurrent query (automatically done by SQL Server)

To ensure that a related set of data modifications are completed entirely or not...

Just trying to clarify some details of why the exec plan doesn't show the 4 million rows. If you'd prefer, I'll remove the posts

I agree that the exec plan doesn't...

The please post in the SQL 2000 forum so people don't waste their time and yours giving suggestions that don't work...

Not if you back it up. Tha backup log only truncated what it has backed up, so your log chain is safe.

It's if you truncate without backing up that you...

There are only 25 in the final result set, as shown...