It is hard to give good advice without DDL, but here are my 2 cents:

a) Use ISO codes for currencies and don't hard code them. What is '$'? US dollars,...

I got it right but the answer is wrong. It sets the priority, bur the sql engine still chooses the victim since two sessions can still have the same priority...

Don't just look at it! Buy it

We bought a 10 pack last year. It works well with QA and SSMS and EM and VS...

Another option, which may be even more efficient, is to use textcopy.exe. It's been bundle with SQL for ages, easy to use, is rock stable, extremely fast...and it can export...

You can nest EXEC and sp_executesql

EXEC (N'EXEC sp_execuresql ' + @SQL1+ N', ' + @SQL2 + ', ' ...)

The query plan is then cached

> Lastly, you can wait for SQL2005 and

> it is supposed to have these separated.

AFAIK, the Date & Time datatypes won't be supported in 2005. They were dropped from...

Patrick,

Currently, "dbo" is not a SQL userid, it is the "db owner". It's a security role, not a user. And this is not SQL-99 compliant.  What we call "owner" in...

I agree, but...playing devil's advocate

a) Ownership is a pain in SQL2000 because it's ownership, not schema. SQL2005 changes that.

b) When working with hundreds or...

Your SQL server is probably configured for windows authentication only. Change it to mixed mode*.

*enterprise manager/properties on the server/security tab/(set authentication to "windows + SQL")

Not having any index means SQL must do a table scan to find the rows that qualify for your request. Thus, the lock. Add at least a PK, but also...

Ooops. Strike the above. I just made another test. It does not work if the SQL server is part of a domain but it seems to work if it's only...

Hello Brian,

a) There are a few SQL jobs doing a lot of file IO on other servers using sp_OA procedures. It's working very well and it was done this way...

Since a buffer latch is  ressource lock while sql swap between memory & disk and since this involves a times out I would do this:

a) check in the NT log...

All good reasons not to do it would fill a fat book.

The first one would be security. Well, the first 5 chapters are security reasons.

Chapter 6 is maintenance. Web servers...

Yes. Easily but not nicely.

a) build a COM. You can call a COM from both DTS and T-SQL (sp_OA* procedures)

b) build an executable...