Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand
Staff
  • Member for 12 years, 11 months
  • Last seen this week
20 votes
Accepted

Test if any columns are NULL

20 votes
Accepted

Is data retrieved from SQL Server compressed for transmission?

20 votes
Accepted

How does paging work with ROW_NUMBER in SQL Server?

20 votes
Accepted

How does SQL Server order results when joins are used?

20 votes
Accepted

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

20 votes
Accepted

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

20 votes
Accepted

How to Dynamically change the database using TSQL

19 votes

Management Studio System.OutOfMemoryException

19 votes
Accepted

Looping through values stripping 1 character at a time

19 votes

Selecting from a view shows the wrong set of columns

19 votes

Find which session is holding which temporary table

19 votes
Accepted

How to improve Procedure Cache Hit Ratio?

19 votes
Accepted

Kill all sessions for ONE user in MS SQL

19 votes
Accepted

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

19 votes
Accepted

History of database restore completion times?

19 votes
Accepted

using *tables* as Table-Valued Parameters (TVP)

19 votes
Accepted

SQL Server compatibility with New TLS Standards

18 votes
Accepted

Data Warehouse design for reporting against data for many time zones

18 votes

Convert date yyyy-mm-dd to integer YYYYMM

18 votes

How to find all positions of a string within another string

18 votes
Accepted

Permission required to view a database diagram

18 votes

High CPU usage on SQL server - Slow queries

18 votes
Accepted

SQL Server 2012 Restore backup to new DB Name

18 votes

Can I force a user to use WITH NOLOCK?

18 votes
Accepted

Combine column from multiple rows into single row

18 votes
Accepted

Execution Plan is NOT using INDEX, It uses Table Scan

18 votes

How to find the nth highest salary in SQL?

18 votes
Accepted

List All Dropped Databases

17 votes

Cannot log in using SA with SQL Authentication

17 votes

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

1
3 4
5
6 7
79