All Questions
Tagged with sql-server sql-server-2019
852
questions
1
vote
1
answer
32
views
Does enabling backup compression in a Back Up Database Task enable checksums, no matter what setting you pick for them?
Observations
The documentation says
To enable backup checksums in a BACKUP (Transact-SQL) statement, specify the WITH CHECKSUM option. To disable backup checksums, specify the WITH NO_CHECKSUM option....
- 545
0
votes
1
answer
28
views
Is DBCC CHECKFILEGROUP worthless if you already run DBCC CHECKDB on all databases?
DBCC CHECKDB makes many other integrity checks redundant, but I can't see anything in the documentation saying if it makes DBCC CHECKFILEGROUP redundant. Is DBCC CHECKFILEGROUP worthless if you ...
- 545
-2
votes
0
answers
72
views
Why would email alerts on severity 16 errors be desirable? [closed]
Errors for severities beyond 16 are standard. Such errors are signs of really serious problems. I've noticed that this script here includes alerts for severity 16. To my knowledge, severity 16 errors ...
- 545
2
votes
3
answers
564
views
Are unique filtered indexes considered an antipattern for enforcing constraints?
I have a table, such as the following. Let's called it Fools.
FoolID
FoolValue
IsActiveFoolValue
1
Ultra Foolish
0
1
Super Foolish
1
2
Quite Foolish
1
A business rule is that for each FoolID, we ...
- 545
0
votes
1
answer
87
views
Does SQL Server application database and tempdb collation mismatch affect performance
I installed the SQL Server 2019 instance for our ERP with the default French_CI_AS collation.
The ERP uses Latin1_general_BIN and doesn't seem to have any problems. I only realised the potential issue ...
- 353
4
votes
2
answers
426
views
Best Way to Determine if a Table has a Long Running Transaction
I need to be able to iterate all tables and issue a TRUNCATE command, however, I don't want the loop to be held up by blocking. Essentially, I am looking for the best way to determine if a SCH-M lock ...
- 567
4
votes
1
answer
141
views
MSG 14262: The specified @server_name ('<server_name>') does not exist
We have an SQL Server 2019 instance (let's call it 'sample_instance') with server collation of Turkish_CI_AS. When I try to create a job, SSMS creates the part of the script that adds the target ...
- 87
0
votes
0
answers
55
views
Can we store always encrypted column into temp table in Azure SQL Database?
I have encrypted a column in Azure SQL Database and now when a proc which has used temp table and being used to UPDATE/INSERT data into always encrypted table. The exception detail is
Msg 33293 Level ...
- 141
0
votes
1
answer
42
views
import extended properties of sql server database from xls file
I have a list of extended properties for all databases in an excel file. How can I import that into extended properties of each database in sql server.
- 1
4
votes
1
answer
109
views
Backups/CHECKDB errors - "Cannot find server certificate"
I have been exchanging TDE certificates on various servers to make restores easier - some had the wrong name, the wrong thumbprint, or even both. This involves transferring databases to a temporary ...
4
votes
1
answer
112
views
Why does adding an empty columnstore index to my tables consistently make execution plans ignore bitmaps?
Problem
I am using a Standard Edition SQL Server 2019 box. Given the edition, compatibility levels should not be relevant (the level-dependent batch mode features are disallowed on Standard). On this ...
- 545
-3
votes
0
answers
99
views
Are columnstore indexes worse than rowstore indexes when equi-joining two large tables?
Columnstore indexes are amazing for equi-joining large fact tables to small dimension tables. They were designed for this and can do truly wonderful hash joins. However, hash joins become less ...
- 545
0
votes
2
answers
38
views
When would a columnstore index be unsuitable for an OLAP environment with large and wide tables?
Suppose that your SQL Server 2019 machine has a query that hits a disk-based table that is both long (let's say 3,000,000 rows) and wide (let's say 150 columns). Suppose that you retrieve most of the ...
- 545
-1
votes
3
answers
146
views
Does it make sense to Full Back up weekly or Back up Transaction Log every 15 min?
I have to make a decision (at work) to choose which option is more feasible using SQL Server 2019:
Option 1: Full backups sent once per week and differential backups sent between weekly backups.
...
- 233
3
votes
1
answer
293
views
Is sys.dm_os_memory_clerks a good source to use when setting max server memory (MB)?
According to sys.dm_os_memory_clerks, the total RAM usage of my server was 30 GB. Using this information, I set max server memory (MB) to 31,000. I was shocked to then see sys.dm_os_memory_clerks ...
- 545