User StanleyJohns

35 votes

Accepted

About single threaded versus multithreaded databases performance

answered May 26, 2011 at 15:41

14 votes

What are the top 3 performance Issues that you encounter with your SQL Servers?

answered Aug 10, 2011 at 5:53

13 votes

How can I move a database from one server to another?

answered May 25, 2011 at 19:52

12 votes

Suggestion for Large SQL Server Database Design

answered Jun 2, 2011 at 16:58

11 votes

Accepted

When should nonclustered indexes be stored on separate filegroups?

answered May 10, 2011 at 17:34

10 votes

Accepted

Trimming down a big SQL Server database

answered Jun 16, 2011 at 13:07

10 votes

Accepted

Is Oracle more demanding environment for a DBA than SQL Server?

answered Aug 21, 2011 at 18:04

9 votes

Accepted

Where to look for a bottleneck after elimitating CPU, memory, and disk

answered Oct 1, 2011 at 4:05

9 votes

Accepted

Database Users and Server Logins and the Mapping between them

answered Aug 16, 2011 at 13:45

8 votes

Accepted

Notification on long-running query or deadlock in SQL Server 2008 R2?

answered Aug 27, 2011 at 12:03

8 votes

Is ROLLBACK a fast operation?

answered Aug 31, 2011 at 13:17

8 votes

How can I tell if my SQL Server DB performance is hardware-limited?

answered Jun 11, 2011 at 11:57

8 votes

Accepted

How do I rescue SQL Agent jobs from a set of detached master, model, mdb files?

answered Feb 12, 2012 at 1:56

7 votes

How to deny drop permission for a table?

answered Mar 30, 2012 at 15:19

6 votes

SQL Server 2012 backward compatibility for backups with 2008

answered Mar 27, 2012 at 20:27

6 votes

Accepted

Upper or Lower Case Optimisation on MS SQL Server

answered Mar 30, 2012 at 14:15

6 votes

Accepted

Restore database - maintenance plan task

answered Jul 27, 2013 at 16:14

6 votes

Testing stored procedure scalability

answered Sep 15, 2011 at 23:50

6 votes

Safely deleting a SQL Server log file (.LDF)

answered Feb 23, 2012 at 21:00

6 votes

Storing arrays of integers in database (for efficient select)

answered Jun 27, 2011 at 15:27

6 votes

Recommended page file size for SQL 2008R2 on Windows 2008R2

answered Jun 15, 2011 at 18:13

6 votes

Accepted

Windows Storage Server, SQL Server, regular files -- means to protect from insider threats?

answered Jul 8, 2011 at 8:42

6 votes

Accepted

Database appearing in one tool but not another

answered Apr 20, 2011 at 9:39

6 votes

How is LIKE implemented?

answered Apr 14, 2011 at 23:45

5 votes

Accepted

MS Access displays alle columns in SQL Server tables as "deleted"

answered Jun 6, 2011 at 14:14

5 votes

Insert if not exists, concurrently

answered Feb 18, 2012 at 3:58

5 votes

Accepted

Moving a database to a new server

answered Aug 3, 2013 at 13:22

5 votes

Why are periodic restarts required to keep my instance performing well?

answered Apr 4, 2012 at 2:39

4 votes

Accepted

What is the use of creating full text catalog in full text indexing

answered Apr 13, 2012 at 5:24

4 votes

How do I troubleshoot loss of connection with SQL server

answered Apr 17, 2012 at 4:25

Stack Exchange Network

187 Answers

About single threaded versus multithreaded databases performance

What are the top 3 performance Issues that you encounter with your SQL Servers?

How can I move a database from one server to another?

Suggestion for Large SQL Server Database Design

When should nonclustered indexes be stored on separate filegroups?

Trimming down a big SQL Server database

Is Oracle more demanding environment for a DBA than SQL Server?

Where to look for a bottleneck after elimitating CPU, memory, and disk

Database Users and Server Logins and the Mapping between them

Notification on long-running query or deadlock in SQL Server 2008 R2?

Is ROLLBACK a fast operation?

How can I tell if my SQL Server DB performance is hardware-limited?

How do I rescue SQL Agent jobs from a set of detached master, model, mdb files?

How to deny drop permission for a table?

SQL Server 2012 backward compatibility for backups with 2008

Upper or Lower Case Optimisation on MS SQL Server

Restore database - maintenance plan task

Testing stored procedure scalability

Safely deleting a SQL Server log file (.LDF)

Storing arrays of integers in database (for efficient select)

Recommended page file size for SQL 2008R2 on Windows 2008R2

Windows Storage Server, SQL Server, regular files -- means to protect from insider threats?

Database appearing in one tool but not another

How is LIKE implemented?

MS Access displays alle columns in SQL Server tables as "deleted"

Insert if not exists, concurrently

Moving a database to a new server

Why are periodic restarts required to keep my instance performing well?

What is the use of creating full text catalog in full text indexing

How do I troubleshoot loss of connection with SQL server