Viewing 15 posts - 39,496 through 39,510 (of 49,571 total)
Wish (4/26/2009)
I got the answer why cursor is slow. It acquires locks which table variable does not do, and that is why Cursor isslow.
Nope. Cursors are slow because they...
April 26, 2009 at 4:31 pm
RBarryYoung (4/26/2009)
April 26, 2009 at 3:16 pm
Not about the code itself, but do you have permission from the vendor to post their code up in public? If not, it might be a good idea to write...
April 26, 2009 at 2:57 pm
sqlqueue (4/26/2009)
so how i can i dig more towards it ? and if my server is impacted with sql injection issue how can i figure out ?
You're going to...
April 26, 2009 at 2:30 pm
Bob Hovious (4/26/2009)
April 26, 2009 at 10:07 am
Bob Hovious (4/26/2009)
April 26, 2009 at 8:19 am
buz_gray (4/26/2009)
I'm new to SQL Server and it's a little exasperating that 'If Exists' should work but seems not to and my alternative does but seems to be little documented!
Are...
April 26, 2009 at 8:02 am
Bob Hovious (4/26/2009)
--
select count(*) from dbo.sometable as numberOfRows
--
is going to run slower than
--
declare @tableStats table
(name varchar(50), numberOfRows int,...
April 26, 2009 at 7:43 am
Chris Hancock (4/25/2009)
April 26, 2009 at 5:29 am
saurabh.dwivedy (4/25/2009)
I would like to still understand this in a bit more detail - Why does it not work?
Because it's not valid syntax. Nothing fancier than that.
Is it...
April 26, 2009 at 2:50 am
DKG (4/26/2009)
April 26, 2009 at 2:47 am
WayneS (4/25/2009)
April 25, 2009 at 3:16 pm
You'll find it up on Codeplex[/url]. Search for adventureworks and then check the available versions, make sure you get the 2005 version not the QL 2008 version.
April 25, 2009 at 2:58 pm
saurabh.dwivedy (4/25/2009)
DECLARE @Z INT
SET @Z = (EXEC USP_TEMP111) ---> this does not work. Sql server throws an error saying incorrect syntax near the...
April 25, 2009 at 1:36 pm
Viewing 15 posts - 39,496 through 39,510 (of 49,571 total)