Viewing 15 posts - 23,506 through 23,520 (of 49,552 total)
The index recommendations are a great place to start but a terrible place to finish.
The optimiser based them on a single query at a time, it does not consider...
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
September 15, 2011 at 9:01 am
Edit: Removed. I'm not willing to help people who have no manners.
Div: This is a volunteer site, we don't owe you anything. Telling someone to 'shut their mouth' is hardly...
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
September 15, 2011 at 8:13 am
webtomte (9/15/2011)
I aggre but still if someone for a reason needs to shrink the files as described here.This may do the trick.
If the reason for the log being full is...
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
September 15, 2011 at 5:06 am
padhu.mukku (9/15/2011)
if it is just to optimize why dont u use Merge for it??
Merge is a data modification statement, not a more optimal version of NOT 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
September 15, 2011 at 5:01 am
Thinky Night (9/15/2011)
To optimize the query
It's not likely to be more efficient and it could change the meaning of 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
September 15, 2011 at 5:00 am
pierrelessing (9/15/2011)
Ok cool, thanks. So best is then that I create different backup devices for:1. Full backup
2. Differential backup
3. T-Log backup
No. Ignore backup devices and write each backup to its...
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
September 15, 2011 at 4:41 am
None of that will help when the log can't be used due to replication.
Shrinking the log as small as possible is bad practice unless you immediately regrow it to 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
September 15, 2011 at 4:39 am
forsqlserver (9/15/2011)
will it not break the sequence chain...
Huh?
If you've got questions, please ask them clearly.
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
September 15, 2011 at 4:09 am
If you want to get technical, a table is either a heap or a clustered index. That's how it's organised, doesn't affect how it behaves (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
September 15, 2011 at 3:42 am
Thinky Night (9/15/2011)
How do i change this query with A MINUS OPERATOR?
Why would you want 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
September 15, 2011 at 3:40 am
That's the only meaning I could think of, you can't insert into indexes, only into tables (or views sometimes).
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
September 15, 2011 at 3:38 am
Is there a question here?
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
September 15, 2011 at 3:33 am
Always, always, always, always specify the lengths of your columns. The defaults are not consistent and most people don't know what they are.
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
September 15, 2011 at 3:32 am
What does happen, is that if the table has a cluster and is not empty, BULK INSERT has to be fully logged, not minimally logged
Edit: Misread. Thought it said bulk...
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
September 15, 2011 at 3:30 am
OakDBA (9/14/2011)
Just ran into the same issue. Cleared the hold on the log by runningsp_repldone null, null, 0, 0, 1
Just bear in mind that is usually a temporary fix,...
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
September 15, 2011 at 3:29 am
Viewing 15 posts - 23,506 through 23,520 (of 49,552 total)