Well, no. Sorry, I don't buy it. The Northwind database is tiny, and on tiny tables scans are often faster, and compile times significant in comparison to execution.

When...

I am using SQL2000.

In terms of the where clause, just do this and look at the query plans. The one with the OR gives a scan, the one without...

That's only on a LAN. On a LAN it's pretty straightforward, and you don't have to go through all that. If it's currently communicating with the SQL Server,...

By the way, I should note that W2K (probably XP) includes a network sniffer that's decent (limited to what comes in/out of that server, not a general sniffer). So...

That's a very good question. Applications send in the host name, e.g. DTS packages appear to always come from the system that authoried them, drives me nuts.

I was fascinated...

What is your definition of "remote access"? Are you just disabling RAS to an interior LAN, or are you planning to somehow prevent network access to the SQL Server...

Sounds promising. We had not noticed that. I take it that it's unconditional regardless of who has the transactions open. Will try it.

I use the Red-Gate compare program and periodically compare our numerous databases to see if they are the same.

No matter what tricks you use to try to remember, sometimes you...

I had the same problem in a procedure that created audit triggers, declare 8000, only works to 4000. I think the obviuos cause is that somewhere inside there is...

Never mind. I oversimplified, and once I noticed it's obvious. The view is actually

select IsNull(t1.a,t2.a) as a, etc.

so the where clause for the view isn't making it...

We use log shipping for some databases. We have three basic ways we do this whole process - transactional replication, the one described above, and log shipping.

We use transactional...

Obviously your needs may vary, but here is our need and approach.

We want a copy that people can query without being impacted by updates, i.e. lock-free.

We need a copy to...

Re Scripts: From my perspective yes, any thing related to the DB. I insist that the entire database structure be maintained in source safe in scripts to the point...

I was surprised to read you can't use controller cache on clusters. Write-back cache makes a huge difference in our database environment (as with anything yours may vary). ...

i should make two caveats.

The ranking table and selecting a range around it fails if you don't have at least (for TOP N) the N in each grouping, otherwise you...