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...
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/
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...
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,...
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...
December 11, 2012 at 3:41 pm
Could you start a new thread for your corruption problem please?
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
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.
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...
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...
December 11, 2012 at 1:42 pm
Why don't you run it and see?
p.s. Stay away from index hints.
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...
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....
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....
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...
December 11, 2012 at 9:02 am
Viewing 15 posts - 15,271 through 15,285 (of 49,552 total)