Recreating such a thing in yet another "string format" would go against my grain.  Why not convert it to a proper DATE or DATETIME datatype?

If you have the enterprise edition, you could use the Resource Governor.  I've not done a deep read on the trigger you wrote but that would also work.

You should give...

dear all,

i have simple query that related several tables which 1 table have millions of rows. i have created index on each table that i will relate to master...

Is it a leading space or a leading TAB character?

Joe, if the indexing is setup correctly, wrapping the ENDDATE in a COALESCE can cause a range scan (at best) instead of a SEEK because it makes that part of...

Ah... gotcha... I missed that he reposted.  Thank you.  I'll take a look at this after work...

I think the record layout is correct - its just that column "provider name" should be further divided into LastName, FirstName, Middle Initial (probably)

if object_id('tempdb..#data') is...

Ok... again, there's something wrong with the sample data you provided.  Here's the data using the fixed width font of...

My only trouble is that management feels compelled to force engagement between people with virtual lunches, virtual happy hours, group puzzle solving, sharing workspace pictures, sharing pictures of what you...

To be sure, I was just kidding about Redgate.  It was pretty obvious which company you were talking about.  As for Grant... Kind of like real brothers (we both survived...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1...

I have to agree with Frederico... 5GB is very small and not worth the...

Try normalize the Employee table, to move out rows that may me NULL. Good normalization also gives more understanding of the model. Sometimes NULL, may be acceptable, e.x. a...

@jeff-moden, Yes, I agree with you that the steps I'm trying to get through Power Query can also be done with T-SQL. The main purpose of this article was...

I'm curious as to why any row in an Employee table would ever have a NULL (or a -1 alternative or an "empty" alternative) for the Employee number for...