Viewing 15 posts - 30,766 through 30,780 (of 49,552 total)
Simple recovery means that you don't want the log to be retained and you don't need point in time recovery. Hence no log backups. Full and bulk logged means 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
September 12, 2010 at 2:28 am
Lennie (9/11/2010)
GilaMonster (9/11/2010)
A bit is a numeric data type that stores just two possible numeric, 0 and 1. Those are the mathematical numbers and have no special meaning.
...
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 12, 2010 at 2:25 am
CirquedeSQLeil (9/11/2010)
Time to start prepping a TSQLTuesday post.
Already working on mine. Is one that's been part-written for a few months. The question it's intended to address came up on SQLTeam...
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 11, 2010 at 1:31 pm
Total is what SQL currently has. Target is what it thinks it wants under the current load. So if total is lower than target, either SQL is still building up...
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 11, 2010 at 1:25 pm
Alvin Ramard (9/11/2010)
CirquedeSQLeil (9/11/2010)
Anybody else want to try this one?Why? The ball is in the OP's court. Nobody should make a move until he does.
Looks like he doesn't...
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 11, 2010 at 1:08 pm
Um... The image in the thread you refer to IS the SQL 2005 architecture. I don't have one for SQL 2000 handy, but there's very likely one in Books Online.
As...
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 11, 2010 at 1:08 pm
kumar.sachu08 (9/11/2010)
Actually i know whole sole details of sql server, so i know about the sql architecture in details.
Um, if you know SQL architecture in details, why are you asking...
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 11, 2010 at 12:36 pm
kumar.sachu08 (9/11/2010)
i would like to request we don't go beyond our track, like what i will do for that.
If we know the reason and details of the request, maybe we...
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 11, 2010 at 11:48 am
Have you looked in Books Online? There's a whole section on SQL architecture in there.
p.s. I've seen this question multiple times recently, on this and other forums. Class homework or...
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 11, 2010 at 8:41 am
CirquedeSQLeil (9/11/2010)
GilaMonster (9/11/2010)
Stefan Krzywicki (9/10/2010)
Heh, the XBOX version is a short version.
Yeah. The PC version can easily take (me) a week for a single game
Civ V comes out in 2...
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 11, 2010 at 8:04 am
A bit is a numeric data type that stores just two possible numeric, 0 and 1. Those are the mathematical numbers and have no special meaning.
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 11, 2010 at 3:42 am
UMG Developer (9/10/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 11, 2010 at 3:40 am
Stefan Krzywicki (9/10/2010)
Heh, the XBOX version is a short version.
Yeah. The PC version can easily take (me) a week for a single game
Civ V comes out in 2 weeks (ish).
So...
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 11, 2010 at 3:40 am
I love Civ. It's an excellent way to lose a week.
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 10, 2010 at 2:47 pm
No. Playing the campaign for Settlers 5 (found dirt-cheap in bargain bin a couple months ago)
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 10, 2010 at 2:24 pm
Viewing 15 posts - 30,766 through 30,780 (of 49,552 total)