Skip to main content
Solomon Rutzky's user avatar
Solomon Rutzky's user avatar
Solomon Rutzky's user avatar
Solomon Rutzky
  • Member for 10 years, 7 months
  • Last seen this week
103 votes
Accepted

SQL Server: How to track progress of CREATE INDEX command?

67 votes

How to rollback when 3 stored procedures are started from one stored procedure

50 votes

Composite Primary Key in multi-tenant SQL Server database

50 votes
Accepted

How do I set a SQL Server Unicode / NVARCHAR string to an emoji or Supplementary Character?

44 votes
Accepted

How to create Unicode parameter and variable names

39 votes
Accepted

Why does SQL Injection not happen on this query inside a stored procedure?

37 votes

Make SqlClient default to ARITHABORT ON

35 votes

Which collation should I use for biblical Hebrew?

33 votes

SQL-Server: Why do we use FILE = 1 in scripts for restoring a database

33 votes
Accepted

Does any DBMS have a collation that is both case-sensitive and accent-insensitive?

31 votes
Accepted

Why is :r SQLCMD command marked as wrong in Post Deployment Script?

31 votes

How to treat numbers within strings as numbers when sorting ("A3" sorts before "A10", not after)

31 votes
Accepted

Why does a comparison between 'tr' & 'tR' fail on a SQL Server with Vietnamese_CI_AI collation?

30 votes

If a CTE is defined in a query and is never used, does it make a sound?

30 votes
Accepted

LocalDB v14 creates wrong path for mdf files

28 votes
Accepted

UPDATE performance where no data changes

27 votes
Accepted

Are we required to handle Transaction in C# Code as well as in stored procedure

27 votes
Accepted

space usage on sys.allocation_units and sp_spaceused

27 votes
Accepted

PostgreSQL: difference between collations 'C' and 'C.UTF-8'

27 votes
Accepted

How does case-insensitive collation work?

26 votes
Accepted

How To Strip Hebrew Accent Marks

25 votes
Accepted

Why is a NOT NULL computed column considered nullable in a view?

25 votes
Accepted

DEFAULT CONSTRAINT, worth it?

24 votes
Accepted

Encoding issue with SQL Server VARCHAR column retrieved in Python

24 votes
Accepted

Is there a penalty for using BINARY(16) instead of UNIQUEIDENTIFIER?

24 votes
Accepted

What is the sense and benefit of using SqlCommand.Prepare()?

23 votes
Accepted

Why must TVPs be READONLY, and why can't parameters of other types be READONLY

23 votes

Retrieving n rows per group

23 votes
Accepted

What are the current best practices concerning varchar sizing in SQL Server?

22 votes

Can't update "CO2" to "CO₂" in table row

1
2 3 4 5
32