Viewing 15 posts - 28,636 through 28,650 (of 49,552 total)
luckysql.kinda (1/4/2011)
I like following thread for Resolving Full Log Esp in Simple Recovery Mode and then click on Link
The database isn't suspect, so I don't know what the point 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
January 4, 2011 at 10:50 pm
Could have been either.
Should the DB be in simple recovery? Point-in-time restores not necessary?
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
January 4, 2011 at 2:43 pm
Don't reinvent the wheel. There are lots of scripts written and tested that do just this. Like the one found here: http://www.sqlfool.com
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
January 4, 2011 at 2:05 pm
calvo (1/4/2011)
Checkpoints flush buffer cache to disk. Nothing to do with truncating a log.
Not entirely true.
Checkpoint writes all dirty data page to disk and then, in simple recovery only, marks...
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
January 4, 2011 at 1:48 pm
winston Smith (1/4/2011)
but once i perform a full backup, isnt a checkpoint automatically performed, which will allow me to do a dbcc shrinkfile on the log file?
Only in Simple recovery....
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
January 4, 2011 at 1:45 pm
Why can't you use a procedure that returns a resultset?
(Untested code)
CREATE PROCEDURE getRateIndexValue(@IndexKey integer)
AS
BEGIN
DECLARE @ricnt as varchar(5);
DECLARE @SqlStmt nvarchar(4000);
SELECT @ricnt = RICNT from RIRCD...
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
January 4, 2011 at 12:58 pm
There's no point in creating a database before you do the restore. Whatever that database is is completely overwritten during the restore, no properties, structure or settings remain. Just restore...
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
January 4, 2011 at 12:52 pm
The only way you can do that is to query the plan cache, read through the xml of the query plan and see if the index is there. If there...
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
January 4, 2011 at 10:53 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1042519-391-1.aspx
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
January 4, 2011 at 10:42 am
Koen (da-zero) (1/4/2011)
GilaMonster (1/4/2011)
<sigh> Talking plagiarism. He really should know better...http://www.sqlservercentral.com/Forums/Topic1042151-2799-1.aspx
Waw, LutzM's reply is really brutal 😀
(but I'm thinking the same thing)
Missed it when Steve cleaned up. Someone enlighten me?
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
January 4, 2011 at 10:25 am
No. Full backups and log backups are two completely different things. Full backups do not and never have truncated the transaction log. In full and bulk-logged recovery you need 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
January 4, 2011 at 10:20 am
rhlangley (1/4/2011)
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
January 4, 2011 at 7:07 am
Please post table definitions, sample data and expected results. See http://www.sqlservercentral.com/articles/Best+Practices/61537/ for the best way.
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
January 4, 2011 at 6:51 am
btw Grant, your SSC sig is still listing your old blog.
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
January 4, 2011 at 6:45 am
<sigh> Talking plagiarism. He really should know better...
http://www.sqlservercentral.com/Forums/Topic1042151-2799-1.aspx
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
January 4, 2011 at 6:02 am
Viewing 15 posts - 28,636 through 28,650 (of 49,552 total)