Solomon Rutzky

Raleigh, NC, United States

https://SqlQuantumLift.com

I can usually be found lurking in the following places:

Sql Quantum Lift ( SQL# and soon OmniExec and others )

Sql Quantum Leap (my blog)

SQL Server Central ( Stairway to SQLCLR series )

CLR Performance Testing (on Simple Talk)

ASK.SQLServerCentral

Module Signing Info

top accounts reputation activity subscriptions

When is it better to create STATISTICS instead of creating an Index?

sql-server best-practices statistics index-statistics asked Oct 23, 2015 at 18:27

dba.stackexchange.com

37 votes

Setting BUFFERCOUNT, BLOCKSIZE, and MAXTRANSFERSIZE for BACKUP command

sql-server backup best-practices maintenance asked Feb 5, 2016 at 19:31

dba.stackexchange.com

16 votes

Create hierarchy of multiple levels where each node has a random number of children

sql-server t-sql hierarchical random asked Oct 8, 2015 at 19:47

dba.stackexchange.com

13 votes

Does SQL Server / T-SQL support line-continuation to break up long strings?

sql-server t-sql ssms scripting asked Oct 31, 2017 at 21:27

dba.stackexchange.com

12 votes

If no plans to uninstall, can Log and Update Cache folders in Setup Bootstrap folder be removed?

sql-server best-practices disk-space management asked Jan 10, 2018 at 20:38

dba.stackexchange.com

12 votes

How is the new system stored procedure sys.xp_delete_files different from sys.xp_delete_file?

sql-server sql-server-2019 extended-stored-procedure file-system asked Jan 29, 2020 at 22:33

dba.stackexchange.com

11 votes

SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file

sql-server linux errors asked Sep 4, 2017 at 21:37

dba.stackexchange.com

7 votes

Provide a proper way to indicate error messages that is visually distinct from quotes and actual code

feature-request markdown code-formatting information-display asked Jun 19, 2020 at 5:38

meta.stackexchange.com

6 votes

Benefit or use-case for empty variable / parameter / temporary table / temporary procedure names?

sql-server t-sql temp-tables parameter table-variable asked May 17, 2016 at 20:58

dba.stackexchange.com

5 votes

How to get the Collation of string Fields in a Result Set via SqlDataReader?

.net sql-server collation sqldatareader sqlclr asked Feb 4, 2016 at 1:20

stackoverflow.com

Top Answers

157

See whether an item appears more than once in a database column

stackoverflow.com

116

What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?

stackoverflow.com

115

Reset identity seed after deleting records in SQL Server

stackoverflow.com

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

dba.stackexchange.com

How to update large table with millions of rows in SQL Server?

stackoverflow.com

Difference between scalar, table-valued, and aggregate functions in SQL server?

stackoverflow.com

Improve SQL Server query performance on large tables

stackoverflow.com

drop trigger if exists and create

stackoverflow.com

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

dba.stackexchange.com

SQL Server default character encoding

stackoverflow.com

How can I insert 10 million records in the shortest time possible?

stackoverflow.com

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

dba.stackexchange.com

Composite Primary Key in multi-tenant SQL Server database

dba.stackexchange.com

Which version of .NET framework SQL Server supports?

stackoverflow.com

What are the main performance differences between varchar and nvarchar SQL Server data types?

stackoverflow.com

How to create Unicode parameter and variable names

dba.stackexchange.com

TSQL md5 hash different to C# .NET md5

stackoverflow.com

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

dba.stackexchange.com

Make SqlClient default to ARITHABORT ON

dba.stackexchange.com

How to grant the database owner (DBO) the EXTERNAL ACCESS ASSEMBLY permission?

stackoverflow.com

Which collation should I use for biblical Hebrew?

dba.stackexchange.com

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

dba.stackexchange.com

Can SQL Server SQL_Latin1_General_CP1_CI_AS be safely converted to Latin1_General_CI_AS?

stackoverflow.com

Changing the collation of a SQL Server 2012 database

stackoverflow.com

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

dba.stackexchange.com

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

dba.stackexchange.com

Applicants clearly not having the skills they advertise

workplace.stackexchange.com

VS SQLCLR: Function X has unresolved reference to schema Y

stackoverflow.com

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

dba.stackexchange.com

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

dba.stackexchange.com