User Aaron Bertrand

22 votes

Accepted

How can I backup a large SQL Server database without impacting performance?

answered Dec 18, 2012 at 19:04

22 votes

Reset IDENTITY value

answered Jun 6, 2013 at 2:59

22 votes

Does disconnecting the network stop a query?

answered Aug 1, 2013 at 13:29

22 votes

Accepted

Does sys.sql_logins.is_policy_checked mean that the policy has been checked?

answered Apr 30, 2015 at 15:28

22 votes

Accepted

Best way to migrate a huge SQL Server database with low downtime over network

answered Jan 28, 2015 at 2:18

22 votes

Accepted

Why use master to create a database?

answered Oct 28, 2018 at 16:31

21 votes

Accepted

SQL Server 2012 is putting [brackets] around Table and Column Names

answered Jul 31, 2012 at 21:54

21 votes

Accepted

SQL Server: Should we use TCP or Named Pipes or use the default?

answered Sep 12, 2012 at 12:00

21 votes

Accepted

What database technologies do big search engines use?

answered Jun 1, 2012 at 11:59

21 votes

Adding columns to production tables

answered Aug 10, 2011 at 12:43

21 votes

Accepted

Generating large strings for test data

answered Aug 18, 2011 at 13:26

21 votes

Accepted

Does the order of columns in a columnstore index matter?

answered Apr 2, 2012 at 6:08

21 votes

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

answered Feb 13, 2012 at 18:04

21 votes

Accepted

Is there a reason to update statistics manually?

answered Feb 10, 2012 at 20:18

21 votes

Accepted

How to extract the last inserted row in SQL Server?

answered Nov 10, 2013 at 16:53

21 votes

Accepted

What are the SQL Server 2012 versions of FIRST() and LAST()?

answered Dec 9, 2015 at 18:21

21 votes

Accepted

Stuck task in management studio, how do you handle them?

answered May 9, 2016 at 17:59

21 votes

Accepted

Is a join optimized to a where clause at runtime?

answered Feb 27, 2013 at 16:37

21 votes

Accepted

SQL Server: grant select access to a user in a view and not in its tables

answered Jan 19, 2015 at 13:52

21 votes

Accepted

Migrate from SQL Server 2000 to 2012 without a 2005 or 2008 instance

answered May 1, 2015 at 11:24

21 votes

Accepted

Why does this query, missing a FROM clause, not error out?

answered Jun 7, 2019 at 16:19

20 votes

Accepted

Test if any columns are NULL

answered Mar 12, 2012 at 20:45

20 votes

Accepted

Create new function by code if it doesn't exist

answered Jun 9, 2012 at 5:05

20 votes

Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?

answered Jul 19, 2012 at 16:23

20 votes

T SQL Table Valued Function to Split a Column on commas

answered Jul 18, 2012 at 15:56

20 votes

Accepted

Is there an efficient way to see the cause for "String or binary data would be truncated"?

answered Jan 25, 2018 at 13:21

20 votes

Accepted

Why does transaction log continue to grow in Simple recovery mode with nightly backups

answered Aug 13, 2014 at 16:59

20 votes

Accepted

How does paging work with ROW_NUMBER in SQL Server?

answered Jan 14, 2013 at 15:13

20 votes

Accepted

Accidentally turned down SQL memory too low to log in, how do I fix?

answered Apr 19, 2013 at 21:09

20 votes

Accepted

A query that lists all mapped users for a given login

answered Oct 31, 2014 at 16:18

Stack Exchange Network

2,340 Answers

How can I backup a large SQL Server database without impacting performance?

Reset IDENTITY value

Does disconnecting the network stop a query?

Does sys.sql_logins.is_policy_checked mean that the policy has been checked?

Best way to migrate a huge SQL Server database with low downtime over network

Why use master to create a database?

SQL Server 2012 is putting [brackets] around Table and Column Names

SQL Server: Should we use TCP or Named Pipes or use the default?

What database technologies do big search engines use?

Adding columns to production tables

Generating large strings for test data

Does the order of columns in a columnstore index matter?

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

Is there a reason to update statistics manually?

How to extract the last inserted row in SQL Server?

What are the SQL Server 2012 versions of FIRST() and LAST()?

Stuck task in management studio, how do you handle them?

Is a join optimized to a where clause at runtime?

SQL Server: grant select access to a user in a view and not in its tables

Migrate from SQL Server 2000 to 2012 without a 2005 or 2008 instance

Why does this query, missing a FROM clause, not error out?

Test if any columns are NULL

Create new function by code if it doesn't exist

Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?

T SQL Table Valued Function to Split a Column on commas

Is there an efficient way to see the cause for "String or binary data would be truncated"?

Why does transaction log continue to grow in Simple recovery mode with nightly backups

How does paging work with ROW_NUMBER in SQL Server?

Accidentally turned down SQL memory too low to log in, how do I fix?

A query that lists all mapped users for a given login