User Darin Strait

18 votes

Accepted

How do I run a large script with many inserts without running out of memory?

answered Apr 19, 2012 at 14:27

11 votes

Handling growing number of Tenants in Multi-tenant Database Architecture

answered Apr 19, 2012 at 13:44

9 votes

Which PowerShell technique should I use to talk to SQL Server?

answered May 3, 2012 at 23:20

9 votes

Accepted

UPDATE Statistics with full scan

answered Jun 15, 2012 at 20:52

8 votes

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

answered Aug 31, 2012 at 14:52

7 votes

Should I migrate data using detach/copy/attach or through backup-restore-replay?

answered May 30, 2012 at 19:27

7 votes

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

answered Apr 3, 2012 at 23:44

7 votes

Accepted

RSync Database File Deltas in SQL Server 2008

answered Apr 12, 2012 at 16:39

7 votes

Accepted

Is there any benefit to having one sql server login for multiple users?

answered Apr 12, 2012 at 19:01

6 votes

Automation of backups of Large Number of Database

answered Apr 18, 2012 at 14:39

6 votes

Accepted

What is the best approach to parsing a large amount of strings?

answered Feb 22, 2012 at 18:14

6 votes

Accepted

Mitigate negative effects of shrinking

answered May 25, 2012 at 17:18

4 votes

Accepted

Get Total in a single line in SQL Server

answered Apr 19, 2012 at 12:11

4 votes

SQL Server 2005 tempdb Time out occurred while waiting for buffer latch type 4 (pagenum)

answered Jul 29, 2011 at 13:37

3 votes

Accepted

Get statistics of open connection to linked servers

answered Feb 22, 2012 at 17:40

3 votes

Performance difference between SQL Server Linked Server and direct query

answered Feb 22, 2012 at 17:50

3 votes

Creating a test database from Production database (different machines & servers)

answered May 29, 2012 at 22:21

3 votes

SQL Server stored procedure keeps restoring to previous one

answered May 30, 2012 at 17:05

3 votes

Accepted

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

answered Jun 27, 2012 at 10:10

3 votes

Accepted

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

answered Oct 19, 2012 at 12:47

3 votes

SQL Server replication for off site copy

answered Feb 14, 2013 at 16:10

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

2 votes

Looking for example design of using an SQL database as a queue for throttling web service requests of multiple users

answered May 3, 2012 at 13:15

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

2 votes

32-bit ODBC driver on 64-bit SQL Server

answered Feb 10, 2013 at 23:16

2 votes

SQL server 2000 transactions with the same time

answered Jan 22, 2013 at 14:35

2 votes

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

answered Sep 28, 2012 at 14:32

2 votes

Create a linked server with SQL Server 2012 x64

answered Nov 3, 2012 at 16:07

2 votes

SQL Server Job logging best practice

answered Dec 31, 2012 at 2:49

2 votes

Verify all Stored Procedures

answered Jan 10, 2013 at 17:23

Stack Exchange Network

58 Answers

How do I run a large script with many inserts without running out of memory?

Handling growing number of Tenants in Multi-tenant Database Architecture

Which PowerShell technique should I use to talk to SQL Server?

UPDATE Statistics with full scan

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

Should I migrate data using detach/copy/attach or through backup-restore-replay?

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

RSync Database File Deltas in SQL Server 2008

Is there any benefit to having one sql server login for multiple users?

Automation of backups of Large Number of Database

What is the best approach to parsing a large amount of strings?

Mitigate negative effects of shrinking

Get Total in a single line in SQL Server

SQL Server 2005 tempdb Time out occurred while waiting for buffer latch type 4 (pagenum)

Get statistics of open connection to linked servers

Performance difference between SQL Server Linked Server and direct query

Creating a test database from Production database (different machines & servers)

SQL Server stored procedure keeps restoring to previous one

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

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

SQL Server replication for off site copy

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

Looking for example design of using an SQL database as a queue for throttling web service requests of multiple users

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

32-bit ODBC driver on 64-bit SQL Server

SQL server 2000 transactions with the same time

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

Create a linked server with SQL Server 2012 x64

SQL Server Job logging best practice

Verify all Stored Procedures