jeff.mason (3/14/2013)

---

If by "fail over" you mean start using, then no, you can't. A failover on an asynch setup will cause recovery to happen. Once a database recovers,...

Anyone?

krn045 (1/21/2013)

---

Hi..

We are using SCOM 2007 to monitor SQL Server 2008 instances. I have checked the blocked sessions alert details in SCOM console as well as in OperationsManager database. I...

JoeSchmoe007 (12/13/2012)

---

This article is useful. However, this approach will not work well for logins if Windows authentication is used for some logins and primary and DR servers are not a...

Kristian Ask (11/16/2012)

---

I know it's an old topic but how is included columns affecting memory footprint? Some say higher use to put index in.memory cache. Some say lower since less...

webwilliam (11/14/2012)

---

Disregard my post. I ran a sp_recompile on my stored procedure to reset everything. Then when my job ran I saw the execution_count jump to 41.

I then realized...

Thank...

Thank you for the article.

I found the section titled "How does SQL use the log?" particularly well written.

I hope I am not the only one that feels this way,...

Any ideas on this anyone?

Thanks both!

I think I will incorporate this (>1,000 pages for intermediate levels) as a criterion for rebuilding indexes with avg frag > 30% (at the intermediate level in question).

No comments? :crying:

GilaMonster (10/30/2012)

---

Probably not. The fragmented level is not 1000 pages, it's most likely going to be in memory. Maybe, if you're doing huge range scans that require SQL to read...

My fault, I was filtering on the following in the 1st query, but did not post that part in the opening post:

WHERE

F.avg_fragmentation_in_percent > 10

AND F.page_count > 100

As a result,...

I added a filter in the...

GilaMonster (10/30/2012)

---

You're looking at a nonclustered index in the first one (index id 9) and all indexes (clustered and nonclustered in the second)

p.s. sys.sysindexes is deprecated, should not be used....