Gail,

wouldn't the Database level Audit be enough, as this seems to handle events for Select, Insert, Update, and Delete Actions? Or would the overhead be significant?

No problem.

My main concern is that this isn't necessarily a small change, as it wil have an impact on any query, SP, Function that uses this as a join, as...

If the Database had no collation specified when it was created then it will inherit the Server collation in this case its Case Insensitive so you have to manually set...

What is the collation of the database/table/column? As that is what will be driving this to cause an error.

if you set the column Col2 to a Case Sensitive collation then...

Jeff,

I know you've written a number of articles on running totals, this one (the most recent) sprang to mind, http://www.sqlservercentral.com/articles/T-SQL/68467/, but I'm not sure if this is the one...

The database is running user defined data type, so the selct you are running is attempting to convert the SECCODEID(varchar) to an INT, data type.

If you did

SELECT *...

Using a CAST(NULL as <DataType>) is usually done to ensure that a place holder column has the right datatype for a later process especially when doing an SELECT INTO or...

I've made two refinements the first is the addition of a dynamic interval slicer, and the second was to remove the modulous calculation and replace it with a ROW_NUMBER() based...

I saw the Dynamic pivot of the request and wrote this to pivot the data, its similar to dunstans, there are some simplifications optimisations that can be made like splitting...

This is my attempt, it works on a 24 hour widow and im sure theres a better way of doing it

CREATE TABLE #Hist

(

CallDateTime DateTime

,HistId int

)

Insert into #Hist

VALUES ('2013-02-01 06:14:41.000',2671058)

,('2013-02-01 07:02:15.000',...

Can you post the code in the SP, as that might help us see what's going on.

I take it you've don't a count on the source table and that matches...

Scott,

I would disagree with you on the under no circumstances comment, for a couple of reasons

1) the risk of fragmentation is significant on the clustered index, especially if it...

Andy Hyslop (2/18/2013)

Bhuvnesh (2/18/2013)

Andy Hyslop (2/15/2013)

Does it cost...

The problem is that there is a tipping point where SQL can get into a twist, sometimes this can be a few 100,000 rows difference.

does your service account have...

Thanks for the reply,

Its good to see you do a targeted rebuild, I would imaging its indexes over 30/40% that get rebuilt and anything under that re-organised. I'm...