Sign in
|
Join
|
Help
Search
Ed Giardina's .NET Blog
Blogging about Hobbyist Adventures in C#, XNA, ASP.NET and other stuff
Home
Contact
About
RSS for Posts
Atom
RSS for Comments
Recent Posts
How fickle the SQL!
Tags
.NET
.NET activex ComVisible C# embedding windows forms
.NET transposition Crystal SQL
2005
Analysis Cubes
ASP.NET
C#
Copy Database
CSS
Data Binding
DataSet
date
days of the week
DrawableGameComponent
EnableConstraints
Event Handlers
GamerServicesComponent
GamerServicesDispatcher
GridView
Guide.ShowSignIn
intersection
SQL 2005
Visual Studio 2005
XNA
XNA 2.0
Community
Home
Blogs
Media
Email Notifications
Go
Ed's Stuff
Ed's Flickr Photos
Ed's Portfolio Page
Blogs I like
Shawn Hargreaves
I Hate Linux
Archives
July 2008 (1)
May 2008 (1)
February 2008 (1)
January 2008 (4)
October 2007 (1)
September 2007 (1)
August 2007 (1)
June 2007 (1)
May 2007 (1)
April 2007 (3)
March 2007 (2)
Browse by Tags
All Tags
»
SQL 2005
»
queries
(
RSS
)
days of the week
indexes
performance
How fickle the SQL!
So I was optimizing a query that displays a timetable of television programming. I'm working to try to optimize it because its currently taking 3-10 seconds per execution, which is less than optimal, considering that the query needs to be made 48...
Posted:
Sep 12 2007, 09:55 AM
by
Richthofen
| with
no comments
Filed under:
SQL 2005
,
indexes
,
queries
,
days of the week
,
performance