Viewing 15 posts - 32,176 through 32,190 (of 59,102 total)
sqlfriends (10/24/2011)
I'm query jobhistory table in msdb database. It stored the run_date as this.I'm trying to create a query that to check if a job run or not yesterday.
Ah!...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 6:33 pm
The_V (10/24/2011)
Case
when Len(F.Comments)...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 6:08 pm
BTW, Orlando... thanks for the link to "How Standards Proliferate". Now THAT's funny because it's oh-so true! 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 5:47 pm
Dev @ +91 973 913 6683 (10/19/2011)
Please don't forget to follow the discussion.I cringe every time I see a recommendation for xp_cmdshell.
Yes... please follow ALL of the discussion because...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 5:22 pm
I'm not 100% sure about SSIS but, from what I've read, you should be able to use "%[0-9]%" as the "search string" in FINDSTRING. Of course, you'd use 1...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 4:55 pm
mnicholas (10/24/2011)
SELECT distinct ...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 4:43 pm
sqlfriends (10/24/2011)
I need to convert yesterday's date from getdate()-1 to something like 20111023.
I have to ask "Why?"... What are you going to do with it after you do the conversion?...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 4:37 pm
Elliott Whitlow (10/24/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 4:25 pm
Mike Usoffski (10/24/2011)
This is a small part of major data scrubbing/cleansing within 2000 --> 2K8 R2 migration project.
The plan was to leave "dups" behind on a SQL 2000 side....
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 1:53 pm
patrickmcginnis59 (10/24/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 1:22 pm
patrickmcginnis59 (10/24/2011)
...dreaded xp_cmdshell...
Heh... "dreaded". I love xp_CmdShell. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 11:02 am
Jack Corbett (10/24/2011)
I have a question. Why the TABLOCKX hint on the temp table? What does it give you that the QP/QO wouldn't do anyway?
It's a small "speed...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 10:59 am
On that note... do what I do... I trust no one's article. I test the heck out of their claims using my own code. In truth, you shouldn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 7:08 am
HowardW (10/24/2011)
Just came across this:http://sqlserverboost.info/?p=204
Complete plagiarism, yes?[/url]
The rest of the site content looks equally dubious.
Google for the phrase "In my experience, every DBA has his own mental checklist"... which comes...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 5:10 am
dva2007 (10/24/2011)
thanks jeff & gail.I had a quick look at this article before couple of years which made my wrong impression about select into.
http://searchsqlserver.techtarget.com/tip/Tricks-to-increase-SQL-Server-query-performance
Many thanks for the clarification.
Ah......
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2011 at 4:56 am
Viewing 15 posts - 32,176 through 32,190 (of 59,102 total)