No problem is a good problem to have!! 😀

My guess is the log reuse is simply because you have log shipping enabled and are getting a fair amount of activity...

crazy4sql (7/7/2014)

---

Thanks Kevin, for taking time to look into this.

All...

neltonk (7/7/2014)

---

Hi I have modified the query as directed. The filters in the query are on the columns that are part of the clustered index (primary key) so I am...

crazy4sql (7/6/2014)

---

I have a sql server where alwayson is configured between the instances. Recently we migrated a database here which is very small of 500mb but it started blotting waits....

If I added everything I wanted to my Common TSQL Mistakes talk it would be about 327 hours long!! 🙂 Actually I did give the talk on a webex...

Eirikur Eiriksson (7/5/2014)

---

I've come across this problem few times in the recent past and found that Implicit conversion from CHAR/VARCHAR to NCHAR/NVARCHAR and vice versa, will cause Index Scans which...

1) There are about a bajillion things that could be at play here.

2)

THAT is a WAY WAY WAY bad thing to do!!!...

Mark down my vote for a clustered index too - with appropriate fill factor as mentioned. Token is looking VERY much like something that will have values spread throughout...

You may want to set up a "device" to backup to.

NOTE: you MUST...

1) You simply MUST fix the IS NULL OR construct - and do so EVERYWHERE you have it in your code.

2) On the whole I would say that...

ALERT!!!! You should NEVER use sp_MSforeachdb!!! http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

I wouldn't be surprised to see that sp_WhoIsActive has all the relevant information from that post exposed. @get_full_inner_text, @get_outer_command, @get_locks, @get_additional_info, @find_block_leaders, @get_transaction_info. But if you have another solution...

ScottPletcher (7/2/2014)

---

I think that's over-stated. Most optimizers will short-circuit when they safely can. Presumably later versions of the...

Grant Fritchey (7/2/2014)

---

And the queries would run even faster if...

Try sp_whoisactive. Be sure to look at all of it's parameters. INCREDIBLY powerful, and FREE!! Find it on SQLBlog.com, including a 30-day blog post series by creator...