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, 3 months
  • Last seen more than a month ago
28 votes

Is nested view a good database design?

28 votes
Accepted

How to transfer the ownership of the dbo schema in SQL Server 2012

28 votes
Accepted

Database disaster prevention

28 votes
Accepted

'CONCAT' is not a recognized built-in function name

27 votes
Accepted

What is the fastest way to insert large numbers of rows?

27 votes
Accepted

How can I get all orphan records in a single query?

27 votes
Accepted

Is that a good idea to use one database for 50.000+ shops?

27 votes
Accepted

Is there a way to test whether DELETE will fail due to constraints?

26 votes

Handling growing number of Tenants in Multi-tenant Database Architecture

25 votes

Why do wildcards in GROUP BY statements not work?

25 votes

Performance difference for COALESCE versus ISNULL?

25 votes
Accepted

Datatype bigger than bigint

25 votes
Accepted

How can I map a login to a database using T-SQL (not SSMS)

24 votes

Copying (hundreds of) tables from one server to another (with SSMS)

24 votes
Accepted

Which DBMS are fast enough for an online game (few thousand players)?

23 votes

Does SentryOne Plan Explorer work?

23 votes

Restore SQL Server 2012 backup to a SQL Server 2008 database?

23 votes

How to create a read-only server role on SQL Server 2012?

23 votes
Accepted

SQL Server on Mac

23 votes
Accepted

Copy maintenance plans to a different server

23 votes

Microsoft recommends using Rowversion over timestamp, but I can not find "rowversion" data type inside my sql server 2008 R2

23 votes
Accepted

Why is adding a NOT NULL column with a default constraint instantaneous?

22 votes
Accepted

A query that lists all mapped users for a given login

22 votes
Accepted

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

22 votes
Accepted

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

22 votes
Accepted

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

22 votes
Accepted

SQL Server 2000 on Windows 10

22 votes
Accepted

Why is removing the Identity property on a column not supported

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?

1 2
3
4 5
79