Viewing 15 posts - 1,846 through 1,860 (of 5,590 total)
Dave Ballantyne (1/25/2011)
Any volunteers to read through a draft of an article for me ?Thanks....
Sure.
January 25, 2011 at 4:39 pm
Brian - You'll get better performance with a properly constructed permanent tally table instead of a virtual one. Not sure how to do that? See The "Numbers" or "Tally" Table:...
January 25, 2011 at 11:25 am
Plagiarism - no, I won't allow it.
Copying code and using it: I prefer that the code comments have a link to where it was found. But, most importantly... see the...
January 25, 2011 at 11:20 am
shaun.stuart (1/25/2011)
January 25, 2011 at 11:13 am
Steve Jones - SSC Editor (1/25/2011)
January 25, 2011 at 9:08 am
Roy Ernest (1/25/2011)
WayneS (1/24/2011)
January 25, 2011 at 8:58 am
Steve Jones - SSC Editor (1/24/2011)
WayneS (1/24/2011)
January 24, 2011 at 10:35 pm
Well, the SQL Rally Database and Application Development Track Voting Results are in, and my session was not selected (not even as a runner-up). Congratulations to all of those did...
January 24, 2011 at 4:49 pm
Hmm, this is the second question today on this same topic - is this homework?
You need to look into the scope of variables, and the usage of sp_executesql. I'll help...
January 24, 2011 at 3:26 pm
mister.magoo (1/24/2011)
I will add this tweak to the code when I run the performance tests...
January 24, 2011 at 3:21 pm
bitbucket-25253 (1/24/2011)
2a. Down load SQL SERVER 2008 DEVELOPER edition - cost about $100 USD.
FYI: it only costs $50. http://www.google.com/#num=10&hl=en&newwindow=1&q=SQL+SERVER+DEVELOPER+EDITION&um=1&ie=UTF-8&tbo=u&tbs=shop:1&source=og&sa=N&tab=wf&biw=1280&bih=867&fp=8ce0e008a607e93d
January 24, 2011 at 12:01 pm
Grant Fritchey (1/24/2011)
Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.
CONGRATULATIONS!
.... so, you and Steve are...
January 24, 2011 at 9:16 am
mister.magoo (1/24/2011)
WayneS (1/24/2011)
MM - very impressive solution. Very well done!Out of curiosity... did you try the tablockx hint? (I don't think it would make a difference.)
No, I didn't. Are you...
January 24, 2011 at 9:14 am
isaac.a (1/24/2011)
DECLARE @deldate varchar(10)='01/01/1960',
@tblname varchar(50) = 'CACCOUNTSTMT',
@ssql varchar(200)
set @ssql = 'set @deldate = (select max(Convert(varchar(10) ,RowCreateDate,103)) from ' +@tblname +')'
print @ssql
--set @deldate = @ssql
...
January 24, 2011 at 9:07 am
Yet another article where the discussion is as valuable as the article itself! 🙂
Well done Jeff on (yet another) great article. And well done to all that posted enhancements.
Thank you...
January 24, 2011 at 9:03 am
Viewing 15 posts - 1,846 through 1,860 (of 5,590 total)