An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
SQL Tutorials
More .NET Programming Tutorials:
- ADO.NET Tutorials (146)
- LINQ Tutorials (19)
- MS SQL Tutorials (551)
- MSDE Tutorials (28)
Raw Materials – Consultant, Superstar
Does success in one field transfer to another?
The DIS-Information Principle: A Splitting Headache
You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue the problem, even with expert queries. So what constitutes ‘wrong RDBMS design? What are these errors that continually crop up
Inside the Optimizer: Constructing a Plan – Part 1
Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.
Early September Free Training from PASS VCs
Hope you got plenty of rest over your Labor Day holiday because the PASS Virtual Chapters have some great free training lined up for you.
SQL Saturday #55 – San Diego
The first SQL Saturday in San Diego kicks off fall with a full day of free SQL Server information, lectures, and seminars from the experts on the West Coast.
Extended Protection available in SQL Server 2008 R2
We use Internet Protocol Security (IPSec) within the trusted domains, but use the Negotiate Security Support Provider for our web applications.
4-4-5 Calendar Functions, Part 1
New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.
TSQL Challenge 38 – Calculate SQL Stars awarded to the Winners of TSQL
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
Rebuilding Indexes using the SSMS Database Maintenance Wizard
Index fragmentation can cause problems with query performance.