The precise result set is as follows:

(No column name)(No column name)(No column...

I'd like to see the link for that if you still have it, please. I can't see how it would affect network performance, although I admit that it is...

I got this right, but I think the question should have been qualified with something like "on an instance installed with the default settings". Otherwise the answer should be...

Sorry, you've lost me. Why would using DATALENGTH to determine row size affect the amount of traffic that goes across the network?

John

I think you may find that if you go active/active then your licensing will be twice as expensive, since you'll be running on twice the number of processors.

You will need...

While the index rebuild is running, execute sp_who2 a few times. If the same SPID appears in the BlkBy column every time, and the SPID being blocked has ALTER...

You need to kill the process that is already accessing that index. This may just be a case of stopping your application while you perform the index rebuilds.

John

I think the CONVERT function is what you're looking for. Or you could allow the data layer to store the data and leave the formatting to the presentation layer.

John

We can't really help you with this. The table grew because somebody put a lot of data in it. Do you know how many rows it had before?...

Have you created the table of data types and their widths like I suggested in the other thread? And why don't you want to use DATALENGTH?

I'll tell you how...

Right-click on the server name and choose Properties. Click on Security and choose the appropriate setting.

John

Just make sure it does. You could put some logic at the...

To find out where the breaks are, you just LEFT JOIN your tally table to your table of IDs, and find the values in your tally table corresponding to NULLs...

Place it wherever is most apposite. I think I would use the master database. If it's not there then your procedure's going to fail, unless you define it...

OK, this is getting outside my area of knowledge. However, I'd say that if one part of your application is connecting to SQL Server, and another part is failing...