Viewing 15 posts - 39,841 through 39,855 (of 49,571 total)
Vijaya Kadiyala (4/10/2009)
Is this in any report? or any Front-End application.
Good point. This is definitely something that's best done in the front end/report rather than in the database.
April 10, 2009 at 9:19 am
RBarryYoung (4/10/2009)
April 10, 2009 at 9:16 am
Please post the details of those errors. Just listing the numbers is not sufficient.
Actually, if you can find the SQL error log and post the entire of it (removing server...
April 10, 2009 at 9:11 am
Lookup the ROLLUP keyword in Books Online. (you'll probably find examples under the section "GROUP BY (Transact-SQL)")
One other point, looking at your procedure. There's no point in an ORDER BY...
April 10, 2009 at 8:44 am
High-level advice: Break the job down. Run it step by step in a dev environment and see which step(s) are the slow ones. Focus your optimisation work on just the...
April 10, 2009 at 8:33 am
Erland, Itzik, Steve Kass and Aaron. Between the 4 of them they probably opened more than 50% of the connect suggestions.
April 10, 2009 at 8:30 am
This will give you an overview of what certs are available:
April 10, 2009 at 8:29 am
Those files are the result of a stack dump by SQL Server. As to the cause, very hard to say, if you're getting them frequently I would suggest that you...
April 10, 2009 at 8:29 am
Steve Jones - Editor (4/10/2009)
Gail, happy to give you moderator privs if it wouldn't add another 150-200kb to your download 🙁
Not a good idea, seeing as I'm scraping my monthly...
April 10, 2009 at 8:25 am
Steve Jones - Editor (4/10/2009)
I wouldn't care except that I can't get a "list" of MVP names from MS.
Anyone who wants the badge mails you and includes a link...
April 10, 2009 at 8:23 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic694829-131-1.aspx
April 10, 2009 at 8:04 am
One more thought on this. Steve, there is one 'badge' that I'd very much like you to add, the sooner the better - moderator. I've had a number of people...
April 10, 2009 at 7:17 am
Two forums I know that do this kind of flagging.
1) MSDN. Can lead to people insisting that they want an answer from an MVP/MS and nothing else will do. Jonathan...
April 10, 2009 at 6:04 am
Selectivity and the number of rows that the optimiser thinks will be returned.
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
April 10, 2009 at 3:43 am
Viewing 15 posts - 39,841 through 39,855 (of 49,571 total)