Skip to main content
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand's user avatar
Aaron Bertrand
Staff
  • Member for 13 years, 4 months
  • Last seen more than a month ago
20 votes
Accepted

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

20 votes
Accepted

Create new function by code if it doesn't exist

20 votes

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

20 votes
Accepted

Test if any columns are NULL

20 votes
Accepted

How does paging work with ROW_NUMBER in SQL Server?

20 votes
Accepted

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

20 votes

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

20 votes

T SQL Table Valued Function to Split a Column on commas

20 votes

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

20 votes
Accepted

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

19 votes
Accepted

SQL Server compatibility with New TLS Standards

19 votes
Accepted

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

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

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

19 votes

Management Studio System.OutOfMemoryException

19 votes

Can I force a user to use WITH NOLOCK?

18 votes
Accepted

Execution Plan is NOT using INDEX, It uses Table Scan

18 votes
Accepted

Data Warehouse design for reporting against data for many time zones

18 votes

Cannot log in using SA with SQL Authentication

18 votes

How to find the nth highest salary in SQL?

18 votes
Accepted

Combine column from multiple rows into single row

18 votes

How to find all positions of a string within another string

18 votes
Accepted

List All Dropped Databases

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

17 votes
Accepted

Are there issues with using SELECT * in a view definition?

1
3 4
5
6 7
79