Viewing 15 posts - 22,351 through 22,365 (of 49,552 total)
Ninja's_RGR'us (11/1/2011)
It's different than updatestats will fullscan. It filters out some stats based on many conditions.
It excludes stats that have had 0 changes since the last update, but that's...
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
November 10, 2011 at 6:24 am
Lexa (11/2/2011)
So basically you cannot "over" update statistics, right?
No, but there's a point of diminishing returns, where the gain from the new stats has no effect on the query plans...
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
November 10, 2011 at 6:23 am
Usman Butt (11/10/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
November 10, 2011 at 6:15 am
Ninja's_RGR'us (11/10/2011)
AFAIK, the lock taken by update stat is a schema lock. Meaning you can't alter 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
November 10, 2011 at 6:12 am
The exec DMVs are server-wide.
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
November 10, 2011 at 6:01 am
A database in compat mode 80 on a SQL 2005 server is a SQL 2005 database. You can get the query plans in exactly the way you showed, you just...
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
November 10, 2011 at 5:19 am
Jeff Moden (11/10/2011)
I don't know if anyone else noticed but Gail isn't just the leading point holder anymore... she's also the leading poster![font="Arial Black"]Congrats Gail!!! [/font]
Thanks. Steve's still...
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
November 10, 2011 at 4:57 am
leemunyasia (11/10/2011)
It says Service pack 2 at the very end, what I am trying to establish is:
What it says at the end is "Windows NT 5.2 (Build 3790: Service Pack...
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
November 10, 2011 at 4:02 am
Those are both running SP3 or close to it, so they're well fast the SP2 you want to install. Installing SP4 would be a good idea.
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
November 10, 2011 at 3:29 am
It is incorrect, but not quite in the sense you asked.
The article states: 'Instance A, which experiences significant I/O, now has two I/O threads and two lazy writer threads, while...
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
November 10, 2011 at 3:21 am
Joy Smith San (11/10/2011)
I have a doubt.
sometime back One of our database went in "Recovery" state. May be due to rollback/roll forward or due to large VLFs.
Suppose if it...
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
November 10, 2011 at 3:10 am
It's hanging on one of the upgrade scripts. There's a whole lot of upgrade steps that have to run and there's only one listed in the log.
Is the restore process...
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
November 10, 2011 at 3:04 am
derekr 43208 (11/9/2011)
So when a NC index is created, its leaf pages match the order of the data pages
No, no, no. Nothing whatsoever to do with the data pages. When...
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
November 10, 2011 at 3:03 am
shanmugaraj-307582 (11/10/2011)
just look this site
I would suggest people don't read that. It has a number of mistakes in it. The main one being that the author of that describes 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
November 10, 2011 at 3:00 am
forsqlserver (11/9/2011)
Thanks Gail....I thinks it requires half day for rebuild the system DBs...
I make it 5 days from the time the thread started...
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
November 10, 2011 at 2:57 am
Viewing 15 posts - 22,351 through 22,365 (of 49,552 total)