It seems there is a trace flag for everything :w00t:

While looking into that I also found this (2008 only I'm afraid):

Tracking checkpoints using Extended Events

Paul

No worries.

Nothing worse than working on a Sunday 😀

See http://technet.microsoft.com/en-us/library/cc917684.aspx

That's quite a long (and interesting document) but you just want the section entitled 'Nonyielding Examples Reported to Microsoft'. Just loading the dump and looking at the call...

This...

1. Using a (persisted) computed column would be my preference also. If the date portion is placed first in the compound field, you could arrange the partition function...

Yes - this would...

Sometimes a cursor is the best solution. Not usually the fastest - but then that's not always the primary consideration.

Aside from Profiler, there is a dynamic management view that...

rafa.aborges (1/8/2010)

---

I know that a view with schemabinding improves the performance and creating an indexed view, it can be a lot better. But, my question is: how the view with...

...unless this is Enterprise Edition, with the lock pages in memory privilege granted, 8GB or more of RAM, and trace flag 834 enabled...in which case the entire buffer pool is...

The only other place that the last checkpoint is recorded is in the database boot page. Although you can get to that using DBCC DBINFO, it's not easy to...

Usually with this type of query the problem is that the optimizer underestimates the cost of the full-text query. My money is on the plan changing from being driven...

If I understand the original English description of the requirement correctly, this appears correct:

DECLARE @data TABLE

(

ACHAR(2) NOT NULL,

BINT NOT NULL,

CINT NOT NULL,

VCHAR(2) NOT NULL

);

INSERT@data

VALUES('a1', 0, 11, 'v1'),

('a1', 1, 12, 'v2'),

('a1',-1,...

Hey Mitch,

Here's some code to demonstrate one approach to the problem.

DECLARE @data TABLE

(

primary_key INTEGER NOT NULL PRIMARY KEY,

account_type NVARCHAR(30) NOT NULL,

full_name NVARCHAR(125) NOT NULL,

manager_name NVARCHAR(125) NOT NULL

);

INSERT@data (primary_key, account_type, full_name,...

drew.403 (1/8/2010)

---

I'm hoping there is an actual SQL statement that can be created on the fly to find the records. for example i could imagine something like this working... but...