I remember from my Sybase days that SQL Server tables could support up to 255 indexes. One clustered index and 254 non-clustered indexes. In Microsoft SQL Server that changed to just 249 non ...

So for a table with nine non-clustered indexes on it there are 10 writes ... do my end users care that it's slowing my SQL Server down? The answer here is probably not, unless there's a really ...

mounts the LUNs on another SQL server (outside the cluster), attaches databases, runs verification, then unmaps and destroys the clones. Don't use MSCS. Use SQL replication. I've been running MSCS ...

Take a backup and delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Cluster 8. In the TCP/IP properties in the configuration Manager change “Listen All” to YES 9.

Among the issues for SQL Server is the need to use shared storage for Always On Failover Cluster Instances. This is a problem for two reasons. First, shared storage in the form of a storage area ...

In fact, a view really doesn’t do anything until you query it. In SQL Server 2000 and 2005, you have the ability to add indexes to views. But, if a view is just a stored query definition in the ...