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.
2008-05-08
8,233 reads
Additional Articles
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.
2008-05-08
4,526 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
2008-05-07
2,498 reads
Slowly Changing Dimensions in SQL Server 2005
This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.
2008-05-07
3,048 reads
Simplify SQL Server 2005 queries with a Dates table
Learn what a Dates table is and how to create one, and then try it out for yourself
2008-05-06
5,831 reads
SQL Server source code analysis and management adds database security
SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.
2008-05-06
2,617 reads
SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back?
In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.
2008-05-05
4,012 reads
SqlCredit – Part 15: The Cost of Distribution
Part 15 of this series examines what cost is paid when tables are separated into multiple databases on the same server.
2008-05-05
2,879 reads
Introduction to MDX Scripting in Microsoft SQL Server 2005
This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.
2008-05-02
3,531 reads
Using Indexes to Bypass Locks
One of the issues you'll face with SQL Server is blocking which is caused by other processes that are holding locks on objects. Until the locks are removed on an object the next process will wait before proceeding. This is a common process that runs within SQL Server to ensure data integrity, but depending on how transactions are run this can cause some issues. Are there ways to get around blocking by using different indexes to cover the queries that may be running?
2008-05-02
3,383 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers