Viewing 15 posts - 45,541 through 45,555 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 12:11 am
Sandy (7/21/2008)
to update database object...in system tables....in simple..
???
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 5:07 am
There are a couple links on this thread:
http://www.sqlservercentral.com/Forums/Topic537433-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 4:37 am
thegreatsamarth (7/21/2008)
U can do tht by using Cursors, as like:
Cursors = row based processing = slow.
SELECT ROW_NUMBER() OVER( PARTITION BY AccountNum ORDER BY AccountNum ) AS RowNumber,
Ramesh, isn't yours...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 4:36 am
Why do you think idle connections are a problem? All sleeping means is that there's currently nothing running.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 4:28 am
Maybe, maybe not
You need to look at the queries you are running and create indexes to support thos queries. Look at what columns you are regularly filtering on and create...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 4:23 am
Restricting SQL's memory is not going to solve timeouts. It will make them worse. The problem is that you have a lot of data and no (or very few) indexes...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 21, 2008 at 1:42 am
Viewing 15 posts - 45,541 through 45,555 (of 49,552 total)