Each new query window creates it's own connection or "session" to the database.

True enough... but for planning purposes, it does count towards the max of 8060...

Heh... you didn't read the OP's request... he wants the total disk size as well. xp_FixedDrives does not provide that information. 😉

Ys just gotta love Bulk Insert for speed... 😀

If you don't want to use BCP with a format file (absolutely the fastest), then something like this is probably in order... brute force 😉

USE AdventureWorks

GO

SELECT STR(SalesPersonID,3)

...

If you ever need to avoid the use of xp_CmdShell (lot's of DBA's simply don't allow its use for security reasons), then check this out...

EXEC Master.dbo.xp_DirTree '\\MIS1\Tmandaily$\INCT\',1,1

Won't help you with...

I use the Bulk Insert command from T-SQL... I don't even go near SSIS for the same reason I don't use DTS in 2k... too slow. I can import...

but i have the following error :

37000(7405)[Microsoft][SQL Native Client][SQL Server]Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these...

Yeah... I missed that... not exactly the right way to check for temp tables.

Thanks for the information on the...

timothyawiseman (1/9/2008)

---

Awesome article. There are not nearly enough resources focusing on code efficiency and even fewer on making code legible in my opinion, and this one was well written...

Also, in the article there was a code block that didn't show up properly. It was after

The next thing folks might try, is a full "covering" index...

Could you provide what...

Good idea... in fact, that's exactly what my code does... but there's nothing in the data to determine what level a node is at... just the parent ID, etc... and...

Perfect... thanks for the feedback, Shaun.

To keep conflicts with the Left and Right keywords to a minimum, I use LeftBower and RightBower in my code. A "bower" is one...

He has code that inserts and increases the left and right indicies... most of my code is batch code so I just recalc the whole tree from the adjacency model.

Heh... yeah... the good stuff never changes 😀