Strangenut
Sign in
|
Join
|
Help
Home
Blogs
Media
Forums
Groups
SQL Server Blog
»
All Tags
»
Indexes
(
RSS
)
Browse by Tags
SQL Server Blog
Home
Contact
Syndication
RSS for Posts
Atom
RSS for Comments
Email Notifications
Go
Recent Posts
SQL Server 2000/2005/2008 UDF to return a csv list of values from a query
How to create a table with a non clustered primary key in SQL Server 2000 2005 and 2008
Changing a clustered primary key to non-clustered in SQL Server 2000/2005/2008
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
tips and tricks
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
January 2010 (1)
June 2009 (1)
February 2009 (1)
January 2009 (3)
December 2008 (1)
November 2008 (1)
October 2008 (3)
August 2008 (1)
July 2008 (1)
June 2008 (1)
May 2008 (1)
April 2008 (5)
February 2008 (3)
beginner
database
performance tuning
query execution plans
SQL Server
tips and tricks
T-SQL
SQL Server 2000/2005/2008 UDF to return a csv list of values from a query
Today I had to do a common task that I've done several times, but suddenly realized I should put up here, because its a fairly common issue. Say you have TableA has a one to many relationship to TableB, and you want all of the values in TableB.dbo...
Published
Thu, Jun 06 2009 1:22 PM
by
dacrowlah
Filed under:
T-SQL
,
database
,
SQL Server
,
Indexes
,
tips and tricks
How to create a table with a non clustered primary key in SQL Server 2000 2005 and 2008
Unless otherwise specified when you create your tables primary key in SQL Server 2000, 2005 and 2008 will have a clustered index on it. This will be a good default choice if you are going to be joining other tables together on this value. If you are going...
Published
Sat, Jan 01 2009 2:54 PM
by
dacrowlah
Filed under:
T-SQL
,
database
,
SQL Server
,
Indexes
Changing a clustered primary key to non-clustered in SQL Server 2000/2005/2008
By default, when you create a primary key column in SQL Server, it makes it a clustered index. Sometimes this will be a default advantage, sometimes a serious disadvantage for performance as clustered indexes are the cornerstone of performance tuning...
Published
Sun, Jan 01 2009 9:25 PM
by
dacrowlah
Filed under:
T-SQL
,
performance tuning
,
database
,
SQL Server
,
Indexes
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