Viewing 15 posts - 12,931 through 12,945 (of 49,552 total)
Get yourself a copy of SQL Server 2008 Internals by Kalen Delaney, there's an entire chapter on how CheckDB works.
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
June 1, 2013 at 3:29 am
Jack Corbett (5/31/2013)
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
June 1, 2013 at 3:26 am
The only time when CheckDB is run on a database is when a user, application or job explicitly runs CheckDB.
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
May 31, 2013 at 4:17 pm
No, table-type parameters have to be read only.
Declare a table variable inside the proc, insert the contents of the parameter into that and manipulate as you like. Or create 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
May 31, 2013 at 1:48 pm
Lynn Pettis (5/31/2013)
Your log file won't shrink(when using SHRINK_FILE) until you start getting the VLFs at the front of the file to an inactive status.
End of the file.
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
May 31, 2013 at 1:46 pm
And there's your problem right there...
Kingfish (5/31/2013)
backup log mydatabaseto disk = '\\someserver\backups\logbackup_timestamp.bak'
with no_truncate, init
You've explicitly told SQL to not truncate the transaction log on backup, not to mark portions of...
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
May 31, 2013 at 1:45 pm
Could you post the exact log backup command that you're running?
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
May 31, 2013 at 1:33 pm
What are you trying to do?
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
May 31, 2013 at 1:32 pm
GilaMonster (5/31/2013)
If you see that the log is not being reused after a log backup and the log file keeps on growing, then please take a read through this: http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
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
May 31, 2013 at 10:06 am
Log backups don't shrink the log file, hence you shouldn't expect to see the log file get smaller. Log backups just mark portions of the log reusable.
If you see 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
May 31, 2013 at 9:11 am
Not being nasty, but could you edit that and take out the font tags? Use the [ code ] tags (shortcut on the left)
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
May 31, 2013 at 9:07 am
Query text?
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
May 31, 2013 at 8:41 am
Yes, it's not exempt from licensing as a passive standby server would be, hence it needs to be licensed. There's nothing in the licensing docs that say anything about number...
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
May 31, 2013 at 8:40 am
SELECT * FROM master.sys.messages WHERE text LIKE 'New queries assigned to process on%'
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
May 31, 2013 at 7:42 am
rajeev.training (5/31/2013)
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
May 31, 2013 at 7:41 am
Viewing 15 posts - 12,931 through 12,945 (of 49,552 total)