I would use datalength(v.String) so the training space at the end shows up too, so nobody checking your script actually has to doublecheck the behavior of trailing spaces.

( btw: this...

• This reply was modified 2 years, 7 months ago by Johan Bijnens.

did you check this article "SQL Server Performance Counter are Missing"

Did you try this ?

Declare   @tb table ( varcharcol varchar(10) not null )

insert into @tb 
values ( '23:01'),( '00:01'),( '00:02'),( '00:03'),( '22:00')

;with cteTimes as (
Select...

Looking at the provided data, someone had to produce XML, but missed the moint of it

<GrpID>Group ID: 14080.</GrpID>

should in fact be <GrpID>14080</GrpID> ( unless the "." has an actual significance,...

As you noticed, something went wrong somewhere in 2011.

Did someone forget to:

• automate for new partitions?
• removal of old data?

Anyway, Whenever I implement a partitioned table, I implement boundary constraints,...

I haven't encountered a developer yet, who wrote such a query himself, without using the "query designer".

I've seen some cases where it actually provided a performance advantage, however, I plead...

If only it would work.

It always generates this error  

did you also try using double quotes ? "," ( it's command line, not tsql)

This is the link holding the part that causes your confusion:

Performance improvements in tempdb for SQL Server

check the "mode" parameter of the sys.dm_db_physical_stats function

As this is the only clustered instance which produces these warnings and errors, we suspect SentinelOne - which we are testing on one of the nodes.

We moved the instance to...

Please do keep in mind, if in case of major DRP, starting from scratch, you could end up with a partially working engine if you just install the latest version...

Using Set HADR OFF you're telling the engine to forget the whole content of the replica !

January 27, 2023 at 1:44 pm

#4142412

did you try granting the account "view definition" on these specific databases ?

Using "any database" should indeed cover it all, but ...

use [yourdb]

create user ...

GRANT view definition...

tempdb version store is always used whenever snapshot isolation is used with any query or database !