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
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
|
63,160 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,119 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,101 reads
Introduction to Indexes
Indexes are critical to good performance in SQL Server. However many people don't understand how indexes work and why they are important. MVP Gail Shaw provides us with an introductory article to explain the basics of indexing.
Read more...
By
Gail Shaw
2009/10/26
|
Source:
SQLServerCentral.com
|
Category:
Indexing
Rating:
|
Discuss
|
Briefcase
|
14,014 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,284 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
|
36,547 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
|
12,604 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
|
12,177 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,331 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,291 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,346 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
|
13,907 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
|
47,757 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,080 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
|
17,014 reads
Generating Insert Statements
This article from new author Oleg Netchaev describes the cursor-less script used to generate insert statements. This allows you to efficiently and easily add data generation statements to your project deployments.
Read more...
By
Oleg Netchaev
2009/07/01
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
14,856 reads
Get Performance Tips Directly From SQL Server
This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.
Read more...
By
Ian Stirk
2009/06/11
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
17,849 reads
Help, my database is corrupt. Now what?
Read more...
By
Gail Shaw
2009/02/16
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
18,159 reads
Using Indexes to Reduce Blocking in Concurrent Transactions
New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.
Read more...
By
Nilav Baran Ghosh
2009/07/07
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
11,725 reads
SQL Server 2008 T-SQL Enhancements Part - III
Continuing with his series on T-SQL enhancements in SQL Server 2008, Arshad Ali brings us a look at the HierarchyID and Large UDTs.
Read more...
By
Arshad Ali
2009/08/27
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2008
Rating:
|
Discuss
|
Briefcase
|
9,923 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use