Hmmm. Yes, this was clear, but HOW are you filtering data?

Should the query return rows that match the date exactly or are you...

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...