Additional Articles


Technical Article

What's New and Different for the Access Developer Moving to SQL Report

Microsoft SQL Server Reporting Services is a powerful new tool allowing developers to move reporting solutions online for truly global access. This paper explains the key advantages, similarities, and differences between Microsoft Access reports and Reporting Services reports for organizations considering migrating to Reporting Services. (22 printed pages)

2005-01-28

1,323 reads

Technical Article

Microsoft SQL Reporting Services – Running a Report from the Command L

I recently ran into a need to run a report in SQL reporting services from the command line. The Report took four (4) input parameters and I had to export it to Microsoft® Excel and save it to disk. I had to rummage through the product documentation and the Microsoft® SQL Reporting newsgroup to get this right. For running reports from the command line, SQL Reporting services provide a utility called “rs utility”.

2005-01-26

2,602 reads

Technical Article

SQL Server 2005 Recursive Functions

SQL Server 2005 has added a new format for queries called a Common Table Expression or CTE. CTE’s are part of the SQL:1999 Specification and represent further compliance with this specification by SQL Server. This article will cover using one of the many capabilities of CTE’s, implementing recursive functions. A recursive function is a one that iteratively executes itself. Understanding how CTE’s implement recursive functions is the first step to understanding the full capabilities of CTE’s.

2005-01-19

1,858 reads

Technical Article

SQL Server Database Index Performance

When it comes to auditing index use in SQL Server databases, I sometimes get overwhelmed. For example, how to do you go about auditing indexes in a database with over 1,500 tables? While auditing a single index is relatively straight-forward, auditing thousands of them in multiple databases is not an easy task. Whether the task is easy or not, it is an important task if you want to optimize the performance of your SQL Server databases.

2005-01-18

3,860 reads

Blogs

A Basic Update Trigger: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

Apply for a 2025 PASS Summit Scholarship

By

Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...

SQL Server TempDB: The Most Overlooked Bottleneck

By

Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...

Read the latest Blogs

Forums

Best/easiest way to import an SSIS package...

By jellybean

Folks, Looking for advice on the best way to import a package. I hope...

Measure duplicating its value when non-conformed dimension attribute is included

By stiej1977

Hi,   I have two fact tables (say FactA, and FactB), that are joined/shared...

balancing numa nodes

By PearlJammer1

Can anybody advise on how i go about balancing threads to each node. As...

Visit the forum

Question of the Day

How Many Nested Triggers?

I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?

See possible answers