Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand
Staff
  • Member for 13 years, 1 month
  • Last seen this week
22 votes
Accepted

Why use master to create a database?

22 votes
Accepted

No SA password. No SQL Server Management Studio. No OS authentication

22 votes
Accepted

How to extract the last inserted row in SQL Server?

22 votes

Reset IDENTITY value

22 votes

Does disconnecting the network stop a query?

22 votes
Accepted

Generating large strings for test data

22 votes
Accepted

Does the order of columns in a columnstore index matter?

22 votes
Accepted

How and when does SQL Agent update next_run_date/next_run_time values?

22 votes

Composing the "ultimate database maintenance script"

22 votes
Accepted

Disabling Checking of Schema On Function/Stored Procedure Creation

22 votes
Accepted

How do I check for a null or empty table-valued parameter?

22 votes
Accepted

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

21 votes
Accepted

Is a join optimized to a where clause at runtime?

21 votes
Accepted

Is data retrieved from SQL Server compressed for transmission?

21 votes
Accepted

How does SQL Server order results when joins are used?

21 votes
Accepted

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

21 votes
Accepted

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

21 votes

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

21 votes
Accepted

Is there a reason to update statistics manually?

21 votes

Adding columns to production tables

21 votes
Accepted

What database technologies do big search engines use?

21 votes
Accepted

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

21 votes
Accepted

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

21 votes
Accepted

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

21 votes

Convert date yyyy-mm-dd to integer YYYYMM

20 votes
Accepted

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

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

20 votes
Accepted

Create new function by code if it doesn't exist

1 2 3
4
5
79