It really depends, on the query, on the selectivity of the column that defines the leading edge of the index... Generally, if the criteria that defines the index scan in...

Maybe I don't understand the question. Are you looking for cool things to do with it?

Here are some examples and explanations that I found useful:

http://sqlblog.com/blogs/allen_white/archive/tags/PowerShell/default.aspx

http://blogs.msdn.com/mwories/archive/2008/06/14/SQL2008_5F00_Powershell.aspx

http://blogs.technet.com/industry_insiders/pages/powershell-in-sql-server-2008.aspx

If you must do this, parameterize the query and use sp_executesql. You can then capture output parameters. Something like this:

DECLARE @sql NVARCHAR(MAX)

DECLARE @count INT

DECLARE @tablename NVARCHAR(MAX)

SET @tablename = N'TestTable'

SET @sql...

Powershell is, to all intents and purposes, the replacement for the DOS prompt. What it really is though, is a very extensive scripting language that allows you to take direct...

You can associate a table or an index with a filegroup. This allows you to control placement on various disks, setting groups to be read only, backing up by group....

The problem is, the error isn't some little connection error or a tsql error. The program isn't initializing. You've got something mucked up at a low level.

More often than not, locking is handled just fine by SQL Server. Don't start adding lock hints until you run into a problem, and possibly, not even then. Usually adjusting...

Honestly, try reinstalling.

It'll take me a while to dig it out of the archives, but we found a situation a few years ago that showed it wasn't all that hard for a...

Oh man, I missed that article. Great job. Sweet solution. Here I was going to suggest possibly using XML depending on the size of the array. Never mind.

Do what...

Or, since it's not always possible to capture a transaction while it's open, use Profiler to set up a trace and capture the output from your procedures to a file....

I have not. I do know a consultant that's worked in that range. You should give Andy Novick a call. Here's his web site: http://www.novicksoftware.com/%5B/url%5D

There isn't a "right" number for a lot of these values. It really depends on the system you're on. Simply collecting one set of values is usually not enough. We...

I can't recommend enough that you develop in 2005. Work you do on a 2000 box might not work in 2005 and there are a ton of things you can...

Tons to learn then.

First, make sure you've got a good backup strategy in place. Before you worry about monitoring and all that stuff, protect your data.

Also, you should schedule a...