Actually, a clustered index may not be necessary, depending on how the data is queried.  If each client is selecting only a single record at a time, the clustered index...

Here is some code that will create a temporary table with the filenames that match a filespec. (Note that the filename do NOT contain the path.) You can...

To get the length of a column, you can use the following function:

COLUMNPROPERTY( OBJECT_ID('tablename'),'columnname','PRECISION')

It seems the query optimizer should evaluate it only once instead of for every row.

First (but likely not the cause of any of your problems), I would suggest using ISNULL() instead of <fieldname> = NULL.

Secondly, I would suggest using SQL Profiler to determine if...

I had this problem before and I believe I found out that the ODBC SQL Server driver always sets ARITHABORT OFF. You may have to set it ON with...

I agree with antares. The backup/restore method has become our standard way of copying a database at my company. Not only is it easy, but it seems to...

Check out the topic "insert three rows into one row of another table".

It's almost humorous (to everyone except you, probably ) that such a simple scenario breaks their algorithm! I bet it was never in their test cases....

How about trying "select null" instead of calling the extra stored procedure? If you need a specific column name, you can do something like "select null as columnname".

Yes, I understand now. I was too quick in trying to reply and didn't completely read your problem. Maybe I can reply later with something that actually helps!...

Try this:

exec sp_MSforeachtable @command1 = "select top 1 * from ?"

Of course, you can replace the SQL command inside the quotes to be whatever you want, including calling another stored...

Greg Larson is right. However, for more information, check out BOL. Find "sp_executesql" in Index, then open the "Using sp_executesql" topic. It explains how to use parameters...

I'd say those results point to the Binary_Checksum algorithm relying heavily on XOR functions. Any odd number of identical records produces an identical checksum, and any even number of...

This is closer...

select distinct

t1.PeopleCode

t2.FirstName,

t2.LastName

from TempTable as t1

join TempTable as t2

on t2.PeopleCode = t1.PeopleCode

for xml auto, elements

Part of the problem is MSSQL's limit on the TOP clause--you cannot specify a variable. However, if you do know which record you want, you can use MSSQL2K's new...