Ben Thul

Bellevue, WA, United States

http://spartansql.com

A SQL Server DBA living and working in the Seattle area. Professional interests include T-SQL programming, query tuning, and automation.

top accounts reputation activity subscriptions

Locate all "light bulb" actions in VS 2015

visual-studio visual-studio-2015 asked Sep 6, 2015 at 23:07

stackoverflow.com

8 votes

Are "create user" and "grant connect" functionally equivalent?

sql-server asked Mar 4, 2013 at 19:50

dba.stackexchange.com

8 votes

How do I check that the database master key encryption is valid?

sql-server encryption encryption-key asked Jan 5, 2017 at 23:10

dba.stackexchange.com

8 votes

What is happening in the picture

geometry asked Jun 27, 2015 at 4:55

math.stackexchange.com

6 votes

Correlating volumes and physical disks through WMI

windows-server-2012-r2 wmi asked Dec 15, 2014 at 22:32

serverfault.com

6 votes

Stored procedure security with execute as, cross database queries, and module signing

sql-server security certificate signature impersonation asked Oct 20, 2016 at 23:32

dba.stackexchange.com

6 votes

Adding a nullable rowversion column to a table

sql-server rowversion asked Feb 14, 2017 at 0:34

stackoverflow.com

5 votes

Status for a service broker queue

sql-server service-broker asked Feb 1, 2012 at 15:52

dba.stackexchange.com

5 votes

Inline table-valued function vs inline sql

sql-server sql-server-2008-r2 asked Dec 21, 2012 at 19:40

dba.stackexchange.com

Top Answers

606

T-SQL: Deleting all duplicate rows but keeping one

stackoverflow.com

Creating a stored procedure if it does not already exist

stackoverflow.com

"The transaction log for database is full due to 'LOG_BACKUP'" in a shared host

stackoverflow.com

radius search by latitude / longitude

stackoverflow.com

What do these Copy Only Backup options mean?

stackoverflow.com

Get the text of a stored procedure in SQL Server

stackoverflow.com

SQL Server 2008 Spatial: find a point in polygon

stackoverflow.com

How to select only the first rows for each unique value of a column?

stackoverflow.com

How can I prevent accidentally jacking with a production database?

serverfault.com

Should I index a bit field in SQL Server?

stackoverflow.com

Delete messages in service broker queue

stackoverflow.com

SQL Server: how to remove last comma after combining rows using XML Path

stackoverflow.com

How to update a CLR Assembly without dropping assembly from SQL Server

serverfault.com

How do I check for the SQL Server Version using Powershell?

stackoverflow.com

HierarchyID: Get all descendants for a list of parents

stackoverflow.com

How to restrict a user to access objects of only one schema in SQL Server 2008?

stackoverflow.com

Will adding a nonclustered index lock my table?

stackoverflow.com

Can you temporarily turn off database changes in Microsoft SQL Server?

serverfault.com

Alter clustered index column

stackoverflow.com

How to undo assigning ownership of db_datareader/db_datawriter schema?

serverfault.com

ALTER DATABASE db_name SET ENABLE_BROKER with rollback immediate

stackoverflow.com

ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE is not returning correct values

stackoverflow.com

T-SQL Substring - Last 3 Characters

stackoverflow.com

IsSystemObject attribute of smo

stackoverflow.com

SQL Server 2012 Random string from a list

stackoverflow.com

How to Grant REFERENCES permission to all tables

stackoverflow.com

At What Point Should I Split or Partition a Very Large but Simple Table

dba.stackexchange.com

SQL Server STIntersects Query Returns false positives

stackoverflow.com

SQL Alchemy Check Connection

stackoverflow.com

How to change SQL Server Instance TCP Ports to 1433 using CMD?

stackoverflow.com