Viewing 15 posts - 29,446 through 29,460 (of 49,552 total)
The briefcase feature 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
November 10, 2010 at 8:26 am
Michael L John (11/10/2010)
My question is why is the log file so big in the model database?
Indeed.
There should be no activity in model. There should be nothing happening to fill...
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
November 10, 2010 at 8:00 am
kiranjanjanam (11/8/2010)
The Maint. Plan has three tasks...1) Diff backup (above code)
2) T-Log Backup
3) Full Backup with COPY_ONLY option
There's your problem. It's not the diff backup that's breaking the log...
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
November 10, 2010 at 7:22 am
george25 (11/10/2010)
What, if anything, should I do?
Identify why it hit 80GB and what size it needs to be for normal operation.
Check the % used during peak usage, during any 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
November 10, 2010 at 7:09 am
Craig Farrell (11/9/2010)
*lifts up rock, and cringes away from the sun* I can't get some of these clients off SQL 2k...
I know someone who's still forced to work with...
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
November 9, 2010 at 2:16 pm
Alvin Ramard (11/9/2010)
Is this the version that most would call SQL 2011?
It's not officially SQL 20 anything. Code name is Denali, major version is 11. It's been referred to 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
November 9, 2010 at 2:12 pm
In case anyone (living under a rock maybe) missed the announcement:
Microsoft® SQL Server® code-named 'Denali' - Community Technology Preview 1 (CTP1) : http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9
Got a blog post with a couple bits...
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
November 9, 2010 at 1:50 pm
I love Wayne's reply there (last page)
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
November 9, 2010 at 1:38 pm
Steve Jones - SSC Editor (11/9/2010)
To me, however, the iPad is a better deal (although more expensive) right now since it allows you to purchase from multiple places.
My thoughts...
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
November 9, 2010 at 8:19 am
paul.knibbs (11/9/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
November 9, 2010 at 7:53 am
george25 (11/9/2010)
GuysI hate to keep banging on about this but my databases use simple recovery. Log backups are, pardon the pun, simply not an issue.
And?
Everything that I stated 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
November 9, 2010 at 6:46 am
george25 (11/9/2010)
I've yet to see a convincing argument for not shrinking log files for databases using the simple recovery model where the transaction log is not crucial
1) They will just...
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
November 9, 2010 at 6:29 am
Nothing requires the nolock hint. If you're using it, make sure you understand what it does.
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
November 9, 2010 at 6:26 am
New question. New thread 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
November 9, 2010 at 6:20 am
parthi-1705 (11/9/2010)
Terrible, generic advice omitted
Aaahhh!
Why it is happening because there might not enough space in server to have data's or to load data's
Absolutely not. Insufficient space will not send...
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
November 9, 2010 at 6:19 am
Viewing 15 posts - 29,446 through 29,460 (of 49,552 total)