Viewing 15 posts - 7,801 through 7,815 (of 8,415 total)
RBarryYoung (6/11/2009)
Paul White (6/11/2009)
... Everything in moderation I say! ...Everything except moderation, I presume? 😀
Gah! 😀
June 11, 2009 at 7:28 pm
sscddr (6/11/2009)
The article should discuss the wonders of "option (recompile)".
It would be a useful addition, yes. Of course OPTION (RECOMPILE) is not a panacea - recompiling for every execution...
June 11, 2009 at 5:29 pm
Tim Walker (6/10/2009)
June 11, 2009 at 5:13 pm
usman.tanveer (6/11/2009)
btw my colleague is able to deploy the same code, we both have the sysadmin rights on sql server, but i am...
June 11, 2009 at 3:48 pm
My guess is that it is the index(es) on the destination table that cause the problem.
Try dropping the indexes and then doing the insert.
Create appropriate and valid index(es) afterward.
June 9, 2009 at 1:58 am
No worries, I enjoyed answering the question.
June 8, 2009 at 2:41 pm
Grant Fritchey (6/7/2009)
Gail & Paul got on the Algebrizer before I could.
Now there's a phrase you won't hear every day. 😀
June 7, 2009 at 5:25 am
GilaMonster (6/7/2009)
June 7, 2009 at 5:23 am
GilaMonster (6/7/2009)
June 7, 2009 at 5:03 am
In principle, you could get the page number from the page lock associated with the RID/KEY lock you are interested in, and then use the undocumented DBCC PAGE ('DatabaseName', file_id,...
June 7, 2009 at 4:12 am
GilaMonster (6/7/2009)
June 7, 2009 at 2:51 am
David Burrows (6/6/2009)
I think I knew what I wanted to say but just could not do it so well :crying:
Hey David, I'm sure your answer was better for anyone who...
June 7, 2009 at 1:28 am
For anyone wondering about the 'algebrizer':
The compilation process (which also includes optimization) goes through the three stages Gail described.
1. The parser validates the syntax of the statement and then...
June 7, 2009 at 1:20 am
brainy (6/6/2009)
if 1=2delete from test where c=9
I guess it is due to how sql server compiles our script.
Yes. SQL Server works differently from some other programming languages you...
June 7, 2009 at 12:55 am
kladibeeto (6/6/2009)
This applies to both SQL 2000 and SQL 2005 I test it.
Yes but the links I posted are 2005-specific. That's why it pays to post in the correct...
June 6, 2009 at 8:16 pm
Viewing 15 posts - 7,801 through 7,815 (of 8,415 total)