Hello Moe,

did you mean it as a joke, or serious advice? Not sure, with that smiley... anyway, to avoid confusion, when I said let the tempdb grow, I meant let...

Uh... not sure I understand everything. Lets try. You have (for simplicity) data about drivers working in 2 companies. At a certain moment, you check for all drivers that have...

You posted the error as : The log file for database tempdb ls is full.

That means, you should check whether the log file is on a disk where it...

Noeld,

this problem looks interesting and I was curious about your solution... however, either I have different function dbo.fn_varbintohexstr, or it is due to some settings, or else there is a flaw...

Or, if you wish to avoid multiple single quotes, you can make single quotes part of the string (expanding the @i to 3 character length at the same time):

declare @i...

I'm very happy with LCD panel - at work I have CRT monitor and at home LCD - and I can feel the difference. Even after quite long sessions in...

When SQL Server converts automatically, it sets the resulting type to match the rest of the statement. Error message returned is "Arithmetic overflow error converting numeric to data type numeric."...

IMHO random selection is the worst possible solution. Lets say someone has 5 addresses, one of them is address that they are using only for invoicing, another one is incomplete,...

Obviously, the solution depends on how the data is stored... As an example, if the hierarchical reference (1.1.2. etc.) is stored in the table Division, and you are sure that...

"I do recall hearing or reading somewhere that performing an INNER JOIN after a LEFT OUTER JOIN could potentially return obscure results"

Right... I think I know what you mean... you have...

Probably it is a matter of personal preference. I think that Outlook is wrong if it says that 30.12.2006 is week 1. I would definitely say it is week 53,...

Maybe this is just misunderstanding of your post, Steve, but I was pretty sure that when backup is terminating, all transactions that were finished during the backup are written with...

I don't know much about DTS, but generally if IDENTITY_INSERT is OFF, you should be able to insert data into a table with identity column and the values for identity...

In most cases, it is better not to use EM for editing. There is only one situation in which I have ever edited values in a table through EM, and...

Can you divide the insert into smaller chunks? I did similar thing recently, was copying some 40 million rows into another DB (for archiving purposes) and the first attempt failed...