SqlServerKudos - Upcoming stories

Upcoming

atom rss
1
kudos
spam Kudos Remove

Performance impact: Linked server security configuration and how it can hurt you
posted by sasa 370 days, 13 hours, 20 minutes ago
Sunday, July 26, 2009 6:38:40 AM GMT
Performance impact: Linked server security configuration and how it can hurt you
If you change the security configuration of a linked server from using login UserA to login UserB, would you expect that to significantly impact the performance of a query that uses the linked server, assuming that both users have permission to select from the remote table referenced in the query?   Many people probably would answer no. After all, as long as the connection has the permission to access the remote table, how the connection is authenticated should not matter, right? Well, it’s more compli... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Performance
2
kudos
spam Kudos Remove

Kevin Kline : Why Do I Keep Seeing This Mistake?
posted by sasa 370 days, 13 hours, 23 minutes ago
Sunday, July 26, 2009 6:35:38 AM GMT
Kevin Kline : Why Do I Keep Seeing This Mistake?
One of the fundamentals of loop optimization is that you should move stable operations outside of the loop.  What I want to know is - if this is such a fundamental rule, why do so many people break it?!? If you are familiar with other programming languages, then you are probably aware of loop optimization techniques. You should try to put all operations outside of the loop if they don’t need to change within the loop. This reduces the amount of unnecessary repetitive work. SQL Server optimizer doesn’t... (more)
category: Query | clicked: 2 | 1 comment | | source: sqlblog.com
tags: Optimization, Performance, REPLICATE