Darin Strait's user avatar
Darin Strait's user avatar
Darin Strait's user avatar
Darin Strait
  • Member for 12 years, 1 month
  • Last seen more than 3 years ago
18 votes
Accepted

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

11 votes

Handling growing number of Tenants in Multi-tenant Database Architecture

9 votes

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

9 votes
Accepted

UPDATE Statistics with full scan

8 votes

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

7 votes

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

7 votes

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

7 votes
Accepted

RSync Database File Deltas in SQL Server 2008

7 votes
Accepted

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

6 votes

Automation of backups of Large Number of Database

6 votes
Accepted

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

6 votes
Accepted

Mitigate negative effects of shrinking

4 votes
Accepted

Get Total in a single line in SQL Server

4 votes

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

3 votes
Accepted

Get statistics of open connection to linked servers

3 votes

Performance difference between SQL Server Linked Server and direct query

3 votes

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

3 votes

SQL Server stored procedure keeps restoring to previous one

3 votes
Accepted

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

3 votes
Accepted

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

3 votes

SQL Server replication for off site copy

3 votes

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

2 votes

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

2 votes

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

2 votes

32-bit ODBC driver on 64-bit SQL Server

2 votes

SQL server 2000 transactions with the same time

2 votes

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

2 votes

Create a linked server with SQL Server 2012 x64

2 votes

SQL Server Job logging best practice

2 votes

Verify all Stored Procedures