SqlServerKudos - Stories tagged with Performance

Performance

atom rss
1
kudos
spam Kudos Remove

Bin packing part 4: The set-based disaster
published 1030 days, 20 hours, 47 minutes ago posted by sasa 1031 days, 5 hours, 53 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:24:04 AM GMT
Bin packing part 4: The set-based disaster
Almost a year ago now, I started a series of blog post on the bin packing problem. But after the first three posts, various reasons caused the research I still had to do for the fourth part to be massively delayed. It’s only now that I have finally found the time to finish my research and write up the fourth installment.   After a nine-month delay, I can hardly expect you to remember what I covered in the first posts, so you may want to follow these links to re-read that: ·        The first post inclu... (more)
category: Management | clicked: 1 | comment | | source: sqlblog.com
tags: Performance
1
kudos
spam Kudos Remove

Forced Parameterization: A Turbo Button?
published 1030 days, 20 hours, 47 minutes ago posted by sasa 1031 days, 6 hours, 6 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:11:27 AM GMT
Forced Parameterization: A Turbo Button?
Forced Parameterization: A Turbo Button? I never had the need to turn on the PARAMETERIZATION FORCED database option until this week.We pretty much use only stored procedures for our internal applications so the execution plans are almost always in cache and reused.This practice of using parameterized stored procedure calls, together with attention to detail in query and index tuning, allows us to comfortably handle several thousand requests per second on commodity hardware without taking special measur... (more)
category: Management | clicked: 0 | comment | | source: weblogs.sqlteam.com
tags: Performance
1
kudos
spam Kudos Remove

Spatial Indexes and ANSI JOIN - ON syntax
published 1030 days, 20 hours, 47 minutes ago posted by sasa 1031 days, 6 hours, 17 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:00:31 AM GMT
Spatial Indexes and ANSI JOIN - ON syntax
During a talk about spatial indexes and performance last week, I was surprised by a question about using ANSI-92 JOIN - ON syntax in spatial queries. I'd coded: SELECT * FROM geonames.dbo.geonames g JOIN Sample_USA.dbo.Counties c ON g.GEOG.STIntersects(c.geog) = 1 WHERE c.ID = 1569 (more)
category: Query | clicked: 0 | comment | | source: www.sqlskills.com
tags: Performance, Spatial
Previous 1 2 3 4 5 6 Next