Strangenut
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
SQL Server Blog
»
All Tags
»
beginner
»
performance tuning
(
RSS
)
Browse by Tags
SQL Server Blog
Home
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
Making the case for stored procedures
What is a table scan?
Tags
beginner
c#
CLR Stored Procedures
database
IIS7
Indexes
performance tuning
query execution plans
scott gu
silverlight
SQL Server
stored procedure
T-SQL
xaml
View more
News
Why don't you take a few minutes to join Strangenut, I'm trying to build an interactive community and would love to have your feedback on what I write and suggestions and questions I can answer! It's free, I won't spam you, and won't sell your address to anyone!
Programming
Scott Gu's Blog
DotNetSlackers
VisitMIX
Archives
December 2008 (1)
November 2008 (1)
October 2008 (3)
August 2008 (1)
July 2008 (1)
June 2008 (1)
May 2008 (1)
April 2008 (6)
February 2008 (3)
database
Indexes
query execution plans
SQL Server
stored procedure
T-SQL
Making the case for stored procedures
On a few of the mailing lists I am on for developers (primarily ones related to web development), there is a recurring topic that always gets people into rather heated debates: to use stored procedures or prepared statements? Now, either one you choose...
Published
Sun, Oct 10 2008 2:23 AM
by
dacrowlah
Filed under:
query execution plans
,
T-SQL
,
performance tuning
,
database
,
SQL Server
,
beginner
,
stored procedure
What is a table scan?
In the world of RDBMS' you may hear the term "table scan" thrown around, this is a term used to describe an event that occurs when you search for data in a table, and your query either doesn't take advantage of an existing index, or...
Published
Sun, Feb 02 2008 7:18 PM
by
dacrowlah
Filed under:
query execution plans
,
performance tuning
,
SQL Server
,
Indexes
,
beginner