Viewing 15 posts - 52,981 through 52,995 (of 59,068 total)
Andrew Terwiel (1/9/2008)
Also, derived tables have lower overheads in comparison to temporary tables.
Not really... both are formed in memory if there's room and in TempDB if not...
January 10, 2008 at 7:23 am
Better than that, correctly designing a normalized table would go a long way 😉
January 10, 2008 at 7:21 am
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
Viewing 15 posts - 52,981 through 52,995 (of 59,068 total)