Viewing 15 posts - 39,826 through 39,840 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 8:30 am
This will give you an overview of what certs are available:
http://www.microsoft.com/learning/mcp/certifications.mspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 8:04 am
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=354766
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 7:25 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 3:43 am
Well, the clustered index keys are the columns in your primary key, ie PayCode and DBNo. Since you're filtering by a column that's not one of those and you have...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 1:13 am
Krishna Potlakayala (4/9/2009)
san (4/9/2009)
how to take transaction log backup without .mdf fileInteresting, What are you trying to do here?
I'm guessing take a log tail backup after the MDF has...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 1:07 am
Vivek (4/9/2009)
Indexes are not implemented in the database by the client so there are no indexes implemented on the database.
Why?????
Will millions of rows in the table and no indexes, you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 1:05 am
Florian Reischl (4/9/2009)
Anyway since the value cannot be converted to a number it also shouldn't be numeric...
Oh, but they can.
'15d1' and '15e1' will cast successfully to float. '10,0' will cast...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 10, 2009 at 1:00 am
Viewing 15 posts - 39,826 through 39,840 (of 49,552 total)