you need to use a table of dates (possibly a recursive CTE) and figure out how to put  the last working day's value in to the table.

I think you might...

This sounds like a good use for rownumber() over (partition by … order by …)

partition by the date - not sure how you would go about it. - but scdecade...

it sounds like either your apps are not closing connections, or that you are not using connection pooling correctly

if you have 100% of your cpu trying to manage context switching...

grant has hit the magic words - data movement

write once , read many - don't keep writing...

What did you want folks to use HierarchyID and...

Jeff , you are anything but brief. keep it up

and I have a migraine from trying to figure out that last message - yay, I get a day off -...

this is just an opinion.. I have a few servers that have tempdb that "misbehaves".

this is normally transactions that don't commit - or an index operation at the weekend

best practice...

all the guys are right on this. if you perform a function on every row in a where clause you will die very quickly - you can't use a function...

Just remember NULL does not evaluate - but try and avoid doing ISNULL(myfield,'')

you end up checking for blank spaces and NULL everywhere.

I've found that default values can help SQL a...

In management studio you have a number of reports that can show you this

I like the performance dashboard

look out for the buffer cache hit ratio - 100% is good, another...

I took a week off - everything broke, they didn't know I was cleaning up "developer...

Blimey Jeff, you seem quite agitated on this one 🙂 good to see some passion

At my company we have a monthly team meeting (about 30 of us) where we do...

so either sp_addsubsciption hasn't run (I seriously doubt that)

This sounds like a permission issue, but i'm struggling with your English a little

first steps, can you put a tracer token through?...

I think of it more like "stranger things" , but I still get  visions of aliens bursting out...

If it's a SAN then you might have the same problem that we had with Amazon

depends on your configuration

our connectivity was shared over a network connection which was also shared...