User Hannah Vernon

9 votes

Accepted

8k row overflow error when updating row of size 5k

answered Dec 31, 2015 at 19:44

9 votes

Accepted

Where does an execution plan come from?

answered Dec 21, 2015 at 14:38

9 votes

Accepted

What are all the ways an open transaction will rollback?

answered Nov 2, 2015 at 20:22

9 votes

Accepted

Using NOCOUNT to Improve Procedure Performance

answered May 29, 2015 at 18:10

9 votes

Accepted

T-SQL: If parameter1 is null, use parameter2

answered Jun 3, 2016 at 22:09

9 votes

Accepted

Best way to create a login with hashed password?

answered Aug 23, 2016 at 16:04

9 votes

Accepted

Where does SQL Server physically store the IDENTITY VALUE for a table?

answered Apr 20, 2016 at 19:13

9 votes

Easy way to change Column ID (primary key) of a table to Auto increment

answered Apr 15, 2016 at 15:01

9 votes

msdb.dbo.sysjobs and last run date and time

answered Apr 28, 2016 at 18:28

9 votes

Accepted

Does Clustered Index on GUID create more fragmentation than Non Clustered Index?

answered May 9, 2016 at 18:32

8 votes

Test if a string is a palindrome using T-SQL

answered May 3, 2016 at 18:25

8 votes

Accepted

SQL Server Clustering - Active/Active or Active/Passive?

answered Apr 20, 2016 at 17:05

8 votes

Accepted

Effective SQL Server permissions when user is in several AD groups

answered Mar 3, 2016 at 12:45

8 votes

Accepted

Is it worth making a separate DATE table or not?

answered Apr 4, 2016 at 21:38

8 votes

How do I detect execute permission granted to a role (when no ON clause was used)

answered Apr 7, 2016 at 22:34

8 votes

Accepted

how to insert a list of varchar values, into a single column table?

answered Sep 25, 2015 at 17:26

8 votes

Accepted

Create index with a commentary

answered Oct 21, 2015 at 15:43

8 votes

Accepted

MERGE with IDENTITY_INSERT ON does not work if Identity is not the primary key

answered Dec 8, 2015 at 19:02

8 votes

Accepted

Rebuilding an entire Microsoft SQL Server Database

answered Aug 1, 2014 at 22:02

8 votes

Accepted

Who changed/modified stored procedure in SSMS 2005 or 2008?

answered Sep 27, 2012 at 16:27

8 votes

Accepted

Set Backup Compression on SQL Server 2008R2 on by default

answered Sep 6, 2012 at 2:45

8 votes

Accepted

Kerberos authentication not working with Linked Servers in SQL Server 2012

answered Dec 13, 2012 at 23:20

8 votes

Accepted

SQL Server how to detect unused views and/or get usage stats

answered Apr 9, 2013 at 20:36

8 votes

Accepted

How do you write to a folder with spaces in it?

answered Apr 26, 2018 at 17:49

8 votes

How to model Parent -> Child -> Grandchild if the Child can be removed

answered Mar 15, 2018 at 2:00

8 votes

Accepted

Execution Plan is different when Constant Variable is Null

answered Jan 15, 2019 at 17:07

8 votes

Using SPID in DB Tables (instead of Table Variable)

answered Jul 17, 2019 at 19:29

8 votes

Accepted

Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?

answered Mar 13, 2019 at 18:20

8 votes

Accepted

Displaying the order of the columns of a table

answered Mar 26, 2019 at 20:34

8 votes

Accepted

Is pre-sorting valuable when using table value constructor to insert multiple values into a table with clustered index?

answered Jan 6, 2017 at 18:56

Stack Exchange Network

1,327 Answers

8k row overflow error when updating row of size 5k

Where does an execution plan come from?

What are all the ways an open transaction will rollback?

Using NOCOUNT to Improve Procedure Performance

T-SQL: If parameter1 is null, use parameter2

Best way to create a login with hashed password?

Where does SQL Server physically store the IDENTITY VALUE for a table?

Easy way to change Column ID (primary key) of a table to Auto increment

msdb.dbo.sysjobs and last run date and time

Does Clustered Index on GUID create more fragmentation than Non Clustered Index?

Test if a string is a palindrome using T-SQL

SQL Server Clustering - Active/Active or Active/Passive?

Effective SQL Server permissions when user is in several AD groups

Is it worth making a separate DATE table or not?

How do I detect execute permission granted to a role (when no ON clause was used)

how to insert a list of varchar values, into a single column table?

Create index with a commentary

MERGE with IDENTITY_INSERT ON does not work if Identity is not the primary key

Rebuilding an entire Microsoft SQL Server Database

Who changed/modified stored procedure in SSMS 2005 or 2008?

Set Backup Compression on SQL Server 2008R2 on by default

Kerberos authentication not working with Linked Servers in SQL Server 2012

SQL Server how to detect unused views and/or get usage stats

How do you write to a folder with spaces in it?

How to model Parent -> Child -> Grandchild if the Child can be removed

Execution Plan is different when Constant Variable is Null

Using SPID in DB Tables (instead of Table Variable)

Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?

Displaying the order of the columns of a table

Is pre-sorting valuable when using table value constructor to insert multiple values into a table with clustered index?