You can do:

EXEC tempdb.dbo.sp_spaceused #MyTempTable

I suppose once you have the size of the temp table you could estimate how many rows would add up to your size cutoff. The...

Gopinath

Thanks for the question, which demonstrated a useful point. Please accept my criticisms in the spirt of constructive feedback which, of course, you are free to ignore if you...

You've still got that unnecessary WHILE loop in there.

Even if you insist on keeping the loop, the #resultSET table isn't needed - you can just do this:

SELECT

@filter = @filter +...

Well, the alternative is to calculate...

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