Here is the culprit:

OR(ISNULL(LoggedDt,'''')) LIKE '%' + @LoggedDt + '%'

You should convert @LoggedDt to some string representation before concatenating to '%'.

However, this is not a good idea from a performance/data...

Probably your post got truncated, but I see no question here.

Can you clarify please?

I guess some hidden scheduled task is working on the database during the weekend.

I would suggest capturing statements with a server-side trace and look at the results on monday.

It could be anything, we need much more detail to advise sensibly.

First of all I would check for locks and find the locking leader, then I would try to inspect...

Jeff's latest article is great, and the discussion rocks.

If you haven't checked it yet, go and have a look!

I love this community.

This thread is getting more and more exciting.

Awesome.

Brandie Tarvin (5/6/2011)

---

Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.

Editor's Note:

---

...

OK, now it definitely works.

I got it working after a long fight with permissions, policies, and registry keys.

...and I thought that a DBA didn't need to be a Windows...

+1

The queue starts to overflow...

Jeff, your article is great!

The final splitter function could have been 3 times slower than the original one, and the article would have been memorable anyway. It's a tale of...

Is that an issue? Does the system respond slowly?

If so, you could limit sql server max memory:

EXEC sys.sp_configure N'max server memory (MB)', N'14336' -- 14 GB

GO

RECONFIGURE WITH OVERRIDE

GO

This way you...

Restarting the service is not a good idea. SQL Server will have to build its cache from scratch, including cached plans.

I would suggest limiting SQL Server memory if there's an...

The script is complete in my last post, you will only need a Tally table.

You can grab one here: http://www.sqlservercentral.com/articles/T-SQL/62867/

Hope this helps

Gianluca

nathan.rudy (4/26/2011)

---

Hi, I'm just reading the post you put on in regards to Calculating Open incidents per month. Just wondering if you had the final full script that you...

Actually, you could also use the performance data collector and set up a custom collection.