Movatterモバイル変換

Question 1

0votes

0answers

32views

Service Broker Messages Sent Directly To Target Queue

I am trying to set up queues within the same database (on the same server instance). I would like a ProcessStart queue and a ProcessEnd queue. The ProcessStart queue will receive messages with a set ...

squillman

1,227

askedNov 19 at 21:43

Question 2

2votes

1answer

377views

Do canary tables make sense for Availability Groups?

For all HA or DR solutions in SQL Server, I have heard that it is smart to have a table with a timestamp column in each database and to have an Agent Job run every minute to update that timestamp with ...

J. Mini

1,360

askedNov 15 at 17:54

Question 3

4votes

1answer

135views

How can I tell which tables, indexes, or pages do not have checksums?

This time last year, I set the page_verify database option to checksum on a very old and very large database. We do weekly index maintenance, so I hope that most of the database's pages have been ...

J. Mini

1,360

askedNov 9 at 17:27

Question 4

3votes

1answer

78views

What is the maintenance on the index caused by insert, update, or delete operations?

Follow up question for this answer regarding the excerpt of the sys.dm_db_index_usage_stats doc:The user_updates column is a counter of maintenance on the indexcaused by insert, update, or delete ...

Ronaldo

6,511

askedNov 5 at 16:02

Question 5

4votes

2answers

373views

@@SERVERNAME Consistency in 3 node SQL Availability Group

We have a 3 node availability group running on SQL 2022.The application which has its databases hosted on the AG queries @@SERVERNAME as part of licensing checks. If @@SERVERNAME doesn't match what ...

Kirky

347

askedNov 3 at 14:19

Question 6

0votes

0answers

34views

Retrospectively applying data retention to temporal tables

I've been asked to look at trimming the amount of change information that we're currently storing in a temporal table. The background to this is:When the organisation that I work for initially ...

Ian Henderson

101

askedOct 28 at 13:27

Question 7

4votes

2answers

574views

Performance tanks after small change in search date predicate

Can anyone help me understand what's happening here....I'm trying to get consistent performance from a query being called from a third-party application. Changing the query itself isn't an option. ...

FrugalShaun

491

askedOct 21 at 16:39

Question 8

-1votes

1answer

57views

After a failover to a DR region, the becomes "reverting/in Recovery" in the primary node

we have a 10+TB database. Whenever we failover it, the databases becomes with a session running a null command, with a HADR_DB_COMMAND wait_type.I believe this is related to a rollback or something? ...

Racer SQL

7,558

askedOct 20 at 16:07

Question 9

1vote

1answer

138views

What does trace flag 11024 do?

ContextI have been experimenting with incremental statistics a lot. I do not know of any online resource about them that I have not read. Despite all of this, I just don't understand what trace flag ...

J. Mini

1,360

askedOct 19 at 17:03

Question 10

1vote

0answers

83views

Under what circumstances will a memory optimized table variable with a hash index outperform other temporary tabular structures?

ContextAside from victims of latch contention, everybody gave up on memory-optimized table variables pretty quickly. Probably around the time they realised that they still don't have statistics. Yet, ...

J. Mini

1,360

askedOct 17 at 20:38

Question 11

2votes

1answer

87views

Upgrading SQL Server 2008 SP3 to SQL Server 2022 Best Upgrade Path and Licensing Questions

I have a requirement to upgrade several SQL Server 2008 SP3 databases to a new environment on new servers running SQL Server 2022. As per Microsoft’s documentation, SQL Server 2008 cannot be upgraded ...

Sachintha Nanayakkara

31

askedOct 17 at 10:13

Question 12

0votes

0answers

84views

Temp Table Management in Explicit Transactions and CATCH blocks

Example code below populates a PhoneNumber table and associates those PhoneNumberId's with an OrderNumber.As written I am getting the error message:The current transaction cannot be committed and ...

Kirk Saunders

1,096

askedOct 16 at 13:34

Question 13

0votes

1answer

119views

How does a join without any predicates estimate fewer rows than what go into it?

Consider the following script on the 10 GB StackOverflow2010 database. Be warned that it clears the plan cache.IF NOT EXISTS (SELECT * FROM sys.types WHERE is_table_type = 1 AND name = 'ExampleTvp')...

J. Mini

1,360

askedOct 15 at 20:52

Question 14

7votes

2answers

228views

STRING_SPLIT - issue with NCHAR(769) and SQL_Latin1_General_CP1_CI_AS

In databaseon SQL Server 2022 Standard Edition (CU19)with default collation SQL_Latin1_General_CP1_CI_ASI am splitting CHAR(31) separated values using STRING_SPLIT. I have an issue when the ...

gotqn

4,410

askedOct 14 at 6:49

Question 15

0votes

0answers

38views

Replication vs new database to stock user custom object

I have server1\database1 (production) being replicated to server2\database1 (reporting) running on SQL Server 2016. In both databases, there are objects (table, sp, function, ...) created by the user. ...

Veronique

26

askedOct 11 at 10:45

Movatterモバイル変換

Stack Exchange Network

Questions tagged [sql-server-2022]

Service Broker Messages Sent Directly To Target Queue

Do canary tables make sense for Availability Groups?

How can I tell which tables, indexes, or pages do not have checksums?

What is the maintenance on the index caused by insert, update, or delete operations?

@@SERVERNAME Consistency in 3 node SQL Availability Group

Retrospectively applying data retention to temporal tables

Performance tanks after small change in search date predicate

After a failover to a DR region, the becomes "reverting/in Recovery" in the primary node

What does trace flag 11024 do?

Under what circumstances will a memory optimized table variable with a hash index outperform other temporary tabular structures?

Upgrading SQL Server 2008 SP3 to SQL Server 2022 Best Upgrade Path and Licensing Questions

Temp Table Management in Explicit Transactions and CATCH blocks

How does a join without any predicates estimate fewer rows than what go into it?

STRING_SPLIT - issue with NCHAR(769) and SQL_Latin1_General_CP1_CI_AS

Replication vs new database to stock user custom object

Hot Network Questions

Subscribe to RSS