Heh... You're all destroying the ability to produce an automated data dictionary for a database and none of you even bat an eyelash at that. :blink: Sure, sure......

Okidoki... first off, since you didn't provide any table creation scripts nor data population scripts, you have to understand that I've not tested this code. Please see the link...

vidhyasudha (10/3/2008)

---

HI Luke,

Sorry for all the inconvenience caused.

Tab1 structure

Create Table Tab1

(

name varchar(25),

description varchar(25),

Category varchar(25)

)

Sample data for Tab1

insert into tab1 (name,description,category) values ( 'caneditacc','editing','Acc')

insert into tab1 (name,description,category) values ('candeleteacc','deleting','Acc')

insert...

There are a lot of things that will qualify as a date that will fail the conversion using date format 103. For example, 0 is a valid date. ...

I don't personnally know how to do it, but the folks at my old shop did it quite easily. Apparently, certain SANs come with the ability to make snapshot...

Yep... I absolutely agree with Richard that batch size is important... trying to import 20 million rows will drive the log file absolutely nuts if you don't do the Bulk...

It doesn't need to be that complicated if you understand that NULL is NOT nothing and cannot be compared to using relational operators...

IF (SELECT somecolumn FROM sometable) > ' '

PRINT...

Heh... if you think THAT was fast, wait until you run the code. First time I demo'd it on a million rows in front of a group of people,...

So, create a chunk of code that will make a set of SELECT/UNION...

There's nothing there to relate state to county, etc, etc. Are the other columns in that table that might be used to do that?

Don't do it that way... past the following URL into the URL box of Books Online and see...

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8cfea566-8f89-4581-b30d-c53f1f2c79eb.htm

You can't rely on an "implicit" sort order... you'll need to use ORDER BY or GROUP BY WITH ROLLUP/CUBE.

Yep... but with "VLDB's", hardware costs should be the least of your worries.

TheSQLGuru (10/3/2008)

---

>>Think "compound interest".

Think "read my post"! 😀

The default data file growth is ONE MEGABYTE, not TEN PERCENT (at least on all the servers I recall installing)....

Actually, I was talking about SQL Server 2000 'cause I'm still stuck in that world for better or worse. I forgot this was a 2k5 forum.

I just setup a...