Interesting, indeed.  No, there is no acceptable maximum for index scans.  I'm not sure where you could come up with a number like 977 per second. 

Can you cite the...

All of it.  heh.

So far I'm not putting much load on any of them. 

You can change the affinity mask in the SQL server properties, BUT:

You still need to license every CPU that is accessible to the operating system on which SQL server is...

Ashok,

Are you trying to say that currently you are using dynamic SQL and want to know how to use SProcs?

jg

It's there to confuse.  I once had a problem where the programmer used =+ where he meant += in some c# code. 

That was a hard one to find, because it...

Which is not true if I pick option 2 below...

>> Back up locally and then copy or move to the network share.

Still don't follow.  You are still using the same "packet" thingys when you copy the file.  So there is an equal chance for a dropped packet to cause corruption.

Now add...

Robert,

Can you elaborate on that a little?  I'm not sure I understand.  It would seem to me that the method you suggest would be more likely to intorduce corruption, due...

Hi Nelson,

What provider are you using for the linked server?  Are you using MSDASQL connected to a client ODBC DSN?

Or are you using an OLEDB provder for AS400 directly in the...

Good luck!  I would review to make sure that you have followed all of the pre-requisites exactly before attempting the install.  If one tiny thing is out of whack, you...

I assume that the C: drive is local to the cluster node(s), and it is the location of the OS files, WINDOWS directory, etc.   It is not a resource that...

Hi,

The installer for SQL server is "cluster-aware" and will set up the SQL server resources for you.

It's been a while since I've installed a cluster, so I'm not going to try...

Hi,

The physical disk resources (Drive letters) that contain SQL server data files must be:

1.        A resource in the same resource group as the SQL Server resource

2.        A dependency of the...

Hi,

Assuming you understand the impact, you might try a DBCC DROPCLEANBUFFERS and re-run the DBCC CHECKDB.  I've had to do that with an MSA1000 SAN until I could upgrade the...

Colin,

I'm not sure I follow this line of reasoning.  It is exactly a poorly-performing query that makes a good candidate for an indexed view.

If there is a complicated bunch of transformations...