Viewing 15 posts - 53,581 through 53,595 (of 59,068 total)
Now in case of FASTFIRSTROW..I am trying to achieve a fast response time
It's far better to write good fast SQL with the proper indexes instead of trying to trick...
December 13, 2007 at 2:39 pm
Heh... they even made the same mistake that caused the y2k crisis...
Best T-Shirt I ever saw on the subject of "SQL Darwin Awards" was...
[font="Courier New"] SELECT *
...
December 13, 2007 at 2:30 pm
[font="Courier New"]SET @Cmd = 'DEL \\dt-sc2\shares\Data.txt'
EXEC Master.dbo.xp_CmdShell @Cmd[/font]
December 13, 2007 at 2:19 pm
Yes... it does NOT affect performance of what SQL Server does for page allocation...
December 13, 2007 at 2:02 pm
Run the following: EXECUTE master.dbo.xp_cmdshell 'SET'
and then run SET from the command prompt. (make sure you are logged in as the account that the agent is running as). For me...
December 13, 2007 at 1:47 pm
Ummm... actually, Scope_IDENTITY() is exactly what you want.
December 13, 2007 at 1:41 pm
Crud... missed your reference where you explained it before. Sorry, John.
December 13, 2007 at 7:49 am
A whole lot more subtle than the obvious candidates for the "SQL Darwin Award" that you guys have shown, is my favorite clock-cyle waster/index defeater...
[font="Courier New"]AND ISNULL(somecolumn,' ') <> '...
December 13, 2007 at 7:17 am
Any alternate suggestions or anything else that i need to consider ?
Yes... don't forget that SQL_Variant can take up to 8016 bytes... if you have more than one SQL_Variant column...
December 13, 2007 at 7:03 am
Great minds think alike... and, frequently, at the same time. 😉
December 13, 2007 at 6:57 am
Linda Johanning (12/13/2007)
December 13, 2007 at 6:45 am
Jeff, may I send that to my boss?
Sure... in fact, I'm honored :blush:. But, I would be very careful and I'd possibly do a bit of editing... the term...
December 13, 2007 at 6:22 am
Just in case you dislike cursors as much as I... see attached...
December 12, 2007 at 11:18 pm
karthikeyan (12/12/2007)
Useselect
into
from
(or)
Insert into
select
Good... you're trying to answer questions and that's a good thing. But go back and read...
December 12, 2007 at 11:07 pm
timothyawiseman (12/12/2007)
There is no way of doing it without going outside of SQL in some way, but there are several ways of doing.
Ummm.... not quite true in 2k or 2k5,...
December 12, 2007 at 11:03 pm
Viewing 15 posts - 53,581 through 53,595 (of 59,068 total)