Viewing 15 posts - 15,271 through 15,285 (of 49,552 total)
Correct, backup log with truncate_only does not work in 2008 and above, and bloody good riddance too. That was far too badly abused by people that didn't actually know what...
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
December 12, 2012 at 12:49 am
Nice procedure. So what do you expect us to do with it?
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
December 11, 2012 at 11:42 pm
Mohammed Imran Ali (12/11/2012)
Could this be the reason why the log file is not releasing space? Any clarification on this is much appreciated.
The only thing that releases space back 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
December 11, 2012 at 11:41 pm
doug.baker-706021 (12/11/2012)
What I really wanted to know was whether you would proceed differently (i.e., more cautiously) knowing the corruption affected a system table as opposed to a user table.
Generally,...
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
December 11, 2012 at 11:38 pm
CptCrusty1 (12/11/2012)
Gail, I once asked you why you're called Gila Monster.
Old story.
Gail
Gila
Notice the letter ordering. Now add a friend with a mild typing problem (typed faster with her 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
December 11, 2012 at 3:41 pm
Could you start a new thread for your corruption problem please?
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
December 11, 2012 at 3:39 pm
What's the distinct for? If you have messy data, clean it up. Distinct is not a cheap operation.
Watch the nolocks.
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.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
December 11, 2012 at 2:47 pm
As I already explained, SQL will fill one file, then fill the other, and if there's no reusable space, both will grow.
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
December 11, 2012 at 1:50 pm
Recovery model is determined by your recovery requirements in the case of a disaster. If you need to be able to restore to point in time, then you need full...
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
December 11, 2012 at 1:49 pm
Lowell (12/11/2012)
no insults, just help with the logical rules of thumb for procedures and functions:avoid loops whenever possible: that's cursor, while loops whatever;
Additionally
Avoid data access in a scalar UDF...
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
December 11, 2012 at 1:42 pm
Why don't you run it and see?
p.s. Stay away from index hints.
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
December 11, 2012 at 1:31 pm
CptCrusty1 (12/11/2012)
Yeah, that's right....Before I use your spiffily written Scalar, how bad is mine? I can take it....
Err... Molasses in a Canadian winter. 😀
I would recommend you use 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
December 11, 2012 at 1:01 pm
sankar276 (12/11/2012)
If the clustered index key long and it is not in increasing order you will find more bookmark lookups which leads to more fragmentation.
Bookmark lookups don't lead to fragmentation....
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
December 11, 2012 at 12:59 pm
olivia.forde (12/11/2012)
GilaMontser - so the way I have it is the most efficient - it takes hours to run so I was hoping it could be improved.
I didn't say 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
December 11, 2012 at 9:48 am
Because that's not the way SQL is designed to work with its files. If there are two log files, both will fill up, that will trigger the autogrow and they'll...
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
December 11, 2012 at 9:02 am
Viewing 15 posts - 15,271 through 15,285 (of 49,552 total)