User Kin Shah

124 votes

Accepted

Is it a bad practice to always create a transaction?

answered May 28, 2013 at 16:10

64 votes

Accepted

Why is a .bacpac file so small compared to a .bak file of the same database?

answered May 9, 2016 at 14:06

60 votes

Accepted

MAXDOP setting algorithm for SQL Server

answered Mar 13, 2013 at 14:18

46 votes

How to move a database from SQL Server 2012 to SQL Server 2005

answered Dec 15, 2013 at 17:49

45 votes

Accepted

How to clone a user in SQL Server 2008 R2?

answered May 6, 2014 at 14:22

39 votes

Accepted

Upgrade SQL Server 2000 database to 2008 R2 and enable new features

answered Sep 22, 2013 at 18:26

34 votes

Accepted

Identifying Unused Stored Procedures

answered Jul 25, 2013 at 21:48

33 votes

Accepted

how to get History of queries executed with username in SQL

answered Apr 12, 2016 at 16:45

32 votes

Accepted

Which one is more efficient: select from linked server or insert into linked server?

answered Jul 13, 2013 at 3:17

31 votes

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

answered Jun 12, 2013 at 3:23

31 votes

Accepted

When to use sort_in_tempdb when rebuilding indexes?

answered Jul 31, 2015 at 19:28

30 votes

Accepted

What does OPTION FAST in SELECT statement do?

answered Apr 15, 2016 at 20:02

30 votes

Accepted

Reset IDENTITY value

answered Jun 5, 2013 at 21:48

27 votes

Accepted

Difference between FreeProcCache and FreeSystemCache

answered Jan 15, 2014 at 22:27

26 votes

Accepted

Need to understand parallel query execution error

answered Jul 29, 2013 at 20:00

25 votes

Accepted

How to partition an existing non-partitioned table

answered Aug 13, 2013 at 0:39

24 votes

Why would I NOT use the SQL Server option "optimize for ad hoc workloads"?

answered Mar 26, 2013 at 16:43

22 votes

Accepted

When is a Dynamic Port "dynamic"?

answered Aug 6, 2013 at 18:29

22 votes

Accepted

SQL Server 2012: Generate Scripts from command line

answered Jan 12, 2014 at 18:38

22 votes

When is it better to create STATISTICS instead of creating an Index?

answered Oct 23, 2015 at 20:21

22 votes

SQL Server - granting permissions to an entire schema vs. object?

answered Jan 6, 2016 at 16:28

21 votes

Accepted

Get detailed output of SQL Agent job

answered Mar 16, 2015 at 1:59

21 votes

Accepted

SQL Server Developer Edition 2012 or 2014 - Download

answered May 21, 2015 at 21:35

21 votes

List all permissions for a given role?

answered Jun 12, 2013 at 3:09

20 votes

Accepted

Moving from SQL 2005 [SQL_Latin1_General_CP1_CI_AS] to 2008 - will I lose any features by using 'backwards compatibility'

answered Aug 20, 2013 at 16:17

20 votes

Accepted

If you don't rollback a transaction will the change still be made?

answered Aug 7, 2015 at 15:37

20 votes

Accepted

Where do you go to request new features in SSMS?

answered Jan 15, 2019 at 15:06

19 votes

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

answered Dec 1, 2015 at 17:24

19 votes

Accepted

If I fail over one database, do the others that share the same mirror endpoint fail over as well?

answered May 9, 2013 at 17:04

19 votes

difference in execution plans on UAT and PROD server

answered Dec 18, 2013 at 16:34

Stack Exchange Network

1,351 Answers

Is it a bad practice to always create a transaction?

Why is a .bacpac file so small compared to a .bak file of the same database?

MAXDOP setting algorithm for SQL Server

How to move a database from SQL Server 2012 to SQL Server 2005

How to clone a user in SQL Server 2008 R2?

Upgrade SQL Server 2000 database to 2008 R2 and enable new features

Identifying Unused Stored Procedures

how to get History of queries executed with username in SQL

Which one is more efficient: select from linked server or insert into linked server?

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

When to use sort_in_tempdb when rebuilding indexes?

What does OPTION FAST in SELECT statement do?

Reset IDENTITY value

Difference between FreeProcCache and FreeSystemCache

Need to understand parallel query execution error

How to partition an existing non-partitioned table

Why would I NOT use the SQL Server option "optimize for ad hoc workloads"?

When is a Dynamic Port "dynamic"?

SQL Server 2012: Generate Scripts from command line

When is it better to create STATISTICS instead of creating an Index?

SQL Server - granting permissions to an entire schema vs. object?

Get detailed output of SQL Agent job

SQL Server Developer Edition 2012 or 2014 - Download

List all permissions for a given role?

Moving from SQL 2005 [SQL_Latin1_General_CP1_CI_AS] to 2008 - will I lose any features by using 'backwards compatibility'

If you don't rollback a transaction will the change still be made?

Where do you go to request new features in SSMS?

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

If I fail over one database, do the others that share the same mirror endpoint fail over as well?

difference in execution plans on UAT and PROD server