Skip to main content
Jimbo's user avatar
Jimbo's user avatar
Jimbo's user avatar
Jimbo
  • Member for 12 years, 9 months
  • Last seen more than a month ago
6 votes

Can I launch a stored procedure and immediately return without waiting for it to finish?

5 votes

SQL Server database size didn't decrease after deleting large number of rows.

5 votes

CXPACKET Waits performance tune for SQL Server 2008

5 votes

Is there a reason to update statistics manually?

4 votes
Accepted

Managing Sql Server 2012 Standard Edition

3 votes

Is there any benefit to defragmenting SQL indexes in a SAN environment?

3 votes

Select query according to date

3 votes

Consistency errors for a SharePoint database

3 votes

Syncing Database for Server Transition

3 votes

UPDATE with JOIN on 100mm records, how to do this better? (in T-SQL)

3 votes
Accepted

How are foreign keys resolved when creating tables in batch?

2 votes

What is the easiest way to use a SQL Server backup to retrieve just a few rows?

2 votes

Scheduled backup task doesn't always backup all databases despite always saying job successful

2 votes

Same tables with same data, different SQL Server stored procedure performance

2 votes

Parallelism Best Practices

1 vote

SQL Server 2008 Maintenance Plan Failure

1 vote

Modifying table structure within a transaction?

1 vote

Loading a FACT table per day

1 vote

Greater than operator ignoring a nonclustered index?

1 vote

Deadlock on insert for a table with an insert trigger that updates column in same triggered table

1 vote

Why is SQL running the same query longer from another connection?

1 vote

Database reporting alerts

1 vote

How to trigger an action without using triggers

0 votes

SQL Query too slow on SUM function

0 votes

Best solution to fixing database design with GUID as primary key

0 votes
Accepted

Advice for designing a complex/multipart application

0 votes

Storing terabytes of data in SQL Server

0 votes

Fast XML, slow XML

0 votes

How to update SQL Server 2012 from Evalutation to Developer edition?

0 votes

Space Consumption for SQL Index Rebuild