Please ignore this. I have just noticed that some of the production servers still have a GDR dated January and some have a GDR dated July.

I think Windows Update must...

One qustion: whats the purpose of

THEN DATEADD(minute, DATEDIFF(minute, '2020', T.StartDateTime), '2020')
ELSE DATEADD(minute, DATEDIFF(minute, '2020', T.EndDateTime), '2020')

instead of

THEN T.StartDateTime
ELSE T.EndDateTime

Looks like it produces the...

Try something like:

WITH InOuts
AS
(
    SELECT T.GroupingId, X.InOut
        ,CASE
         ...

• This reply was modified 1 year, 1 month ago by  Ken McKelvey.
• This reply was modified 1 year, 1 month ago by  Ken McKelvey.
• This reply was modified 1 year, 1 month ago by  Ken McKelvey.

What I remember from testing a few years ago:

1. A backup will not work with an expired certificate.
2. A restore will work with an expired certificate.

ie You should should leave...

This may...

Thanks for the information. Our oldest backups are...

You can restore a SQL2000 backup into SQL2008. An evaluation version of SQL2008 is available here:

Download Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals from Official...

SQL Server Data Types - Decimal, Numeric, Bit, Money, Date, Int (mssqltips.com)

Anyone got any ideas how I can get around this limitation.

You can use the CLR. The paid version of the following has File_GetDirectoryListing .

SQL# (SQLsharp) - Expanding the capabilities...

• This reply was modified 1 year, 2 months ago by  Ken McKelvey.
• This reply was modified 2 months, 3 weeks ago by  Ken McKelvey.

There is probably a better method:

SELECT J.spotterId, FD.indexKey, FD.frequency, FD.df, FD.varianceDensity, FD.direction, FD.directionalSpread
FROM OPENJSON (@JSON, '$.data')
WITH (
    spotterId nvarchar(25)
    ,frequencyData nvarchar(max)...

• This reply was modified 1 year, 2 months ago by  Ken McKelvey.
• This reply was modified 1 year, 2 months ago by  Ken McKelvey.

post to get over display bug

The following comment from https://techcommunity.microsoft.com/t5/sql-server-blog/update-hotfixes-released-for-odbc-and-ole-db-drivers-for-sql/ba-p/3848484 might help.

DavidEngelMS

Microsoft

‎Aug 10 2023 04:58 PM

@james Auman

 

This answer has some subtleties, so bear with me.

...

There is an additional scenario I'd like to describe for...

I use the following to determine if log backups are worth it on instances with sporadically used DBs. Full and differential backups always get done on the schedule. This works...

Try the basics for any version of SQL Server first and play with the cost threshold for parallelism and max degree of parallelism.

For an Online Transaction System, I would start...

This might also be worth looking at:

https://blog.sqlauthority.com/2019/09/16/sql-server-enable-lock-pages-in-memory-lpim/