Viewing 15 posts - 30,286 through 30,300 (of 49,552 total)
Exactly as in step by step code walkthrough? Or do you just want a high level overview?
If high level overview:
For commit: http://msdn.microsoft.com/en-us/library/ms190295%28v=SQL.90%29.aspx and http://msdn.microsoft.com/en-us/library/ms175523%28v=SQL.90%29.aspx
For checkpoint, start here: http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/
Which truncate 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 30, 2010 at 10:53 am
doctom22 (9/30/2010)
- Commit: Operation that confirms (records) the transaction in log of transaction.
Kinda, but not quite.
- Chackpoint: Process that generates a marking in log of transaction and transfers the data...
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 30, 2010 at 5:54 am
If the existing maint plan is for all DBs, just remove the log shipping one. Otherwise disable it.
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 30, 2010 at 2:19 am
If you are going to log ship, the log shipping job should be the only log backup job there is. You are complicating the situation massively. Why don't you want...
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 30, 2010 at 1:21 am
UMG Developer (9/29/2010)
PaulB-TheOneAndOnly (9/29/2010)
DISTINCT and GROUP BY are two very different tools...
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 30, 2010 at 1:16 am
I'm betting the average has increased dramatically over the years. Might be interesting to see an avg posts/day for each of those 9 years.
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 29, 2010 at 4:31 pm
Yup.
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 29, 2010 at 2:32 pm
Kit G (9/29/2010)
Jack Corbett (9/29/2010)
Why assume that this person is a male?:-P
Because a woman couldn't possibly be wrong and therefore whatever she came up with would work and wouldn't be...
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 29, 2010 at 2:13 pm
If you cast it to a numeric type (tinyint) you should be able to use MAX.
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 29, 2010 at 12:13 pm
That or change the dates so that the format is unambiguous. yyyy-mm-dd works well.
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 29, 2010 at 10:17 am
The exams assume that you have practical experience, either from working in the field or practising on your own. You're unlikely to pass without that experience.
From the official website:
Audience Profile
Candidates...
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 29, 2010 at 10:08 am
Firstly why are you shrinking your database in a maintenance plan?
You probably have autoshrink enabled as well and the autoshrink is shrinking while the scheduled shrink is trying to run.
Error...
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 29, 2010 at 7:57 am
Grant Fritchey (9/29/2010)
GilaMonster (9/29/2010)
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 29, 2010 at 7:49 am
The problem is with the column [Codigo]. It's 4 characters long but your insert has a 5 character value specified for it (N' 0002'). There's a leading space that makes...
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 29, 2010 at 7:49 am
Brandie Tarvin (9/29/2010)
Secondly, he should be asking you what he can do to facilitate what you're doing. Not badgering you about the fact that you're behind schedule.
An extension of 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
September 29, 2010 at 7:20 am
Viewing 15 posts - 30,286 through 30,300 (of 49,552 total)