Viewing 15 posts - 9,136 through 9,150 (of 49,552 total)
SQL doesn't use the page file.
How are you checking its size and how is the page file configured? (and why are you concerned about its size?)
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 6, 2014 at 10:41 am
It's exactly what I explained above. Existing rows in the table (previously committed) being missed because the page those existing rows is on is splitting due to an insert/update occuring.
"Long...
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 6, 2014 at 8:58 am
Stefan Krzywicki (5/6/2014)
Maybe it is just that if a split has occurred, NOLOCK can return bad data, even if the split happened awhile ago?
A scan under read uncommitted can...
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 6, 2014 at 8:40 am
No, it was not me that pointed it out, because for a page split to occur, there must be an insert/update operation occurring. SQL doesn't randomly, when it's bored, move...
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 6, 2014 at 8:24 am
The only 'tie-in' with extents is that full and diff backups both backup extent by extent, not page by page. A differential backup contains all the extents which changed since...
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 5, 2014 at 3:17 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1567529-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
May 5, 2014 at 8:38 am
The missing index DMV always recommends the exact best index for a single query. It takes makes no consideration as to whether the index is a near-duplicate with an existing...
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 5, 2014 at 8:35 am
akhamoshioke (5/5/2014)
http://technet.microsoft.com/en-us/library/ms345448(v=sql.105).aspx
I'm fully aware of how differential backups work, as I'm sure is Perry. Was there a specific point you wanted to make?
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 5, 2014 at 8:26 am
Diffs DO rely on the LSN of the last full backup. Logs do not. Logs rely on the LSN of the previous log backup.
That's why COPY_ONLY is used on 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 5, 2014 at 8:15 am
Elliswhite (5/5/2014)
1.Right click on the database in SQL Server Management Studio, and hit Detach.
2.Select the Drop Connections checkbox only, and hit ok.
3.Then the database 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
May 5, 2014 at 8:06 am
akhamoshioke (5/5/2014)
I do believe that diff and log backups don't break the log chain but the rely on the LAN from the last full to work don't they?
Diffs do, not...
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 5, 2014 at 7:56 am
Jeff Moden (5/4/2014)
my interpretation is that if the COPY_ONLY option is on, it won't interfere with either differential backups or PIT log backups.
Correct.
However, a full backup without COPY_ONLY won'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
May 5, 2014 at 5:11 am
prakashr.r7 (5/5/2014)
1.What is the difference between OLEDB and OLAP and OLTP ?
I suspect you either misheard or that was a trick question. OLEDB is something completely, totally different from...
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 5, 2014 at 5:03 am
ramyours2003 (5/4/2014)
how to shrink the logfile of the database who is configured in replication?
Exactly the same way you shrink a log file for a DB that isn't replicated. DBCC...
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 5, 2014 at 5:01 am
thomashohner (5/4/2014)
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 4, 2014 at 1:28 pm
Viewing 15 posts - 9,136 through 9,150 (of 49,552 total)