User Aaron Bertrand

28 votes

Accepted

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

answered Feb 1, 2016 at 15:07

28 votes

Accepted

ISO Week vs SQL Server Week

answered Mar 27, 2013 at 15:59

28 votes

Improve delete speed for SQL Server

answered May 27, 2015 at 15:20

27 votes

Is nested view a good database design?

answered Sep 7, 2011 at 17:38

27 votes

Accepted

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

answered Feb 19, 2014 at 14:57

27 votes

Accepted

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

answered Jan 25, 2013 at 16:01

26 votes

Handling growing number of Tenants in Multi-tenant Database Architecture

answered Apr 19, 2012 at 14:26

26 votes

Accepted

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

answered Aug 23, 2012 at 21:38

26 votes

Accepted

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

answered Oct 2, 2014 at 19:25

25 votes

Why do wildcards in GROUP BY statements not work?

answered Jul 20, 2012 at 13:22

25 votes

Performance difference for COALESCE versus ISNULL?

answered Aug 3, 2011 at 14:45

25 votes

Accepted

Datatype bigger than bigint

answered Oct 15, 2013 at 13:00

24 votes

Accepted

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

answered Jul 7, 2011 at 18:37

24 votes

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

answered Dec 1, 2015 at 17:29

23 votes

Does SentryOne Plan Explorer work?

answered Aug 4, 2011 at 18:16

23 votes

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

answered Jul 9, 2012 at 16:58

23 votes

Accepted

SQL Server on Mac

answered Apr 3, 2014 at 23:22

23 votes

Accepted

Copy maintenance plans to a different server

answered Apr 28, 2014 at 15:06

23 votes

Accepted

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

answered Mar 1, 2016 at 14:55

23 votes

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

answered Dec 18, 2014 at 15:22

23 votes

Accepted

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

answered Mar 26, 2015 at 17:16

22 votes

Accepted

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

answered Aug 16, 2012 at 23:18

22 votes

Composing the "ultimate database maintenance script"

answered Aug 7, 2012 at 13:16

22 votes

Accepted

Disabling Checking of Schema On Function/Stored Procedure Creation

answered Sep 25, 2012 at 0:55

22 votes

Accepted

What reasons are there to stop the SQL Server?

answered Jan 7, 2017 at 21:58

22 votes

How to create Unicode parameter and variable names

answered Mar 18, 2018 at 17:04

22 votes

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

answered Mar 11, 2014 at 1:38

22 votes

Accepted

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

answered Sep 11, 2013 at 17:06

22 votes

Accepted

SQL Server 2000 on Windows 10

answered Aug 24, 2015 at 15:51

22 votes

Accepted

Why is removing the Identity property on a column not supported

answered Sep 9, 2015 at 18:52

Stack Exchange Network

2,340 Answers

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

ISO Week vs SQL Server Week

Improve delete speed for SQL Server

Is nested view a good database design?

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

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

Handling growing number of Tenants in Multi-tenant Database Architecture

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

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

Why do wildcards in GROUP BY statements not work?

Performance difference for COALESCE versus ISNULL?

Datatype bigger than bigint

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

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

Does SentryOne Plan Explorer work?

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

SQL Server on Mac

Copy maintenance plans to a different server

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

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

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

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

Composing the "ultimate database maintenance script"

Disabling Checking of Schema On Function/Stored Procedure Creation

What reasons are there to stop the SQL Server?

How to create Unicode parameter and variable names

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

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

SQL Server 2000 on Windows 10

Why is removing the Identity property on a column not supported