User Ionic

29 votes

Accepted

Benefits of SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

answered Jul 10, 2015 at 9:48

17 votes

Accepted

Is there any way to reduce/shrink tempdb.mdf size without restarting SQL Server

answered Jun 24, 2015 at 11:24

14 votes

Accepted

Syncing two databases in SQL Server

answered Jul 4, 2015 at 22:13

12 votes

Accepted

Accidentally change database name (SQL Server 2008)

answered Jun 19, 2015 at 11:54

10 votes

Accepted

Missing Index Not Displaying In Execution Plan

answered Jul 7, 2015 at 13:55

7 votes

SQL Server Database Not Shrinking

answered Jun 20, 2015 at 17:03

6 votes

SQL Server Configuration Manager shows no services

answered Jul 5, 2015 at 11:26

6 votes

Accepted

MySQL 1175 Error While Using Primary Keys

answered Jul 4, 2015 at 18:00

6 votes

Accepted

No service broker active on database

answered Jul 11, 2015 at 14:23

6 votes

SQL Server Slowdown?

answered Jul 15, 2015 at 13:43

4 votes

Finding the longest entries for a given column (nvarchar(100))

answered Jul 23, 2015 at 13:56

4 votes

Accepted

Importing via sqlcmd errors out

answered Jul 4, 2015 at 14:15

4 votes

Accepted

Single table or multiple table design when records have a clear distinction but are queried together?

answered Jul 4, 2015 at 16:30

4 votes

SQL Server: what is cleared by reboot?

answered Jun 18, 2015 at 14:57

4 votes

Accepted

Problems with sqlcmd -q and quotations marks

answered Jun 17, 2015 at 12:59

4 votes

SQL Server 2008 - combined index + other separate index on one column

answered Jun 18, 2015 at 9:02

3 votes

SQL Server DB becomes unusable overnight

answered Jul 1, 2015 at 16:43

3 votes

Sum of points and rank according to points

answered Jul 2, 2015 at 11:22

3 votes

Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060

answered Jul 3, 2015 at 10:04

3 votes

Multiple rows v/s multiple columns

answered Jun 23, 2015 at 18:31

2 votes

SQL Server 2008 R2 Memory Pressure

answered Jun 22, 2015 at 6:28

2 votes

Accepted

Intervals query of huge data

answered Jun 21, 2015 at 14:37

2 votes

Accepted

Unable to shrink log file due to snapshot replication

answered Jul 3, 2015 at 11:15

2 votes

SQL Server recreating plans each day

answered Jun 25, 2015 at 9:30

2 votes

SQL Server Database recovery from corrupt database

answered Jun 28, 2015 at 16:20

2 votes

How to set Persian calendar,currency,numbers,date and time and text in oracle database?

answered Jul 1, 2015 at 5:59

2 votes

How to find what frequent and/or large transaction have taken place in MS SQL Server?

answered Jun 15, 2015 at 13:17

2 votes

Accepted

Exporting tables from SQL Server

answered Jun 17, 2015 at 11:20

2 votes

Accepted

Local SSMS client is not connecting one particular server

answered Jul 9, 2015 at 16:14

2 votes

Accepted

SQL Server suggestion to create nonclustered index - on 2 columns, reversed

answered Jul 6, 2015 at 20:51

Stack Exchange Network

52 Answers

Benefits of SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

Is there any way to reduce/shrink tempdb.mdf size without restarting SQL Server

Syncing two databases in SQL Server

Accidentally change database name (SQL Server 2008)

Missing Index Not Displaying In Execution Plan

SQL Server Database Not Shrinking

SQL Server Configuration Manager shows no services

MySQL 1175 Error While Using Primary Keys

No service broker active on database

SQL Server Slowdown?

Finding the longest entries for a given column (nvarchar(100))

Importing via sqlcmd errors out

Single table or multiple table design when records have a clear distinction but are queried together?

SQL Server: what is cleared by reboot?

Problems with sqlcmd -q and quotations marks

SQL Server 2008 - combined index + other separate index on one column

SQL Server DB becomes unusable overnight

Sum of points and rank according to points

Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060

Multiple rows v/s multiple columns

SQL Server 2008 R2 Memory Pressure

Intervals query of huge data

Unable to shrink log file due to snapshot replication

SQL Server recreating plans each day

SQL Server Database recovery from corrupt database

How to set Persian calendar,currency,numbers,date and time and text in oracle database?

How to find what frequent and/or large transaction have taken place in MS SQL Server?

Exporting tables from SQL Server

Local SSMS client is not connecting one particular server

SQL Server suggestion to create nonclustered index - on 2 columns, reversed