Hi pros, I have an update statement that updates about 14 million records. It involves a few joins and finally updates 1 sigle column in the target...
Hello guys, What is your opinion on the following: 1) I have a rather large table (for my definition of large). Approx 5 million rows 2) There is...
Hi all, has anyone ever come to a solution in joining strings together in a comma separated fashion? Something like an aggregate e.g. SELECT X,...
Hi all, there is a part in my application where the code needs to execute a query like this SELECT * FROM Items WHERE GUID IN (x,y,z, etc) I know...
Hi pros, I have several SQL servers which are used for uploading customers' backups for debuging and other purposes. This is performed by...
Does anyone know this? I have a database in SQL Server 2005 with compatibility level 80 (SQL Server 2000). Is it possible to restore the db in...
Hi pros, I happen to spend a lot of time profiling SQL Servers and viewing execution plans of bad written queries. In SQL Server 2000 I could copy...
Hi there, I have ran into a situation of a few tables with wide record size and guids as primary clustered indexes (great combination). I see there...
Hi there. I am a newbie and have a very simple question for the pro. I have a table that has 100 decimal (yes it's true) columns 13 bytes each. The...
Separate names with a comma.
