Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Choose a tag below, or browse popular content:
Administration
Editorial - MP3
Performance Tuning
SQL Server 7, 2000
Career
Editorial - WMV
Programming
T-SQL
Editorial
Miscellaneous
Security
Video
Editorial - iPod
Other
SQL Server 2005
Popular Articles
Introduction to Indexes
Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing.
Read more...
By
Gail Shaw
2009/10/26
|
Source:
SQLServerCentral.com
|
Category:
Indexing
Rating:
|
Discuss
|
Briefcase
|
21,915 reads
Free Tools for the SQL Server DBA Part 2
After a very popular first article on tools for the DBA, David Bird is back with a list of some utilities you might find very handy for working with SQL Server.
Read more...
By
David Bird
2008/12/04
|
Source:
SQLServerCentral.com
|
Category:
Tools
Rating:
|
Discuss
|
Briefcase
|
64,956 reads
ROW_NUMBER(): An Efficient Alternative to Subqueries
The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.
Read more...
By
Francis Rodrigues
2009/05/12
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
36,789 reads
How To Get Table Row Counts Quickly And Painlessly
Use sysindexes\DMVs insead of select count(*) to retreive table row counts
Read more...
By
Kendal Van Dyke
2009/09/02
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
22,630 reads
Introduction to Indexes: Part 2 – The clustered index
In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.
Read more...
By
Gail Shaw
2009/11/11
|
Source:
SQLServerCentral.com
|
Category:
Indexing
Rating:
|
Discuss
|
Briefcase
|
13,255 reads
REPLACE Multiple Spaces with One
Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method for replacing multiple spaces from MVP Jeff Moden.
Read more...
By
Jeff Moden
2009/11/16
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
12,452 reads
Map IP Address to a Geographical Location
Find the country, region and city of a user from an IP address using SQL Server. Oscar Garcia provides some code and resources if you want to dig into your analytics on your own.
Read more...
By
Oscar D Garcia
2009/07/09
|
Source:
SQLServerCentral.com
|
Category:
SQL Server
Rating:
|
Discuss
|
Briefcase
|
18,528 reads
How to Connect to a SQL 2005 Server When You Are Completely Locked Out
If you need to connect to a SQL server and don't have the 'sa' password plus the builtin\administrators account has been removed then Rudy Panigas shows us what you need to know.
Read more...
By
Rudy Panigas
2009/11/03
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
13,266 reads
Twenty tips to write a good stored procedure
This article will provide some useful information to write a SP. I have emphasized on performance.
Read more...
By
Arup Chakraborty
2009/08/10
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
37,308 reads
Methods For Converting a Stored Procedure
An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.
Read more...
By
Eli Leiba
2009/10/29
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
13,363 reads
9 Things to Do When You Inherit a Database
Some tips on what to do when you inherit a database that you've never worked on before
Read more...
By
Sylvia Moestl Vasilik
2009/06/22
|
Source:
SQLServerCentral.com
|
Category:
Best Practices
Rating:
|
Discuss
|
Briefcase
|
21,541 reads
Comparing Table Variables with Temporary Tables
This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.
Read more...
By
Wayne Sheffield
2009/06/10
|
Source:
SQLServerCentral.com
|
Category:
Temporary Tables
Rating:
|
Discuss
|
Briefcase
|
18,512 reads
SQL & the JOIN Operator
How the JOIN operator works, the different types of JOINs and relevant information about joining tables.
Read more...
By
Wagner Crivelini
2009/10/07
|
Source:
SQLServerCentral.com
|
Category:
SQL
Rating:
|
Discuss
|
Briefcase
|
14,343 reads
A Google-like Full Text Search
Implementing searching in your database is always a challenge and MVP Michael Coles brings us a method of building a Google-like search for SQL Server.
Read more...
By
Michael Coles
2009/07/24 (first published: 2008/10/07)
|
Source:
SQLServerCentral.com
|
Category:
Full-Text Search (2008)
Rating:
|
Discuss
|
Briefcase
|
47,713 reads
Targeted Index Performance Improvements
This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.
Read more...
By
Ian Stirk
2009/09/17
|
Source:
SQLServerCentral.com
|
Category:
Performance
Rating:
|
Discuss
|
Briefcase
|
11,735 reads
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.
Read more...
By
Jeff Moden
2009/10/02 (first published: 2008/08/19)
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
48,320 reads
Preventing usage of "SELECT *..."
Is there a way to not allow users to use SELECT * in their queries? New author AJ Raghuram has an interesting solution that can prevent this in code.
Read more...
By
Raghuram (AJ)
2009/11/05
|
Source:
SQLServerCentral.com
|
Category:
SELECT *
Rating:
|
Discuss
|
Briefcase
|
19,812 reads
Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
Read more...
By
Jeff Moden
2009/11/10
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
8,428 reads
Introduction to Indexes: Part 3 – The nonclustered index
Part 3 of a great series on the basics of indexes. This time MVP Gail Shaw examines the non-clustered index. Learn the structure, definition, and how to examine the use of these indexes in your queries.
Read more...
By
Gail Shaw
2009/11/18
|
Source:
SQLServerCentral.com
|
Category:
Indexing
Rating:
|
Discuss
|
Briefcase
|
8,504 reads
An Un-indexed Foreign Key Gotcha
Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.
Read more...
By
Alok Dwivedi
2009/11/09
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
8,808 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use