There of course ae plenty more ways to accomplish this as well it is really a matter of size of data going forward, potential for duplicate order numbers, and indexes.

The...

If the data itself does not have a text qualifier then it will not affect you. If it does then you will end up reading in the text qualifier as...

Also posted in your other topic which included this question later.

No you technically cannot. However you could build a middle tier service to update to multiple locations at one...

No you technically cannot. However you could build a middle tier service to update to multiple locations at one time with transactions so you can recover from a failure. Or...

The IS NULL in your example is more efficient and considered standard for this type of check. The reason is when you run

@var IS NULL

it evaluates true or false...

You most definently do so using filessystemobjects and file object to open, read and save.

Simple example

Dim x, z, objText, objText1, objText2, objText3, objText4

set x = CreateObject("Scripting.FileSystemObject")

set objText =...

That truely does of factors of depends. But I would say that many times you will need to add a controller somewhere to ensure transactions can get priority as needed...

Big applause. Great article. Nice and tight delievery.

With reqrads to the queries themselves the answer is no.

However you could potentially write Query 1 with a while loop in it and each step thru the while check...

I suggest shut down SQQL Server service and make sure that tempdb is deleted. I previously had a situation where tempdb was locked at the file level and wouldn't delete...

Pretty cool. However I would sugest you put you objects in MSDB at least for the table as you shouldn't create user tables in master as a standard. And as...

Another thing you might want to do so you could push off to the users a copy if requested into MSDE is setup the entire database in model on a...

Host: Patrick (Microsoft)

Q: What method do you recommend for determining the optimal block size for both the log and data files?

A: Block size = NTFS cluster size? Depends somewhat on...

I assume you mean have it sort

{1,1a,1b,1c,2,2a,2b,3,4,5,5a,5b,6,8,11,12,12b,12c...}

Instead of the norm

{1,11,12,12b,12c,1a,1b,1c,2,2a,2b,3,4,5,5a,5b,6,8...}

The only way to get in numeric order would be to strip the alphas and cast as numeric in the order...

Where did you find this in BOL spindlej as this is what I find under topic "Cast and Convert"

When converting character or binary expressions (char, nchar, nvarchar, varchar, binary, or...