Articles

SSRS provides a very user friendly way to author and deploy reports. These reports can be accessed from different platforms where the reports are deployed - reports manager, SharePoint, stand-alone / distributed applications or programmatically using SSRS SOAP endpoints. Unfortunately, SSRS / BIDS does not provide any high-end debugging tools such as SQL Profiler for analyzing the performance of SSRS reports. In this tip we will look at different ways of debugging and analyzing SSRS reports performance using execution logs and freeware tools.

2011-03-28

5,640 reads

Statistics, row estimations and the ascending date column

by Gail Shaw

SQLServerCentral.com

Blogs

SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-03-28

1,643 reads

The default trace in SQL Server - the power of performance and security auditing

by Additional Articles

SimpleTalk

SQL Trace

Since the introduction of SQL Server 2005, there is a simple lightweight trace that is left running by default on every SQL Server. This provides some very valuable information for the DBA about the running server, but it isn't well-documented. Feodor Georgiev reveals many of the secrets of this facility and shows how to get reports from it.

2011-03-28

3,896 reads

SQL Server 2008 Service Broker - Conversation Priorities

by Additional Articles

Database Journal

Service Broker (SSSB)

SQL Server 2008 Service Broker lets you process higher priority messages and conversations earlier than those with lower priority.

2011-03-25

2,326 reads

SQL Server Startup

by Jason Brimhall

SQLServerCentral.com

Blogs

From time to time I see a question asking how to determine the last time a SQL Server was either...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-03-25

1,313 reads

SQL Server random numerics data generation using CLR

by Additional Articles

MSSQLTips.com

SQLCLR

You need to generate random data directly into SQL Server table columns or close to the database engine as variables or expressions. Looking at the SQL Server available functions, you notice that only RAND function offers support for random data generation. Although RAND([seed]) is a built-in function, it can only return a float value between 0 and 1, and has other limitations in regards to seed values. Because your table columns may be of various data types, and each data type may have a lower value and an upper value, you would prefer to create your custom random data generators. This is when SQL Server CLR functions come into play and provide a viable solution.

2011-03-24

3,275 reads

Naturally Increasing Data Value with Hierarchical Structures

by Additional Articles

Other

Data Modeling

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.

2011-03-23

3,291 reads

SQL Bits VIII

by Press Release

SQLServerCentral.com

SQLBits

SQL Bits 8 will be in Brighton in the UK on April 7th-9th. There are paid full days of training as well as a free day on Saturday. Register now for the premier SQL Server event in the UK.