Lynn

I was thinking that if you show them that if you contribute to the community then you get the Rockstar job. lord alone, look at Grant, he gets flown around...

it would be nice to get a thankyou occasionally though. 🙂  I think off the top of my head I see about 10 users who do most of the "heavy...

Position a Column in an Index.

are you talking about choosing the order of columns in an index?

Just to be a contrarian, I'm...

Grant is correct, if you put your database into 3rd normal form you will have to join. In my honest opinion getting 3nf is the most important part of getting...

we have a little app server and use a service account for monitoring - that should fix your issue

https://www.mssqltips.com/sqlservertip/3076/how-to-read-the-sql-server-database-transaction-log/

that might help

that's what fredeico's code does

he uses convert (date) to force it back to midnight

if it's that small a recordset and you aren't using procs, then i'm guessing it's an access client? - if it is then I think I might know the issue

On the subject of questions getting worse, here's what it has finally come to.  Notice in the zip file that there is absolutely everything that one might need to...

We had a person at my old job.  She was ALWAYS on the phone.  I got curious as to why and so I discreetly "hung around" for...

We had a person at my old job.  She was ALWAYS on the phone.  I got curious as to why and so I discreetly "hung around" for...

p.s.  I've also adopted the policy of NVO (No Verbal Orders), especially for "urgencies".  It there's not a well documented ticket to support the urgency,...

The scripts are better in...

So, for actively running queries, I recommend the DMVs, sys.dm_exec_requests is a good starting point. You can join that to other DMVs to get the execution plan, the SQL...