Viewing 15 posts - 16,936 through 16,950 (of 49,552 total)
Technically it's not minimally logged. It doesn't behave as minimally logged operations do. It's fully logged, just as drop table is fully logged. Both of them log just the page...
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
August 27, 2012 at 2:06 am
That the alert is set up in error, buffer cache hit ratio of 100 is good, not bad.
Double-check what the alert was actually complaining about. It is was buffer cache...
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
August 27, 2012 at 1:05 am
Option 1: Restore from backup.
Option 2: Restore from backup.
Option 3: http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/ and then spend some time examining the DB for consistency errors (in data, not structure) and fixing them
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
August 27, 2012 at 12:29 am
There's nothing there that looks like it needs fixing.
Buffer cache hit ratio - higher is better, so 100 is good, not a problem that needs fixing.
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
August 27, 2012 at 12:27 am
It's FASTFIRSTROW that no longer works, the replacement is FAST 1
It's worth noting, the FAST 1 hint will result in the optimiser estimating and optimising for 1 row only. 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
August 26, 2012 at 2:16 pm
Please don't hijack other people's threads. You've already created 3 for this problem.
Any replies to mfundotogu please direct to http://www.sqlservercentral.com/Forums/Topic1350128-391-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
August 26, 2012 at 1:11 pm
And those are? Be specific, list exactly what must be returned (as the article I linked explains)
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
August 26, 2012 at 1:10 pm
So what should it return?
http://www.sqlservercentral.com/articles/Best+Practices/61537/
p.s. Hotel booking systems are often used as exercises for database courses because they're very hard to get right.
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
August 26, 2012 at 12:52 pm
What's the table definitions? What's the sample data? What's the problem with the query?
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
August 26, 2012 at 12:13 pm
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/Topic1350128-391-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
August 26, 2012 at 12:12 pm
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/Topic1350128-391-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
August 26, 2012 at 12:12 pm
The second thing I'd do is take the nolock hints out. See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
If the sort has to be there and is the most expensive portion, there's not really much...
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
August 26, 2012 at 11:22 am
Any password system where you can retrieve the original password is a weak one. Passwords should never be stored using reversible encryption.
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
August 26, 2012 at 11:20 am
There's a problem sometimes when DTC is involved (distributed transaction coordinator). The actual client goes away but SQL doesn't notice because DTS (which sits between the client and the server)...
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
August 26, 2012 at 6:51 am
SSIS homework?
Odd request, if I want the rows sorted, they have to be sorted somewhere...
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
August 26, 2012 at 4:39 am
Viewing 15 posts - 16,936 through 16,950 (of 49,552 total)