I never had any exposure to SQL Server 2000, but my Google-Fu tells me you'll need to use DBCC SHOWCONTIG (see SQL SERVER – Comparison Index Fragmentation, Index...

Ooof on the Compatibility 80 level. SQL Server 2008 ran out of support back in 2019, so you really want to get that instance upgraded, but if you're still running...

Yes i had to do it that way then vendor wants the dates in a specific format and that was the only way I knew how to achive that......

• This reply was modified 1 year, 8 months ago by  Thom A.

[TermDate] = CASE WHEN FORMAT(Termdate, 'MM/dd/yyyy hh:mm:ss') > FORMAT(HireDate, 'MM/dd/yyyy hh:mm:ss')
                ...

You've posted in the SQL Server 2022 forum, so we've been running under the (incorrect) knowledge that...

There are localization differences for the default code page when doing certain type conversions. I was wondered if collation is where that came from when a string is implicitly...

The collation, no,...

The fields listed in the SELECT clause are a subset of the fields in the GROUP BY clause.  What you said about DISTINCT is only necessarily true if the...

Why are you using DISTINCT and GROUP BY in your first query out of interest? GROUP BY already puts your data into distinct groups, so the DISTINCT in the SELECT...

select  @v=activityname from activity order by activityid

That will assign every value of activityname to the variable @v, but as the variable is a scalar value, it...

One of my biggest pet peeves about (small)datetime is its handling of the format yyyy-MM-dd( hh:mm:ss) as it is ambiguous. For those using American as their language they are "fine",...

The method you have used in...

That (now removed) ChatGPT "solution" was amazing garbage...

If you're on 2022 then you could use DATE_BUCKET:

WHERE YourDateTimeColumn >= DATE_BUCKET(DAY,1, GETDATE(), CONVERT(datetime,'19000101 16:00:00'))
  AND YourDateTimeColumn < DATEADD(DAY, 1, DATE_BUCKET(DAY,1, GETDATE(), CONVERT(datetime,'19000101 16:00:00')))

Another method would...

This is literally just a "has anyone else had this thought?" question but I was wondering about "catch-all"/"kitchen-sink" queries at the weekend, and new features of Query Store with the...

• This reply was modified 1 year, 8 months ago by  Thom A.