No. Composite keys are not automatically clustered. If you use EM, then you have to select if that particular index is clustered. In QA, you should know from your script...

User defined functions were not available for SQL 6.5. PatIndex may work.

BOL (Books on Line) will help with this.

Select 1 as keyID,CONVERT(smalldatetime, getdate(),120) as datetime_text

Spent the morning working with a developer using C#, which decides to use 00010101 instead of NULL values. Great. Ended up using the DBNull class to get around this.

I have found that using the data type "table" can be faster than using temporary tables. I had to write a series of cross-tabs recently. I started out with temporary...

Varchar and NVarchar handle the same types of data (characters that will vary in length). Varchar is used for applications that are used in the United States and most European...

Ok. From reading your code I'm not sure if you want the view or a stored proc? No reason to create a view - just use a select in the...

Just remember that you are working with set theory instead of procedural theory.

Last year I started a thread that asked if anyone had actually been involved in a hiring decision where the certification made the difference. This might be an urban myth,...

Laughing. Salut.

I'm still in the US. Like many here I have been redundant for months, so more energy was spent finding the next place than chatting with my SQL...

There could be several different answers to your question. How many rows are in the table? How often is the table updated or new information inserted? What are the current...

There is an undocumented stored proc called sp_reassign_dtspackageowner [@name =], [@id=], {@newloginname]

Both @name and @id are required.

Be aware that it works with owner_sid in sysdtspackages. The owner is a...

Interesting solution, although you might have to modify it, slightly. From my reading, I understood that a customer cannot have duplicate modelnames but could several customers have the same...

It brought to mind the reason I decided I did not have a future as a network engineer. In 1996, my boss sent me to a very small town (a...

The first thing you should check is the execution plan after you have created your small tables. Are there indexes? Are they useful? If your plan creates three table scans...