Vladan

The previous invoice won't be for another customer, because the data in the temp table is ordered by customer.  Have I overlooked something?

John

Hemant

First, a couple of comments on your table design.  If CustomerCode is just that, then varchar(50) is probably a bit much, especially if you are using that column to join...

DAB

Now that you're up to 16GB, have you removed the /3GB switch from your boot.ini file?

You should expect to see a low cache hit ratio soon after the server is...

Yes, a linked server is the way to go if you're going to do it regularly - although there are also ways of running ad hoc queries without creating a...

Michelle

I don't know anything about Litespeed, I'm afraid, but here, off the top of my head, is how I'd go about moving the databases.

(1) Back up all databases in case...

 "The only unique key on the tab1 is the primary key... I have checked all other col's on the table but none are unique."

You have two unique constraints on the...

Arun

Sergiy is quite right, of course.  Now, to answer your question... the following should work.  Somebody might be able to think of something more concise.  It should work no matter...

The procedure for moving tempdb data and/or log files is different from the procedure for user databases.  You need to use the ALTER DATABASE statement, if I remember correctly.  There...

Tryst

Yes, so long as it as simple as switching two values over.  Obviously if the values were 13 and 28, say, then you'd need to think about how you would...

Michael

You will find a table with the meanings of the columns in Books Online.  For your report, I think you will need to create your own lookup tables with this...

Tryst

Here's a way of doing it without a CASE statement

TABLE #MyTable (TableID int,...

I would set it to the size of the disk (assuming you don't use the disk for anything else) and then leave it.  Make sure you grow the file out...

Richard

More information, please.  Is it all the indexes on this table, and if so have you rebuilt them all, including the clustered index (if there is one)?  How do you...

Frances

To see the Taskpad View, click on the database in Enterprise Manager, then right-click and choose View and then Taskpad.  Unused DB and log space are the amount of space...

Dan

In a cluster environment, the operating system regularly polls SQL Server to check that it is still alive.  I think it does this by connecting as a Windows account and...