Viewing 15 posts - 32,086 through 32,100 (of 49,552 total)
river1 (7/1/2010)
If a database is suspect what will be is state_desc?
SUSPECT
If a database is in read_only what will be is state_desc?
Probably ONLINE. The is_read_only column (also in sys.databases) will 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
July 1, 2010 at 4:52 am
SQLSeTTeR (7/1/2010)
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
July 1, 2010 at 4:50 am
No need for a procedure. Query sys.databases, most of the columns you want are in there.
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
July 1, 2010 at 4:36 am
Just bear in mind that the above query will break if there are any rows in the table that don't have a , somewhere in that string. If there's a...
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
July 1, 2010 at 4:01 am
Update statistics with fullscan on all tables involved. Do that before you force the join hint as Dave suggests, then test and see if the join hint is still necessary....
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
July 1, 2010 at 3:37 am
marcosfac (7/1/2010)
Take Full Backup for all User database at 5pm and another at 11pm
Between 11pm...
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
July 1, 2010 at 2:16 am
High CMEMTHREAD waits?
Do these describe your symptoms?
http://sqlinthewild.co.za/index.php/2008/05/02/token-and-perm-user-store-growth/
http://sqlinthewild.co.za/index.php/2007/10/21/memory-and-sql-2005-sp2/
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
July 1, 2010 at 1:53 am
Check the error logs, see if allow updates has been enabled recently.
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
June 30, 2010 at 11:40 pm
How large is large?
Typically SQL scales better up than out. Good hardware, optimised queries, appropriate indexes will get you a long way.
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
June 30, 2010 at 11:38 pm
Jeff Moden (6/30/2010)
... but don't mind giving a little advice on what to change. 😉
The entire thing? 😉
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
June 30, 2010 at 11:26 pm
Maybe. How fast does data get added to the table? How long before queries of latest rows start to go bad?
Is a common problem with queries that filter for...
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
June 30, 2010 at 3:23 pm
Joel Paula-461376 (6/30/2010)
I thought it was related to the index statistics needing update but updating index statistics didn't make any difference.
Did you update with fullscan? If not, try that. This...
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
June 30, 2010 at 2:21 pm
Fix the problem, don't hide the symptoms.
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post 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
June 30, 2010 at 1:58 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
June 30, 2010 at 1:57 pm
Sam Phillips (6/30/2010)
Shame the estimated plan doesn't work (I feel I'm about to be corrected again). 😛
It usually works a lot better than it does here.
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
June 30, 2010 at 1:54 pm
Viewing 15 posts - 32,086 through 32,100 (of 49,552 total)