Viewing 15 posts - 18,601 through 18,615 (of 49,552 total)
Lynn Pettis (5/8/2012)
Someone more knowledgeable regarding the tlog is welcome to help here.
Gut feel: the DB has been in bulk-logged, and he doesn't realise. Maybe a maintenance job that automatically...
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 8, 2012 at 2:23 pm
michael vessey (5/8/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 8, 2012 at 9:56 am
Allocation errors are errors relating to how pages are owned by various objects. Consistency errors are errors relating to pages that are incorrect.
Both are usually the result of IO subsystem...
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 8, 2012 at 9:04 am
Jeff Moden (5/8/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 8, 2012 at 9:01 am
Artoo22 (5/8/2012)
Firstly, SQL Server already stores created_date.
SELECT name, create_date, modify_date
FROM sys.tables
That's the date the table was created, not the date that a particular row in 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 8, 2012 at 8:51 am
Grizzly Bear (5/8/2012)
Actually they do vanish
Which is what I said....
Now to find out when were they last attached/detached from the System Engineers.
It's not just detached.
Restored, closed (via the autoclose...
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 8, 2012 at 8:48 am
Bear in mind that if/when the plan is flushed from cache, there will be no remaining record of when the plan was last generated.
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 8, 2012 at 8:47 am
Yes. The detach closes the database and all rows for that DB from the index usage DMV (and the index operational stats and missing index DMVs) will be cleared.
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 8, 2012 at 8:41 am
What do you defined as 'compiled'?
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 8, 2012 at 8:11 am
Only the indexes in database 6 have been used since the last time SQL started? All the other databases have autoclose on and hence their entries got flushed out?
That DBV...
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 8, 2012 at 8:08 am
There is one row per index, per table in sys.partitions if there's no partitioning in effect.
How large is the index? How many pages? I'm going to guess it's something insanely...
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 8, 2012 at 6:54 am
ashkan siroos (5/8/2012)
it will change 100 MB data to 100MB+ 200 KB which is not important at all.
That's assuming you have only one case where you have a different 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
May 8, 2012 at 6:48 am
Because they are two completely different queries.
The <> join matches anything that isn't equal, so let's say we have these tables
Tbl1
ID Col1
1 'a'
2 ...
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 8, 2012 at 6:44 am
Ewald Cress (5/8/2012)
I thought I had a decent grasp of logging issues, but I must admit that I had a light-bulb moment when you described the Eager Write mechanism!
Please note...
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 8, 2012 at 6:07 am
ChiragNS (5/8/2012)
Will this increase the log file size or only the log backup size?
Just the log backup. The pages don't go anywhere near the log file itself, they're just copied...
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 8, 2012 at 5:47 am
Viewing 15 posts - 18,601 through 18,615 (of 49,552 total)