Viewing 15 posts - 45,556 through 45,570 (of 49,571 total)
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...
July 22, 2008 at 12:35 am
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...
July 22, 2008 at 12:28 am
Michael Earl (7/21/2008)
July 22, 2008 at 12:23 am
I'm trying to figure out what you were trying to say there.
July 22, 2008 at 12:16 am
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...
July 22, 2008 at 12:16 am
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...
July 22, 2008 at 12:12 am
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...
July 22, 2008 at 12:11 am
Sandy (7/21/2008)
to update database object...in system tables....in simple..
???
July 22, 2008 at 12:04 am
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,...
July 22, 2008 at 12:03 am
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...
July 21, 2008 at 5:13 am
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...
July 21, 2008 at 5:07 am
There are a couple links on this thread:
http://www.sqlservercentral.com/Forums/Topic537433-149-1.aspx
July 21, 2008 at 4:47 am
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
July 21, 2008 at 4:46 am
Please post table structure, sample data and expected results. Thanks
See - http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 21, 2008 at 4:44 am
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...
July 21, 2008 at 4:37 am
Viewing 15 posts - 45,556 through 45,570 (of 49,571 total)