Skip to main content
Aleksey Vitsko's user avatar
Aleksey Vitsko's user avatar
Aleksey Vitsko's user avatar
Aleksey Vitsko
  • Member for 6 years, 10 months
  • Last seen this week
19 votes
Accepted

Truncate a table with 17 billion rows in an AG

12 votes

Copying a table (and all of its data) from one server to another?

10 votes

SQL Server - Is my database being queried over linked server?

10 votes
Accepted

Availability Group - how much data was lost after forced failover

9 votes

SQL Server has encountered occurences of I/O requests taking longer than 15 seconds

8 votes
Accepted

Are duplicated NVARCHAR values stored as copies in SQL Server?

8 votes
Accepted

How to resume Azure serverless SQL Server from pause

6 votes

Is it a good idea to Partition a table (in MS SQL) based on date, when there's a clustered index present on ID (INT)

6 votes
Accepted

How to know real SQL Server memory and CPU usage

6 votes
Accepted

How do I prevent my Windows Server from being automatically rebooted by SQL Server updates?

6 votes
Accepted

SQL Server - creating a clustered index in a large heap - should I add a column?

5 votes
Accepted

Error installing SQL Server Database Engine Services Instance Features - The User Log directory in the registry is not valid

5 votes

Windows Logs Application is full of "Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ****]"

5 votes
Accepted

How can I restrict access to HR data in SQL Server?

4 votes

MS SQL Server DB Transaction Log Growth Rate

4 votes
Accepted

How to prevent primary node's SQL jobs from running when the primary node goes into resolving state?

4 votes

Identifying the reason of the CPU pressure

4 votes
Accepted

how to add data compression to a primary key of a table?

4 votes

Increased memory to server, but do I need to change page-file size?

4 votes

How to prevent a full database backup

4 votes
Accepted

Script to monitor database growth on daily basis

4 votes

Why and how and where to use user without login

3 votes
Accepted

SQL Server - Unique Constraint Syntax

3 votes

RCSI & ETL processing compatibility

3 votes

Running out of disk space, start saving new data to different disk

3 votes
Accepted

SQL Server setting up logins for backup site

3 votes
Accepted

How to get certificate expiration date for certificate in mirroring endpoint in SQL Server 2016 Always On Availability Group?

3 votes
Accepted

SQL Server indexes and record deletion

3 votes

SQL Server Agent Jobs and Availability Groups

3 votes

What factors do we need to consider in order to enable auto-growth settings for my PROD database

1
2 3 4 5