Viewing 15 posts - 52,981 through 52,995 (of 59,064 total)
Each new query window creates it's own connection or "session" to the database.
January 10, 2008 at 7:08 am
True enough... but for planning purposes, it does count towards the max of 8060...
January 10, 2008 at 1:56 am
Heh... you didn't read the OP's request... he wants the total disk size as well. xp_FixedDrives does not provide that information. 😉
January 10, 2008 at 12:45 am
Ys just gotta love Bulk Insert for speed... 😀
January 9, 2008 at 11:53 pm
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)
...
January 9, 2008 at 11:50 pm
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...
January 9, 2008 at 5:37 pm
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...
January 9, 2008 at 5:13 pm
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...
January 9, 2008 at 5:08 pm
I believe "spooky" was about
SELECT * FROM SYSOBJECTS
WHERE name = '#MyTempTable'
Yeah... I missed that... not exactly the right way to check for temp tables.
Thanks for the information on the...
January 9, 2008 at 5:00 pm
timothyawiseman (1/9/2008)
January 9, 2008 at 4:56 pm
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...
January 9, 2008 at 4:49 pm
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...
January 9, 2008 at 1:53 pm
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...
January 9, 2008 at 1:48 pm
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.
January 9, 2008 at 8:59 am
Shaun McGuile (1/9/2008)
Ok I found ithttp://www.dbmsmag.com/9603d06.html
Whoa thats like 12 years old almost. 😀
--Shaun
Heh... yeah... the good stuff never changes 😀
January 9, 2008 at 8:04 am
Viewing 15 posts - 52,981 through 52,995 (of 59,064 total)