Viewing 15 posts - 19,186 through 19,200 (of 49,552 total)
You'll probabaly get faster answers to MySQL problems on one of the MySQL forums - http://forums.mySQL.com OR http://www.dbforums.com/mysql
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 12, 2012 at 12:27 am
Yes, order of index keys is important.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
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 11, 2012 at 3:59 pm
Table definitions and sample data please (sample data as insert statements)
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 11, 2012 at 3:51 pm
Yes, but not in quotes.
'DTS.SuitePath' means the literal string value DTS.SuitePath. If it's a column name, it must not be in quotes.
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 11, 2012 at 3:26 pm
Please read through this - Managing Transaction Logs[/url]
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 11, 2012 at 1:02 pm
Sean Lange (4/11/2012)
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 11, 2012 at 12:38 pm
2, 3 probably not. 4 you'd see on activity monitor
Statistics updated recently?
Could also just be a data tipping point. Could be a bad plan.
Can you post indexes and execution plan?
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 11, 2012 at 12:38 pm
Maybe start with these
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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 11, 2012 at 12:26 pm
Where's the data coming from? Where are those 3000 source rows?
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 11, 2012 at 12:14 pm
Brandie Tarvin (4/11/2012)
opc.three (4/10/2012)
Brandie Tarvin (4/10/2012)
Also make sure the sa account doesn't own the jobs in question.Why would it matter if sa owned jobs?
Because if sa is disabled, then scheduled...
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 11, 2012 at 11:07 am
Few things...
Yes, the CX packet and the multiple rows show that's running in parallel.
No, MaxDop is not the immediate right answer, parallelism can be a good thing.
CX packet means that...
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 11, 2012 at 10:32 am
Lynn Pettis (4/11/2012)
Brandie Tarvin (4/11/2012)
GilaMonster (4/11/2012)
Yes, they are. http://www.sqlservercentral.com/Forums/Topic1281318-203-1.aspxWow. Did I catch that right? The OP posted in an Article discussion because we weren't answering the questions elsewhere?
And now he...
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 11, 2012 at 10:23 am
asranantha (4/11/2012)
i donot liku ur suggestions.
That's fine, I don't like these kind of questions.
better u go schhol.
I've done a number of years at schools, university and in various training courses...
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 11, 2012 at 10:22 am
asranantha (4/11/2012)
i try to search anserrs in google.but iam not getting ansers clearly thats why i post here
Really? Strange, the link I posted (which was your exact question typed into...
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 11, 2012 at 10:17 am
Sapen (4/11/2012)
I just noticed this morning that on our production server when I query select * from sys.databases the Page_Verify_Option_desc column shows TORN_PAGE_DETECTION for 3 databases.
From Books Online:
PAGE_VERIFY {...
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 11, 2012 at 10:07 am
Viewing 15 posts - 19,186 through 19,200 (of 49,552 total)