Viewing 15 posts - 18,541 through 18,555 (of 49,552 total)
WayneS (5/11/2012)
GilaMonster (5/11/2012)
Aaah, nerves. The wait is killing me...Must be... London?
No.
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 11, 2012 at 4:08 pm
Well the first thing you can do is take the join hint out.
CREATE VIEW [dbo].[view1]
AS
Select *
From table1 t1
Left hash Join view v on t1.id = v.id"
The chance of the hash...
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 11, 2012 at 2:51 pm
If the log is mostly empty, then a once-off shrink is fine.
You should probaby investigate and see if you can find out what happened at the time that 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
May 11, 2012 at 2:46 pm
Log backups once a day are not very useful. The main point of log backups is to allow point-in-time recovery, taking one a day means you could lose 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
May 11, 2012 at 2:16 pm
inevercheckthis2002 (5/11/2012)
Lynn Pettis (5/11/2012)
Please read the last...
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 11, 2012 at 1:59 pm
Post the view definition 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
May 11, 2012 at 1:58 pm
Rod at work (5/11/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
May 11, 2012 at 1:55 pm
What's confusing?
What should be done to prevent them from growing so large?
That's covered in the articles, read the first one again.
Shoudn't I only need a transaction log big enough 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
May 11, 2012 at 1:52 pm
You would need to add a trigger to the tables or implement change data capture or change tracking.
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 11, 2012 at 1:24 pm
Back when I worked full time I asked my boss if I could spend 30 min a day researching, reading, etc. His immediate reply: "Will that be enough time?" He...
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 11, 2012 at 1:23 pm
Your understanding is not correct. Full backups do nothing to the transaction log.
Please read through this - Managing Transaction Logs[/url] and this: http://www.sqlservercentral.com/articles/Transaction+Log/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 11, 2012 at 1:06 pm
Aaah, nerves. The wait is killing 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
May 11, 2012 at 12:56 pm
Please note: 3 year old thread
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 11, 2012 at 12:36 pm
If those are indicative of the norm, I wouldn't worry at all.
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 11, 2012 at 12:26 pm
Query them from SQL, and/or insert into table from there.
SELECT <columns desired> FROM fn_trace_gettable('<trace file name>', 1)
Saving one by one from the GUI is just painfully slow
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 11, 2012 at 10:08 am
Viewing 15 posts - 18,541 through 18,555 (of 49,552 total)