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, 9 months
  • Last seen this week
22 votes
4 answers
32k views

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

12 votes
6 answers
9k views

How to deny access to SQL Server to certain login over SSMS, but allow over .Net SqlClient Data Provider

8 votes
1 answer
535 views

Database Cache Memory in Performance Monitor drops down significantly after DBCC CheckDB

7 votes
2 answers
4k views

How SQL Server caches data in memory

7 votes
1 answer
4k views

What is the proper event in Extended Events to track stored procedure executions?

7 votes
1 answer
2k views

How to avoid Table Lock Escalation?

7 votes
1 answer
3k views

Memory Requirements for SQL Server

6 votes
1 answer
6k views

SQL Server - What is the difference between BULKADMIN and ADMINISTER BULK OPERATIONS

5 votes
3 answers
931 views

SQL Server Logon Trigger Implications - are there any side effects possible in my scenario?

5 votes
3 answers
1k views

Query runs indefinitely - what is the root cause ? (not asking how to fix)

5 votes
1 answer
2k views

Is there any way to have Unique Constraint and NOT have Unique Index?

4 votes
3 answers
15k views

Grant permission to KILL connections (sessions) for certain databases only?

4 votes
1 answer
14k views

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

4 votes
1 answer
775 views

ALTER INDEX REORGANIZE questions

4 votes
1 answer
5k views

Azure SQL Server outdated version - how can I upgrade it to current version?

3 votes
2 answers
2k views

Storage space used for NULL values

3 votes
2 answers
692 views

How can Temp Table creation time be reduced in terms of CPU time?

3 votes
1 answer
892 views

SQL Server High CPU usage and RESOURCE_SEMAPHORE waits

3 votes
1 answer
651 views

Delayed or Asynchronous DML Trigger Execution

3 votes
1 answer
884 views

Availability Group Read Only Routing Not Working for SQL Logins

3 votes
2 answers
1k views

How to Limit DTU Percentage Consumption for a Given Session in Azure SQL Database?

3 votes
3 answers
7k views

Query system specs (cpu, memory, data disks, free space) using T-SQL

3 votes
1 answer
443 views

Performance problems in SQL Server. Parameter Sniffing or not in my scenario?

2 votes
3 answers
7k views

How to Audit Successful Logins for certain logins only?

2 votes
1 answer
891 views

Migrating Production SQL Servers (Availability Group) from one data center to another - questions

2 votes
1 answer
2k views

Azure SQL Databases: High number of SA connections with "BRKR TASK" and "TASK MANAGER" commands

2 votes
1 answer
372 views

How to point Azure Hybrid Connection to Availability Group Listener ? Or redirect to secondary replica?

2 votes
0 answers
61 views

Logging multiple error message in the TRY...CATCH when doing BACKUP DATABASE [duplicate]

2 votes
2 answers
942 views

Availability Group of SQL Servers 2012, 2012 and 2016 possible?

2 votes
2 answers
1k views

Insert 2 output result sets from sp_spaceused into Temp Table (SQL Server non-2016)