User Fajela Tajkiya

16 votes

3 answers

2k views

What's the use case of disabling an index?

asked Sep 25, 2022 at 16:26

7 votes

3 answers

734 views

How does this piece of TSQL work?

asked Sep 29, 2022 at 13:03

7 votes

1 answer

712 views

How does SQL Server update lock work?

asked Sep 22, 2022 at 14:15

6 votes

1 answer

693 views

How does SQL Server update indexed views?

asked Feb 13 at 22:16

5 votes

2 answers

960 views

Understanding of SQL Server version store

asked Aug 21, 2022 at 13:04

5 votes

1 answer

278 views

What's the difference between these three versions of TSQL snippet?

asked Sep 3, 2022 at 8:36

4 votes

1 answer

274 views

Is this valid SQL Server Update syntax?

asked Oct 1, 2022 at 11:33

4 votes

1 answer

238 views

How can I switch to the right or left editor tab in SSMS using a shortcut?

asked Feb 12 at 8:38

2 votes

1 answer

104 views

Can I join multiple nodes to a SQL Server failover cluster simultaneously?

asked Mar 7 at 18:17

2 votes

2 answers

379 views

Which SQL Server Manager should I use: C:\Windows\System32 or C:\Windows\SysWOW64?

asked Mar 21 at 5:22

2 votes

1 answer

161 views

Should the quorum drive always be at the same node with the SQL Server role in a SQL Server failover cluster environment?

asked Nov 20, 2022 at 17:14

2 votes

1 answer

57 views

Why does SQL Server use two different data types for LSN?

asked May 5 at 17:18

1 vote

0 answers

54 views

Rewriting a DELETE statement to reduce pagelatch_ex waits

asked May 12 at 20:13

1 vote

2 answers

68 views

Is it possible to save the statistics profile result into a table?

asked Apr 29 at 15:15

1 vote

1 answer

254 views

Understanding of database master key in SQL Server

asked Sep 28, 2022 at 16:06

1 vote

2 answers

74 views

How does SQL Server handle data during backup operations?

asked Jan 29 at 9:22

1 vote

1 answer

71 views

Can I access a database while TDE is being enabled?

asked Jan 10 at 15:54

1 vote

1 answer

110 views

What events should I use in an Extended Event session in order to capture all executed SQL?

asked Jan 14 at 4:31

0 votes

1 answer

42 views

Managing disk space on a SQL Server database server with limited storage

asked Jan 22 at 8:21

0 votes

0 answers

26 views

Checking Scale Out Deployment of SSRS using PowerShell

asked Jan 25 at 10:53

0 votes

1 answer

45 views

Getting data file and log file free space size during database restoring

asked Feb 9 at 10:52

0 votes

1 answer

101 views

Using GPT partition type with SQL Server in production?

asked Feb 16 at 1:53

0 votes

0 answers

63 views

How does shrinking of tempdb log file work?

asked Apr 7 at 14:52

0 votes

1 answer

74 views

How to correctly set max_file_size for a file target of an extended event session?

asked Apr 23 at 14:34

0 votes

1 answer

44 views

Which SQL Server database settings fall under ALTER DATABASE SCOPED CONFIGURATION vs ALTER DATABASE SET syntax?

asked Apr 28 at 8:04

0 votes

1 answer

82 views

How to Check if SQL Server is Running Out of Memory or CPU Resources RIGHT NOW?

asked Apr 28 at 11:09

0 votes

1 answer

186 views

What is login token and user token in SQL Server?

asked Nov 24, 2022 at 17:48

0 votes

0 answers

33 views

Is it possible to download SQL Server 2022 documentation in HTML format?

asked Nov 26, 2022 at 18:32

0 votes

1 answer

39 views

If a table column corresponding to different target columns in different tables, how to join this column in SQL?

asked Oct 2, 2022 at 11:46

0 votes

1 answer

145 views

How to get the masked user created object id in the master database?

asked Oct 3, 2022 at 9:08

Stack Exchange Network

45 Questions

What's the use case of disabling an index?

How does this piece of TSQL work?

How does SQL Server update lock work?

How does SQL Server update indexed views?

Understanding of SQL Server version store

What's the difference between these three versions of TSQL snippet?

Is this valid SQL Server Update syntax?

How can I switch to the right or left editor tab in SSMS using a shortcut?

Can I join multiple nodes to a SQL Server failover cluster simultaneously?

Which SQL Server Manager should I use: C:\Windows\System32 or C:\Windows\SysWOW64?

Should the quorum drive always be at the same node with the SQL Server role in a SQL Server failover cluster environment?

Why does SQL Server use two different data types for LSN?

Rewriting a DELETE statement to reduce pagelatch_ex waits

Is it possible to save the statistics profile result into a table?

Understanding of database master key in SQL Server

How does SQL Server handle data during backup operations?

Can I access a database while TDE is being enabled?

What events should I use in an Extended Event session in order to capture all executed SQL?

Managing disk space on a SQL Server database server with limited storage

Checking Scale Out Deployment of SSRS using PowerShell

Getting data file and log file free space size during database restoring

Using GPT partition type with SQL Server in production?

How does shrinking of tempdb log file work?

How to correctly set max_file_size for a file target of an extended event session?

Which SQL Server database settings fall under ALTER DATABASE SCOPED CONFIGURATION vs ALTER DATABASE SET syntax?

How to Check if SQL Server is Running Out of Memory or CPU Resources RIGHT NOW?

What is login token and user token in SQL Server?

Is it possible to download SQL Server 2022 documentation in HTML format?

If a table column corresponding to different target columns in different tables, how to join this column in SQL?

How to get the masked user created object id in the master database?