Not really... both are formed in memory if there's room and in TempDB if not...

Better than that, correctly designing a normalized table would go a long way 😉

Thanks for the tip, Jan...

Which DBCC command did you execute?

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...