gotqn's user avatar
gotqn's user avatar
gotqn's user avatar
gotqn
  • Member for 12 years, 1 month
  • Last seen more than a week ago
29 votes
1 answer
18k views

Why 0 is equal to empty string?

23 votes
1 answer
4k views

Is "+" slower than "CONCAT" for large strings?

18 votes
3 answers
89k views

Shrink Transaction Log While Using AlwaysOn Availability Group

16 votes
1 answer
28k views

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

15 votes
2 answers
15k views

Alternative way to compress NVARCHAR(MAX)?

15 votes
4 answers
93k views

How to get CPU usage by database for particular instance?

12 votes
2 answers
20k views

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

12 votes
2 answers
3k views

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

11 votes
2 answers
40k views

Restoring encrypted database on another server (using Backup Encryption)

10 votes
2 answers
526 views

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

9 votes
4 answers
14k views

ADD PERIOD FOR SYSTEM_TIME on table failed

8 votes
1 answer
2k views

How to name table-variable function unique constraint?

8 votes
1 answer
1k views

.WRITE clause performance optimization

7 votes
4 answers
4k views

How to optimize STDistance execution?

6 votes
1 answer
6k views

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

6 votes
1 answer
3k views

GZipStream/DeflateStream compressions alternatives

6 votes
1 answer
554 views

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

6 votes
1 answer
4k views

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

6 votes
1 answer
170 views

Read-ahead reads and SQL-Variant fields

5 votes
3 answers
5k views

Query Spatial Data for Nearest Neighbor for each group

5 votes
2 answers
10k views

Change Data Capture vs trigger for logging changes

5 votes
1 answer
526 views

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

5 votes
4 answers
5k views

T-SQL INNER JOIN Optimisation

5 votes
2 answers
593 views

SQL Server 2019 column store indexes - maintenance

4 votes
1 answer
989 views

Where does SQL Server store symmetric keys?

4 votes
2 answers
1k views

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

4 votes
1 answer
337 views

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

4 votes
1 answer
4k views

How to find the active transactions in VLF?

4 votes
1 answer
9k views

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

3 votes
2 answers
516 views

How to get the size of a spatial index?