Viewing 15 posts - 20,116 through 20,130 (of 49,552 total)
durai nagarajan (2/24/2012)
Hello,What are ther main reasons for log file growth.
IN my case we take only full back up daily, no log backup.
doesnt seams to be shriniking after backup.
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
February 24, 2012 at 5:13 am
The notification posts give links to specific posts, not to the thread, so if the post is deleted (and the thread still exists), the notification link will give an 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
February 24, 2012 at 4:58 am
If that ad-hoc log backup wasn't taken WITH COPY_ONLY and wasn't copied over and restored to the secondary, then the next log restore after that will fail, and so will...
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
February 24, 2012 at 3:46 am
I suppose you could use the OUTPUT clause too.
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
February 24, 2012 at 2:07 am
You can backup and restore, no problem. Note that it's a one-way operation, once the DB is restored to 2005, you cannot move it back to SQL 2000.
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
February 23, 2012 at 5:12 pm
rlswisher (2/23/2012)
SELECT
FROM Table a
LEFT JOIN Table b ON a.ID= b.ID
WHERE a.col1=1
AND a.ID=...
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
February 23, 2012 at 11:40 am
I have seen a case where the hardware was upgraded and the performance went through the floor. Terribly written code, poor design, useless indexes. On the older hardware SQL hadn'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
February 23, 2012 at 11:09 am
Restore from last good backup. If the DB is in full recovery and has log backups, it might be possible to take a tail-log backup and restore right up to...
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
February 23, 2012 at 10:40 am
HowardW (2/23/2012)
Is anyone here going to SQLBits X in London?
I was hoping to, but the time frame doesn't suit. Maybe SQL Bits 11, whenever that will be.
Still waiting to...
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
February 23, 2012 at 10:38 am
If the index is disabled, the metadata is still there. That's all that's needed to rebuild an index (rebuild actually creates an new index structure). If the index is actually...
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
February 23, 2012 at 9:13 am
It's done as part of the query. How depends on what kind of plan the optimiser comes up with. For an EXISTS, it can usually turn that into a semi-join...
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
February 23, 2012 at 8:08 am
Kargan (2/23/2012)
Also why in sys.databases table the column log_reuse_wait_desc shows "LOG_BACKUP'. Also I would like to know how to avoid these log errors going forward.
That's not an error. That's saying...
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
February 23, 2012 at 7:46 am
Why don't you just use the working query that you have? It does what you want already.
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
February 23, 2012 at 7:45 am
It won't impact data files.
You must have compat mode less than 90 to use Dump Tran. It's been deprecated for probably 10 or so years.
Please go and read 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
February 23, 2012 at 3:14 am
SQL_Surfer (2/22/2012)
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
February 23, 2012 at 3:06 am
Viewing 15 posts - 20,116 through 20,130 (of 49,552 total)