Viewing 15 posts - 49,696 through 49,710 (of 59,078 total)
Studying the code for sp_help and sp_SpaceUsed will give you a wealth of knowledge about system "tables"... the code sucks (especially for sp_SpaceUsed) but where they get some of the...
June 25, 2008 at 6:28 am
Umm... I don't email reports or even let folks know when something has been updated... because it's always updated (with a few exceptions of course).
Favorite "trick" is to write an...
June 25, 2008 at 6:24 am
Oh yeah... I'm a bit lazy myself... that's why I wrote a little ditty that also adds the commas to the column names... 😀
I've got one for INSERT/SELECTs... writes the...
June 25, 2008 at 6:03 am
That would be true... and, except for what may occur on Inserts, indexes don't harm another's query.
June 25, 2008 at 5:56 am
No... I've verified that sp_help is bound to Alt-F1... it just doesn't work for me. I highlight the table name as you suggested and press Alt-F1... all that happens...
June 25, 2008 at 5:54 am
Nice article, Austin... title is just a bit deceiving, though. Most of the article talks about how to setup a report instead of about how to email. From...
June 25, 2008 at 5:35 am
Paul McKay (6/25/2008)
I basically deconstructed the entire query and re-wrote it the way I would.
That is sometimes the best and easiest thing to do. Thanks for the feedback, Paul.
June 25, 2008 at 5:12 am
Thanks for the feedback, Jonatan. As a summer worker, though, you are allowed to make a suggestion here and there, aren't you?
June 25, 2008 at 5:05 am
I have the Developers Edition for 2005 which is supposedly the same as the Enterprise Edition... the Alt F1 trick doesn't work for me.
June 25, 2008 at 5:03 am
jimige257 (6/24/2008)
Getting a hand from those with the knowledge makes a big difference...
I absolutely agree! However, I've only been asked a couple of times for help... is this...
June 25, 2008 at 4:51 am
Try it... if it's too slow, tweak it. If you run out of tweaks, try a differect tactic.
June 24, 2008 at 9:31 pm
The first delete will probably be a good size one... but if you delete every day, the number of rows older than 2 years won't be that big... you won't...
June 24, 2008 at 9:25 pm
bpbhalerao (6/24/2008)
But I am not getting exactly how to find the total no. of weekdays in that year using the 'Tally' table. Can you please explain some what more?
It...
June 24, 2008 at 9:21 pm
You'll find that loops have problems like the one you just saw because they return multiple result sets. You also find that, comparitively speaking, they're horribly slow. Since...
June 24, 2008 at 9:16 pm
Caching an old execution plan and/or parameter sniffing could be the problem. Add the WITH RECOMPILE option to the proc and see if that problem goes away.
June 24, 2008 at 9:09 pm
Viewing 15 posts - 49,696 through 49,710 (of 59,078 total)