Our entire enterprise is running on TCP/IP connections (I suspect most are these days). If you can connect to your SQL Server instance and run 'SELECT * FROM SomeTable', then...

It's possible that it could be as problematic as anything else, but you might try dropping & recreating the index. That will also remove fragmentation. The Storage Engine team at...

Sounds like heaven. We're trying to convince our bosses to let us telecommute regularly (we're able to do it now on snow days or when the cable company is coming...

Sorry, it was joke. Jeff asked how to...

We've found the fastest way is to export from one database out to an SSIS RAW file and then back into the next database in the next server. Storing the...

Because we use DBPro (aka DataDude) I do a lot of TSQL programming in Visual Studio. It's not terribly good, but the integration with TFS & DBPro makes it necessary.

You will have to pass them in for a SQL guide.

Here's an example:

EXEC sp_create_plan_guide @name = N'APlanGuide',

@stmt = N'SELECT * FROM [Person].[Address] WHERE [City] = @0',...

You call out of TSQL to WMI process to launch a .NET app... right?

But the constant updates from a single spid that is always connected won't act like a transaction & hold that lock open? Just asking, not arguing.

DonaldW (4/9/2008)

Mike Menser (4/9/2008)

DonaldW (4/9/2008)

It is as far as I'm concerned. If I don't tick people off on a regular...

Our starter questions are:

What's the difference between a clustered & non-clustered index?

What's the difference between blocking & deadlocking?

How do you trap errors in SQL Server 2005?

What does the NOLOCK hint...

But you don't need to read data from that table while it's running do you? It looks like, from what you have, that it's going to lock at least a...

There are two that I've been able to work with well. Idera's SQLScaler and Quest's Benchmark Factory. Either one should be able to do what you need. Although I honestly...

Perks? I thought it was the job definition!

You've got a list of parameters inside the query. You should run your query through sp_get_query_template which will give you the correct output and the list of parameters as it...