User Darin Strait

2 votes

Is it OK to create hundreds of databases in SQL Azure versus one big one and run the risk of deadlocking

answered May 4, 2012 at 13:12

2 votes

Select from linked server to local server causing waits on both sides

answered Sep 28, 2012 at 14:32

3 votes

How do you create a job in SQL server 2008 R2 that will clear transaction logs?

answered Sep 3, 2014 at 14:18

1 vote

Using existing SQL Server credentials for log shipping reporting purposes

answered Jun 25, 2014 at 10:53

1 vote

Change server name for SQLLocalDB instance

answered Jun 10, 2013 at 12:40

2 votes

Running a DELETE stored procedure but finding degradation in performance in WHILE loop as iterations increase

answered Jun 7, 2013 at 12:28

1 vote

SSRS Deployment

answered May 2, 2013 at 13:25

0 votes

DB comparer field by field for all tables

answered May 2, 2013 at 13:16

1 vote

How to take SQL Server database under this scenario?

answered Apr 17, 2013 at 10:47

3 votes

SQL Server replication for off site copy

answered Feb 14, 2013 at 16:10

0 votes

Identify NON-ANSI joins in SQL Server 2008 R2 on a Database that's in 2000 (80) compatibility mode

answered Feb 12, 2013 at 15:05

2 votes

32-bit ODBC driver on 64-bit SQL Server

answered Feb 10, 2013 at 23:16

0 votes

2 databases in sql server 2005 "Production Server"

answered Jan 31, 2013 at 16:05

1 vote

SQL Server Database Synchronization

answered Jan 23, 2013 at 23:03

2 votes

SQL server 2000 transactions with the same time

answered Jan 22, 2013 at 14:35

1 vote

SQL Server 2008: Diff table data on different servers with exact schema

answered Jan 10, 2013 at 17:50

2 votes

Verify all Stored Procedures

answered Jan 10, 2013 at 17:23

2 votes

SQL Server Job logging best practice

answered Dec 31, 2012 at 2:49

2 votes

Create a linked server with SQL Server 2012 x64

answered Nov 3, 2012 at 16:07

1 vote

Storing terabytes of data in SQL Server

answered Oct 31, 2012 at 19:31

3 votes

Accepted

How do I connect to a database which is a linked server via ODBC?

answered Oct 19, 2012 at 12:47

0 votes

SQL Server 2008 datetime index performance bug

answered Oct 10, 2012 at 21:09

1 vote

Deprecating SQL Server, need to redirect clients to new server

answered Sep 24, 2012 at 15:45

1 vote

SQL server moved, now can't use as linked server

answered Sep 12, 2012 at 16:41

0 votes

Multiple schema or multiple databases for better performance

answered Sep 8, 2012 at 17:55

0 votes

Shrink database is not shrinking as much as expected on a 1.5 TB database.

answered Sep 6, 2012 at 16:03

1 vote

After server move a query doesn't work anymore

answered Sep 5, 2012 at 12:46

8 votes

Is it possible to increase query performance on a narrow table with millions of rows?

answered Aug 31, 2012 at 14:52

-3 votes

Parallel Statistics Update

answered Jul 4, 2012 at 13:25

3 votes

Accepted

Would it be possible/wise to execute 2 parallel restores from a single backup?

answered Jun 27, 2012 at 10:10

Stack Exchange Network

58 Answers

Is it OK to create hundreds of databases in SQL Azure versus one big one and run the risk of deadlocking

Select from linked server to local server causing waits on both sides

How do you create a job in SQL server 2008 R2 that will clear transaction logs?

Using existing SQL Server credentials for log shipping reporting purposes

Change server name for SQLLocalDB instance

Running a DELETE stored procedure but finding degradation in performance in WHILE loop as iterations increase

SSRS Deployment

DB comparer field by field for all tables

How to take SQL Server database under this scenario?

SQL Server replication for off site copy

Identify NON-ANSI joins in SQL Server 2008 R2 on a Database that's in 2000 (80) compatibility mode

32-bit ODBC driver on 64-bit SQL Server

2 databases in sql server 2005 "Production Server"

SQL Server Database Synchronization

SQL server 2000 transactions with the same time

SQL Server 2008: Diff table data on different servers with exact schema

Verify all Stored Procedures

SQL Server Job logging best practice

Create a linked server with SQL Server 2012 x64

Storing terabytes of data in SQL Server

How do I connect to a database which is a linked server via ODBC?

SQL Server 2008 datetime index performance bug

Deprecating SQL Server, need to redirect clients to new server

SQL server moved, now can't use as linked server

Multiple schema or multiple databases for better performance

Shrink database is not shrinking as much as expected on a 1.5 TB database.

After server move a query doesn't work anymore

Is it possible to increase query performance on a narrow table with millions of rows?

Parallel Statistics Update

Would it be possible/wise to execute 2 parallel restores from a single backup?