User gotqn

29 votes

1 answer

18k views

Why 0 is equal to empty string?

asked May 19, 2015 at 11:56

18 votes

3 answers

87k views

Shrink Transaction Log While Using AlwaysOn Availability Group

asked Aug 13, 2014 at 6:04

16 votes

1 answer

28k views

How to use COLUMNS_UPDATED to check if any of certain columns are updated?

asked Mar 17, 2016 at 16:03

15 votes

2 answers

15k views

Alternative way to compress NVARCHAR(MAX)?

asked Oct 3, 2014 at 14:32

15 votes

4 answers

91k views

How to get CPU usage by database for particular instance?

asked Nov 19, 2014 at 13:08

12 votes

2 answers

20k views

Storing IP addresses - varchar(45) vs varbinary(16)

asked Mar 30, 2015 at 20:35

12 votes

2 answers

3k views

When `nvarchar/nchar` is going to be used with SQL Server 2019?

asked Sep 25, 2018 at 6:52

11 votes

2 answers

39k views

Restoring encrypted database on another server (using Backup Encryption)

asked Sep 15, 2016 at 13:01

10 votes

2 answers

511 views

Are "out of the row" fields read when a clustered index is used?

asked Jan 2, 2015 at 14:31

9 votes

4 answers

13k views

ADD PERIOD FOR SYSTEM_TIME on table failed

asked Mar 13, 2018 at 10:05

8 votes

1 answer

1k views

How to name table-variable function unique constraint?

asked Dec 7, 2015 at 13:56

8 votes

1 answer

1k views

.WRITE clause performance optimization

asked Oct 10, 2014 at 11:45

7 votes

4 answers

4k views

How to optimize STDistance execution?

asked Apr 16, 2015 at 14:23

6 votes

1 answer

6k views

Is there a way to minimally log insert under Always on?

asked Nov 11, 2014 at 12:32

6 votes

1 answer

3k views

GZipStream/DeflateStream compressions alternatives

asked Jan 15, 2015 at 12:20

6 votes

1 answer

548 views

How can "HierarchyID" type work when "CLR" is disabled?

asked Sep 25, 2014 at 10:44

6 votes

1 answer

3k views

Are there any reasons to avoid using sp_rename for renaming objects?

asked Oct 21, 2015 at 5:57

6 votes

1 answer

169 views

Read-ahead reads and SQL-Variant fields

asked Nov 14, 2016 at 12:13

5 votes

3 answers

5k views

Query Spatial Data for Nearest Neighbor for each group

asked Jun 14, 2016 at 8:01

5 votes

2 answers

10k views

Change Data Capture vs trigger for logging changes

asked Dec 12, 2016 at 13:04

5 votes

1 answer

520 views

Is it possible to create encrypted backups using encrypted by password certificate?

asked Oct 18, 2017 at 13:18

5 votes

4 answers

5k views

T-SQL INNER JOIN Optimisation

asked Jan 26, 2012 at 13:36

5 votes

2 answers

547 views

SQL Server 2019 column store indexes - maintenance

asked Jan 9, 2021 at 11:30

4 votes

1 answer

943 views

Where does SQL Server store symmetric keys?

asked Mar 18, 2018 at 13:55

4 votes

2 answers

1k views

What are exact benefits of using R services on Enterprise vs Standard?

asked Jul 25, 2018 at 14:36

4 votes

1 answer

326 views

Why we need to optimize CONTAINED IN clause of FOR_SYSTEM TIME using check constraint?

asked Sep 11, 2018 at 7:26

4 votes

1 answer

4k views

How to find the active transactions in VLF?

asked Sep 12, 2014 at 13:54

4 votes

1 answer

8k views

How to install Microsoft SQL Server 2014 Standard Edition on trial?

asked Jan 18, 2016 at 16:32

3 votes

2 answers

499 views

How to get the size of a spatial index?

asked Feb 29, 2016 at 15:46

3 votes

1 answer

18k views

Unable to start a nested transaction for OLE DB provider "SQLNCLI11" for linked server

asked Feb 2, 2015 at 9:36

Stack Exchange Network

91 Questions

Why 0 is equal to empty string?

Shrink Transaction Log While Using AlwaysOn Availability Group

How to use COLUMNS_UPDATED to check if any of certain columns are updated?

Alternative way to compress NVARCHAR(MAX)?

How to get CPU usage by database for particular instance?

Storing IP addresses - varchar(45) vs varbinary(16)

When `nvarchar/nchar` is going to be used with SQL Server 2019?

Restoring encrypted database on another server (using Backup Encryption)

Are "out of the row" fields read when a clustered index is used?

ADD PERIOD FOR SYSTEM_TIME on table failed

How to name table-variable function unique constraint?

.WRITE clause performance optimization

How to optimize STDistance execution?

Is there a way to minimally log insert under Always on?

GZipStream/DeflateStream compressions alternatives

How can "HierarchyID" type work when "CLR" is disabled?

Are there any reasons to avoid using sp_rename for renaming objects?

Read-ahead reads and SQL-Variant fields

Query Spatial Data for Nearest Neighbor for each group

Change Data Capture vs trigger for logging changes

Is it possible to create encrypted backups using encrypted by password certificate?

T-SQL INNER JOIN Optimisation

SQL Server 2019 column store indexes - maintenance

Where does SQL Server store symmetric keys?

What are exact benefits of using R services on Enterprise vs Standard?

Why we need to optimize CONTAINED IN clause of FOR_SYSTEM TIME using check constraint?

How to find the active transactions in VLF?

How to install Microsoft SQL Server 2014 Standard Edition on trial?

How to get the size of a spatial index?

Unable to start a nested transaction for OLE DB provider "SQLNCLI11" for linked server