User Kin Shah

10 votes

Accepted

Getting database sizes on an MSSQL Server named instance

answered Oct 27, 2015 at 18:44

10 votes

Accepted

sql server max memory includes SSIS?

answered Jul 28, 2015 at 1:36

10 votes

How can I convert a key in a SQL Server deadlock report to the value?

answered Jul 13, 2015 at 14:39

9 votes

Accepted

How to answer why suddenly we need indexes or query needs to be changed

answered Aug 17, 2015 at 22:14

9 votes

In Sql Server, is there a way to check if a selected group of rows are locked or not?

answered Aug 25, 2015 at 17:24

9 votes

Accepted

Determine the SQL Server version and edition from the available set up, before actually installing it?

answered Apr 17, 2015 at 14:00

9 votes

How to set Database Recover Mode to Full for all databases?

answered Sep 29, 2015 at 1:03

9 votes

How can I Debug a Buffer Issue?

answered Sep 21, 2015 at 19:42

9 votes

Accepted

Recursive sql query performance issue

answered Sep 23, 2015 at 22:14

9 votes

Accepted

"truncate log on checkpoint" option in SQL Server

answered Sep 24, 2015 at 18:32

9 votes

Accepted

How to use an alias name that has RANK() OVER in a WHERE clause

answered Sep 3, 2015 at 19:07

9 votes

Moving Databases to New Datacenters

answered Nov 27, 2015 at 20:52

9 votes

Most useful stored procedures for a new DBA?

answered May 24, 2016 at 15:41

9 votes

Accepted

Best way to backup & truncate transaction logs on a schedule

answered Jun 6, 2016 at 19:30

9 votes

Exclude databases from automatic full backup

answered May 3, 2016 at 23:34

9 votes

Accepted

Using the database engine tuning advisor - how do I generate the scripts for the recommendations?

answered May 10, 2016 at 14:10

9 votes

Execution plan percentages don't add up to 100%

answered Jun 17, 2016 at 19:14

9 votes

Accepted

Can a plan "age" reach zero?

answered Sep 30, 2016 at 15:23

9 votes

Instant File Initialization

answered Jan 31, 2017 at 20:06

9 votes

Accepted

How to reduce the number of things SQL Server puts in the windows event viewer?

answered Jul 22, 2013 at 14:29

9 votes

Accepted

Cannot rename the table because it is published for replication

answered Jul 29, 2013 at 17:19

9 votes

How to find memory usage by table?

answered Jun 14, 2013 at 14:35

9 votes

Transaction Log maintenance when switching to Simple Recovery

answered Jun 14, 2013 at 15:51

9 votes

Don't use a transaction for Stored Procedure

answered Jul 12, 2013 at 16:55

9 votes

Accepted

Options for Data Encryption in SQL Server 2008 R2 Standard Edition?

answered Sep 23, 2013 at 20:08

9 votes

Accepted

How to trace the exact query fired in sql server

answered Sep 7, 2013 at 15:00

9 votes

Restore exceeds licensed limit of 10240 MB per database. All I really need is the DB structure

answered May 8, 2013 at 18:25

9 votes

Accepted

Constraints based on other columns

answered May 18, 2013 at 3:21

9 votes

Backing up file groups with restore to earlier backup

answered May 21, 2013 at 16:04

9 votes

Accepted

Is there a limit to how many credentials SSMS can remember?

answered Jun 10, 2013 at 17:08

Stack Exchange Network

1,351 Answers

Getting database sizes on an MSSQL Server named instance

sql server max memory includes SSIS?

How can I convert a key in a SQL Server deadlock report to the value?

How to answer why suddenly we need indexes or query needs to be changed

In Sql Server, is there a way to check if a selected group of rows are locked or not?

Determine the SQL Server version and edition from the available set up, before actually installing it?

How to set Database Recover Mode to Full for all databases?

How can I Debug a Buffer Issue?

Recursive sql query performance issue

"truncate log on checkpoint" option in SQL Server

How to use an alias name that has RANK() OVER in a WHERE clause

Moving Databases to New Datacenters

Most useful stored procedures for a new DBA?

Best way to backup & truncate transaction logs on a schedule

Exclude databases from automatic full backup

Using the database engine tuning advisor - how do I generate the scripts for the recommendations?

Execution plan percentages don't add up to 100%

Can a plan "age" reach zero?

Instant File Initialization

How to reduce the number of things SQL Server puts in the windows event viewer?

Cannot rename the table because it is published for replication

How to find memory usage by table?

Transaction Log maintenance when switching to Simple Recovery

Don't use a transaction for Stored Procedure

Options for Data Encryption in SQL Server 2008 R2 Standard Edition?

How to trace the exact query fired in sql server

Restore exceeds licensed limit of 10240 MB per database. All I really need is the DB structure

Constraints based on other columns

Backing up file groups with restore to earlier backup

Is there a limit to how many credentials SSMS can remember?