What do you mean you'll be having millions of records?  There are only three rows in your required result set.  Please show us your xml_path query, and explain in more...

If you use the STUFF function to insert a colon between the hours and minutes and minutes and seconds, you should then be able to convert to datetime.  If that...

Does the one that fails involve a linked server or an OPENROWSET command or something like that?

John

An interesting problem.  I've seen this before, where the same user is a member of more than one group.  I can't remember what the answer is, though!  Does it:
(1)...

Beatrix is right - this could affect your differential backups.  But it won't break your log backup chain.  Now you've come through this unscathed, this would be a good opportunity...

If you're comfortable with the fact that if the subquery runs first and then releases its lock then its results may have changed by the time the main query has...

Why not just have one AD group for each required permission set?  You might find that you have some groups that contain only one member, but that doesn't matter -...

Something like this:
SELECT
     OrderNo
,    Item
,    OrderQty
,    x.OnHand - SUM(OrderQty) OVER (PARTITION BY Item ORDER BY OrderNo ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS OnHand

...
WHERE ID = 1234
AND Title = 'Developer'
...

John

Ignacio

Do you have sp_whoisactive on your server?  You can use it to see current activity all at once, without having to query several DMVs.

John

Yes - same issue.  You're crossing two month boundaries: March/April and April/May.  You probably need extra logic in your function to check whether the date part is less for the...

You haven't provided an example of a pair of dates for which the function doesn't work, so I'll guess what the problem is.  The way DATEDIFF works is by counting...

I think you can run it on an evaluation licence for six months.  After that, you have to either pay for it or stop using it.  That was the case...

Yes, you need to back up the transaction log if your database is in Full recovery mode, and not just once a day.  The full backup doesn't back up the...