Enterprise Manager would be happy to rewrite your old-style joins. In the Tables view of any SQL 2000 database, right-click on a table and select "Open table -> Query"....

I delete my LiteSpeed backup files with this code in a Script Task in a maintenance plan package. It is configured by the variables BackupRoot (parent dir for all...

Seems to work for me in both SQL 2000 and SQL 2005. This code creates a 16,000+ character command that returns 16 996-char fields and one 3-char field as...

I've known developers who prefer GUIDs because they can create an object in code anywhere, create the GUID primary key, then use the GIUD to create related objects, and finally...

You could use the Derived Column transformation to define a new column with a LEFT(s,20) expression, instead of creating extra views. You could also put a Conditional Split transform...

Ahmed Bouzamondo (11/16/2007)

It's me again, considering the following article http://news.zdnet.com/2100-9584_22-6038148.html

a quad-core is considered as eight-processor servers (so if you want to use all processors for 2005, in the future, you...

You could start your CarID values at 1,000,000,001 and have room for one billion non-overlapping people and cars. Or seed one of the tables with -2147483647 and have over...

The /!X /!C tricked worked fine for me and is definately a good tip. But instead of scripting the job so you can see what it is going to...

R.P.Rozema (12/12/2007)Hi Scot, you are right, this doesn't help much in performance, though I don't see it hurt performance either like you suggested. Looking at it now, I maybe should...

If you include TRANSACTIONID in your GROUP BY, you'll get a separate row for every transaction.

You could use "GROUP BY POLICYID, (TRANSACTIONID - 1) %3" to get the output you...

In the example for comparing a mandatory and an optional column,

select 1

from dbo.Table t

where nullif( t.mandatorycol, t.optionalcol) is null

Am I missing something, or will "nullif(...

It appears that the columns in your desired output are quarters, while the rows are the first, second, and third month of each quarter. If you can compute values...

You can convert the datetime to a varchar in YYYY-MM-DD HH:MM:SS.SSS format with CONVERT(varchar, datetime_col, 121).

The SQL Server field could work like an Oracle timestamp if you populate...

I think I understand what you're trying to do, but I'm not sure you understand what kind of snapshot I'm talking about. A database snapshot is not a replication...

The SELECT inside the OPENQUERY INSERT/SELECT can only reference field names, if you use SELECT TO_CHAR(..) then that column is a function result and not a table column that can...