Topics
Started by
Posts
Last post
Hi All, We have a big database ~5TB. We update the stats with full scan weekly once. It runs more t…
9 replies
Hi All, Want to know what are the practical implication we might run into when we have NOLOCK hints…
7 replies
Hi All, Today, we came across a blocking scenario. A stored proc is running fine if it is executed …
3 replies
Hi All, How to size the tempdb drives? Currently tempdata drive is 2TB and but now a days its getti…
4 replies
Hi All, One of the SELECT query is taking a long time to execute. Its is a view and it is calling a…
5 replies
Yesterday I was working on some T-SQL code to create an AG and add databases to the AG. My scripts …
4 replies
I'm very new to this stuff and have been tasked with doing something out of my skill set currently,…
3 replies
Hi All. I am seeing a scenario where SELECT is blocking a TRUNCATE statement in one of our prod env…
14 replies
Good afternoon! Is there any type of documentation or process for failing over a CMS server? Do I h…
3 replies
Hi All, Need some help in tune a function which is reading TB's of data and because of which tempdb…
23 replies
Hi All, As part of security compliance, we are told to audit DML & DDL operations on a 4TB data…
2 replies
Hi Everyone, Why and when should be set 'cost threshold for parallelism'? We are on SQL 2017 Enterp…
5 replies
We have about 20 SQL Servers. We use Net backup or Native backup for SQL Server database backups. W…
2 replies
I have one SQL Database server which is old version and planning to migrate to SQL2017. We have abo…
6 replies
How to enable dynamic data masking for blob data?
7 replies
Viewing 15 topics - 91 through 105 (of 1,641 total)
You must be logged in to create new topics.