User Aaron Bertrand

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

19 votes

Accepted

How to Dynamically change the database using TSQL

answered Sep 4, 2017 at 21:42

19 votes

Accepted

What can be the downside of always having a single integer column as primary key?

answered Feb 3, 2017 at 16:09

19 votes

Accepted

History of database restore completion times?

answered May 12, 2015 at 16:54

19 votes

Accepted

SQL Server compatibility with New TLS Standards

answered Jul 22, 2015 at 21:07

19 votes

Accepted

Dropping a table with a non-printable character in its name

answered Sep 21, 2015 at 14:53

19 votes

Accepted

Is data retrieved from SQL Server compressed for transmission?

answered Feb 23, 2013 at 15:06

19 votes

Accepted

How does SQL Server order results when joins are used?

answered Nov 27, 2012 at 20:41

19 votes

Can I restore a SQL Server .bak files without SQL Server?

answered Jun 28, 2012 at 2:02

19 votes

How to add a user with access to a single view?

answered Apr 27, 2012 at 19:30

19 votes

Accepted

using tables as Table-Valued Parameters (TVP)

answered Feb 10, 2012 at 0:44

19 votes

Management Studio System.OutOfMemoryException

answered Aug 29, 2014 at 15:58

19 votes

Find which session is holding which temporary table

answered Mar 25, 2014 at 17:35

19 votes

Accepted

Looping through values stripping 1 character at a time

answered May 2, 2014 at 13:41

19 votes

Selecting from a view shows the wrong set of columns

answered May 28, 2014 at 15:59

19 votes

Accepted

How to improve Procedure Cache Hit Ratio?

answered Jan 23, 2014 at 1:20

18 votes

Accepted

SQL Server 2012 Restore backup to new DB Name

answered Oct 14, 2013 at 15:36

18 votes

How to find all positions of a string within another string

answered May 12, 2013 at 13:14

18 votes

Can I force a user to use WITH NOLOCK?

answered Jul 31, 2013 at 15:30

18 votes

Accepted

Permission required to view a database diagram

answered Jun 6, 2013 at 13:30

18 votes

High CPU usage on SQL server - Slow queries

answered Jun 14, 2013 at 13:38

18 votes

Accepted

Data Warehouse design for reporting against data for many time zones

answered Feb 12, 2014 at 17:03

18 votes

Accepted

Combine column from multiple rows into single row

answered May 15, 2012 at 22:02

18 votes

Convert date yyyy-mm-dd to integer YYYYMM

answered Jul 14, 2015 at 15:10

18 votes

How to find the nth highest salary in SQL?

answered Apr 30, 2015 at 13:48

18 votes

Accepted

List All Dropped Databases

answered Aug 1, 2018 at 15:38

17 votes

Accepted

Is there any limit for IN results in SQL Server?

answered Feb 1, 2019 at 15:43

17 votes

Accepted

SQL Server table with 4,000,000 rows is 40GB

answered Sep 9, 2019 at 13:17

17 votes

Accepted

Select all records, join with table A if join exists, table B if not

answered Apr 22, 2015 at 19:21

17 votes

How can I determine which tables are causing the database to grow over time?

answered May 29, 2015 at 18:48

Stack Exchange Network

2,340 Answers

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

How to Dynamically change the database using TSQL

What can be the downside of always having a single integer column as primary key?

History of database restore completion times?

SQL Server compatibility with New TLS Standards

Dropping a table with a non-printable character in its name

Is data retrieved from SQL Server compressed for transmission?

How does SQL Server order results when joins are used?

Can I restore a SQL Server .bak files without SQL Server?

How to add a user with access to a single view?

using tables as Table-Valued Parameters (TVP)

Management Studio System.OutOfMemoryException

Find which session is holding which temporary table

Looping through values stripping 1 character at a time

Selecting from a view shows the wrong set of columns

How to improve Procedure Cache Hit Ratio?

SQL Server 2012 Restore backup to new DB Name

How to find all positions of a string within another string

Can I force a user to use WITH NOLOCK?

Permission required to view a database diagram

High CPU usage on SQL server - Slow queries

Data Warehouse design for reporting against data for many time zones

Combine column from multiple rows into single row

Convert date yyyy-mm-dd to integer YYYYMM

How to find the nth highest salary in SQL?

List All Dropped Databases

Is there any limit for IN results in SQL Server?

SQL Server table with 4,000,000 rows is 40GB

Select all records, join with table A if join exists, table B if not

How can I determine which tables are causing the database to grow over time?