Then the error must be...

Just in general, if you (almost) always query table* "v0_AccountSecuritiesBASEL_III" by DataDate, then you should strongly consider clustering the table on that date first, rather than on -- my best...

Instead of changing the code like that, just remove the UPDATE STATS statement entirely. You shouldn't be doing that all throughout code anyway.

jmoorhead14 (5/22/2014)

DECLARE @spid int

SELECT

@spid = MIN(l.request_session_id)

FROM

sys.dm_tran_locks l

INNER JOIN sys.dm_tran_active_transactions t...

If you're on Enterprise Edition you can add "ONLINE = ON" and the table can still be used while the index is being built.

I prefer to always explicitly specify the...

Sample data in a consumable format would be most helpful.

I'm pretty sure my query gives you that. ...

Hmm, I expected my code to give you that.

Can the same guid appear more than once??

Instead of disabling the trigger, which would affect all row updates, of course, you might want to consider using CONTEXT_INFO() to selectively bypass trigger processing just for your updates.

For example:

CREATE...

Maybe this; not 100% sure of the final output you want to see:

select x.guid, x.max_intime, x.max_outtime

from

(

select guid,

max (case when gatestatus = 1 then Gatetime else...

Here's another version. It uses no extra tables and makes no assumptions: start date and/or end date can be on a weekend, and all SQL settings, including language, are...

At a minimum, you need to look at missing index stats and usage stats. (Beyond min, you would include sys.dm_db_index_operational_stats.)

Below are queries that will list what you...

Look for triggers on the underlying tables. For example, some locations prefer so-called "soft deletes", where the row is never actually deleted, but instead a "deleted" flag gets set....

SQL always interprets format 'YYYYMMDD' correctly, regardless of SQL settings:

, @start='20140426 00:00:00',@end='20140607 00:00:00'

Under "sys.dm_db_partition_stats" in Books Online:

"

Requires VIEW DATABASE STATE permission to query

"

GilaMonster (5/14/2014)

No, that would be silly. Dynamic SQL works excellently...