Viewing 15 posts - 37,336 through 37,350 (of 49,552 total)
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
July 30, 2009 at 3:28 pm
Have you tried updating statistics?
UPDATE STATISTICS <Table Name>
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 30, 2009 at 2:03 pm
A process becomes suspended when it has to wait for a resource. To figure out why it's suspended, check what resource it's waiting for. Query sys.dm_exec_requests and check the wait_type...
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 30, 2009 at 1:54 pm
All data changes are done as part of a transaction, whether the transaction be explicitly started or not. Even a single statement update is done as a transaction (which includes...
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 30, 2009 at 1:52 pm
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic762623-146-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
July 30, 2009 at 12:28 pm
What transaction log backups do you have?
Since the DB is in full recovery, you must have some or that log would have long since grown out of control.
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 30, 2009 at 12:28 pm
What do you mean by 'can't open transaction'?
Is your user getting an error? If so, what error?
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 30, 2009 at 9:27 am
The log backups won't necessarily be identical. The NO_TRUNCATE on the first one will ensure that they both start at the same point, but the second may contain records 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
July 30, 2009 at 9:09 am
gregory.anderson (7/30/2009)
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 30, 2009 at 9:04 am
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-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
July 30, 2009 at 8:59 am
EdVassie (7/30/2009)
Get expert help. 40TB is a leading edge system and very few people will have the experience to give you useful advice.
Agreed. This is not 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 30, 2009 at 7:25 am
In all the SSAS recommendations I've read (and the ones I've made) the datetime is stored in the SQL table as a datetime, to whatever granularity the user wants to...
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 30, 2009 at 7:15 am
Should be possible, I can't think of a reason why it wouldn't. What have you tried and what problems are you having.
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 30, 2009 at 5:30 am
Do you want the trigger to fire only for a specific user, or do you want the trigger to fire for everyone whenever a certain user is logged in?
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 30, 2009 at 5:11 am
Sleeping just means not currently running a query. It's easy for a sleeping connection to still be holding locks if a transaction it ran earlier wasn't committed.
Switch traceflag 1222 on....
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 30, 2009 at 4:00 am
Viewing 15 posts - 37,336 through 37,350 (of 49,552 total)