Probably not much. You'll still get a clustered index scan (cause there's no other way to get those rows), the optimiser will just know more accuratly how many rows will...

The problem is that there are no absolute hard and fast rules for indexing. It depends on the queries been run and the data.

Could you post some sample code, table...

Michael Earl (7/21/2008)

---

From the CLR, you can do this, but I think you have to run it as unsafe to create a new thread. Also, the context connection is...

I'm trying to figure out what you were trying to say there.

Not in SQL 2005. In 2008, the resource governor can do that. Best way to stop a query from hogging the system is to rewrite it in an optimal way...

If possible, please post the table definition as a CREATE Table and the sample data as insert statements. It really helps when trying to test a query to see if...

Maybe. It shouldn't harm (unless you do a sampled update right after an index rebuild). It may or may not help.

How often do you rebuild the indexes on that table?

Grant...

???

Disk queue length isn't that great a counter to watch. SQL can and will drive it high with read-ahead reads and if you're on a SAN it's hard to interpret

Personally,...

There usually isn't an advantage. SQL will automatically create single-column statistics on columns it thinks that is useful.

While there can be a use in creating multi-column statistics so that the...

For server-level permissions, you can query sys.server_permissions and sys.server_principals thusly

SELECT NAME, permission_name, state_desc

FROM sys.server_permissions sp

INNER JOIN sys.server_principals pri ON sp.grantee_principal_id = pri.principal_id

For...

There are a couple links on this thread:

http://www.sqlservercentral.com/Forums/Topic537433-149-1.aspx

Could you perhaps post a couple of the table structures, so we have a better idea what we're talking about. Also, if possible that proc that you're working on.

Thanks

Please post table structure, sample data and expected results. Thanks

See - http://www.sqlservercentral.com/articles/Best+Practices/61537/

I know about that, you didn't mention the single user mode last time. Hence the comment that the DAC alone is not sufficient to update system tables.

Also, while it is...