Viewing 15 posts - 49,036 through 49,050 (of 59,065 total)
Jonathan Kehayias (7/23/2008)
Perhaps in my attempt to demonstrate an overly simplistic TSQL Example, I made it far to simple. The OP wants to SELECT a value from any column...
July 25, 2008 at 5:52 pm
Heh... with all the problems I've seen on forums with 64 bit technology and SQL Server, so far... I'm going to wait for SQL Server 2011 before I recommend 64...
July 25, 2008 at 5:47 pm
How did you verify that? Is it just because you got a rows affected of 1? Perhaps there was only one row that met the condition?
What do you...
July 25, 2008 at 4:46 am
Deee -Daah! (7/24/2008)
I was wondering if there is an alternative to running XP_cmdshell DIR.
Basically, I run xp_cmdshell to gather file info on a folder.
without using XP_cmdshell, is there other...
July 25, 2008 at 4:31 am
su_kumar11 (7/25/2008)
The site you have given is not opening. SoSo
Please give me solution.
Try copying the URL and pasting it to the address window in your browser.
July 25, 2008 at 4:15 am
Untested, of course... 😉
DELETE dbo.abn_extract
FROM dbo.abn_extract E
INNER JOIN dbo.ABN_File_Header H
ON SUBSTRING(E.[Column 0], 1, 13) = H.Header_Id
SQL Server is one of the...
July 25, 2008 at 4:06 am
avanish (7/24/2008)
Rather than writing comples queries .... yo u can use the ranking functions... in sql server 2005 for this purpose:)
Perfect... got a code example to go along with that...
July 25, 2008 at 3:51 am
Just double checking... Was the mirror made using SQL Server Replication or (disk) hardware replication.
July 24, 2008 at 5:42 pm
Gary Noter (7/24/2008)
No, wait, if I implement this code, then can't waste my time with writing and waiting for WHILE loops...
July 24, 2008 at 5:40 pm
I've found that nothing helps except a good ol' fashioned technical interview. I've had several people where references checked out great... old bosses gave rave reviews... former co-workers gave...
July 24, 2008 at 5:37 pm
Thanks for the feedback, Hugo,
I explained why a merry-go-round scan is not possible for this in the article. I even demonstrated what a merry-go-round scan is... updates don't do...
July 24, 2008 at 5:30 pm
Cool... thanks for the feedback, Lynn. And, glad it all work.
Michael, nice job if you don't mind me saying so. 🙂
July 24, 2008 at 5:15 pm
ALIF (7/24/2008)
either use this thingsshrink tempdb,
or
detach the file and attach with a new one with 0 bytes
or still you cant do
just restart the sql services, everything will be refreshed.
Shrinking...
July 24, 2008 at 5:13 pm
GilaMonster (7/24/2008)
angie stein (7/24/2008)
Brandie Tarvin (7/24/2008)
Does this technobabble make sense?
Ok, so it sounds like you should usually restrict the growth (esp. in prod), unless there's a good reason to do...
July 24, 2008 at 5:04 pm
nisan.al (7/24/2008)
But by the way, tempdb doesn't have to be in the same drive as the operation system you can change...
July 24, 2008 at 6:08 am
Viewing 15 posts - 49,036 through 49,050 (of 59,065 total)