Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Welcome to SQLServerCentral.com
A Microsoft SQL Server community of 741,216 DBAs,developers and SQL Server users
Headlines today
May 9, 2008
Undocumented Extended and Stored Procedures
Some useful undocumented extended and stored procedures in SQL Server 2005
Read more...
By
Timothy A Wiseman
2008/05/09
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
7,522 reads
Worst Practices - Not Using Primary Keys and Clustered Indexes
Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!
Read more...
By
Andy Warren
2008/05/09 (first posted: 2003/11/10)
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
58,008 reads
Scalability and Goal Testing for Developers
Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.
Read more...
By
Additional Articles
2008/05/09
|
Source:
DevX
|
Category:
Scalability
Rating:
(not yet rated)
Rate this
|
Briefcase
|
799 reads
Show more
Previous headlines
Using XML to pass Multi-Select parameters from SSRS to SQL Server
How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.
Read more...
By
Wayne Sheffield
2008/05/08
|
Source:
SQLServerCentral.com
|
Category:
Reporting Services
Rating:
|
Discuss
|
Briefcase
|
2,932 reads
Testing SQL Stored Procedures Using LINQ
The need to test a program that accesses and manipulates a back-end SQL Server® database is very common. In many such cases, the application interacts with the back-end data through the use of SQL stored procedures. In this type of scenario, you can think of the stored procedures as auxiliary methods of the system under test; and they must therefore be tested just like any other module in the system.
Read more...
By
Additional Articles
2008/05/08
|
Source:
Microsoft MSDN
|
Category:
System Development Life Cycle
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,343 reads
Best Practices for Troubleshooting Slow Running Queries
In this article we will share some of the common reasons for slow-running queries and what your approach should be for identifying and fixing them.
Read more...
By
Additional Articles
2008/05/08
|
Source:
SQL Community
|
Category:
Performance Tuning
Rating:
Rate this
|
Briefcase
|
5,328 reads
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.
Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.
Read more...
By
Jeff Moden
2008/05/07
|
Source:
SQLServerCentral.com
|
Category:
TSQL
Rating:
|
Discuss
|
Briefcase
|
8,892 reads
Slowly Changing Dimensions in SQL Server 2005
This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.
Read more...
By
Additional Articles
2008/05/07
|
Source:
SQL Server Performance
|
Category:
Analysis Services
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,865 reads
Constructing XML using 'FOR XML'
Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article the author concentrates on the FOR XML clause in SQL Server versions, 2000 and 2005. Click on title for more
Read more...
By
Additional Articles
2008/05/07
|
Source:
SQL Server Universe
|
Category:
XML
Rating:
Rate this
|
Briefcase
|
1,453 reads
Using Reporting Services to Search the SQL Server Log
A unique solution that allows Reporting Services to easily publish information from your SQL Server Error logs.
Read more...
By
Carolyn Richardson
2008/05/06
|
Source:
SQLServerCentral.com
|
Category:
Reporting Services
Rating:
|
Discuss
|
Briefcase
|
4,170 reads
From Last Year
From DBA to DBAA
Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.
Read more...
By
Jeffrey Yao
2007/07/12
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
13,185 reads
Browse all
Question of the Day
Statistics
By
SveG
2008/05/09
|
Category:
Administration
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,438 reads
What would you use to update a single table's statistics in the shortest time?
Read more...
Show more
Top Members (last 30 days)
#
Name
Score
Level
30 days
All-time
1.
ravisharvind
753
753
Right there with Babe
2.
BalaChandar.S
553
913
SSC Eights!
3.
Jeff Moden
544
8573
SSCrazy Eights
4.
GSquared
527
1371
Ten Centuries
5.
Anuj.Mobilex.gurgaon.India
484
905
SSC Eights!
Show more
Latest forum posts
search time ~18 seconds in a 5Gb DB
By
Matt Miller
|
May 09, 2008
Posted to
SQL Server 2005 Performance Tuning
Lookup Data in DB
By
Matt Miller
|
May 09, 2008
Posted to
SQL Server 2005 Integration Services
Complex query design
By
Matt Miller
|
May 09, 2008
Posted to
Development
SQL Script
By
Matt Miller
|
May 09, 2008
Posted to
T-SQL (SS2K5)
How do you handle la arge amount of characters?
By
Sergiy
|
May 09, 2008
Posted to
T-SQL
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use