Viewing 15 posts - 37,486 through 37,500 (of 49,552 total)
Don't use sp_updatestats. That only updates stats that the engine thinks are outdated. Use UPDATE STATISTICS to be sure that the stats do actually get updated.
As for exec plan 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 23, 2009 at 5:06 am
Saurabh Aggarwal (7/23/2009)
do i need to change something in stored procedure ,views etc code also,
Maybe. Are they failing to create too?
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 23, 2009 at 2:22 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/Topic758000-360-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 23, 2009 at 2:21 am
Have you updated statistics since upgrading to SQL 2005? If not, do so and test the query out again.
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 23, 2009 at 2:20 am
Can you post the code that the insert in question is part of?
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 23, 2009 at 2:17 am
FredS (7/22/2009)
I have only a couple tables at the moment. I'm learning, but making mistakes fast and altering table structures will be important.
Look up ALTER TABLE in Books Online.
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 22, 2009 at 1:50 pm
Monica K. Murphy (7/21/2009)
I finally found documentation that verifies that the datapage itself is backed up in the trn log.
That is for bulk operations in bulk-logged recovery only.
If...
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 22, 2009 at 1:50 pm
The definition's fine, just need some sample data. Read this to see the best way to post this to get quick responses. http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 22, 2009 at 1:35 pm
Can you post the current SQL error log? There are a number of reasons why this might be happening, from benign to serious, need to see the error log 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 22, 2009 at 1:03 pm
One thing I forgot to ask...
Is this insert the only statement in the transaction, or is it in an explicit transaction along with other commands?
Is there a trigger on 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 22, 2009 at 12:58 pm
Have more coffee, it's the answer to everything.
Unrelated...
Does anyone really know their deadlocks well? This one has me stumped (though I admit I have not examined the exec plan 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 22, 2009 at 10:37 am
This might help you with the problem that they can pass the parameters or not.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Could you maybe post the entire procedure, the table defintions, some sample data and the expected...
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 22, 2009 at 10:23 am
Indeed. However looking I can't see any reason why this is dynamic SQL at all.
This should work just fine
DECLARE @TreatyNumber As Varchar(20)
SET @TreatyNumber = '200704.2.6'
DECLARE @temp_provisions As Table (
...
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 22, 2009 at 10:11 am
Replace EXEC @sql with EXEC (@SQL)
Without the brackets, the assumption is that the content of the variable is a stored procedure 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 22, 2009 at 9:25 am
The audit login event occurs when someone logs in to SQL. The audit logout event occurs when someone logs out of SQL.
What do you mean by 'affects performance'?
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 22, 2009 at 9:05 am
Viewing 15 posts - 37,486 through 37,500 (of 49,552 total)