External Article

SSRS Reporting Basics: When is SSRS the Right Tool?

  • Article

SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in companies large and small. In this article, Eugene Meidinger recounts the history of SSRS and explains when it’s the best tool to use. This is the first article of a series on SSRS.


4,148 reads

Technical Article

RE: Error when using the IN Keyword on 100.000 elements

  • Reply

It's been a laborious and painstaking exercise but I spent all morning creating and testing a dummy table with 3 combinations of 2 columns - clustered and unique nonclustered; clustered and nonclustered & clustered only: In the first 2 instances (clustered and nonclustered (with unique constraint) AND clustered and nonclustered), "selecting *" gave me resultset […]


Technical Article

RE: SQL Server Analysis Service

  • Reply

Here are some links:  


Technical Article

Sum and Group by

  • Topic

Hello,I am not sure where I can find anything about grouping by number. To be more specific :Table: 2 columnsNumber of the week                  Amount                   1                                               502                                               253                                               474                                               155                                                56                                                877                                                268                                                1059                                                 6710                                                18 Now I need to get SUM() for every 3 weeks or 6 weeks or any number I need. Can not find how to […]


Technical Article

RE: The CLR in SQL Server 2005

  • Reply

Your arguement is certainly valid, but there are some very good reasons to abstract your middle tier from your database.  First one that jumps out is how poorly TSQL organizes logic.  Since TSQL isn't an object based language, encapsulation and reuse make building a good business layer difficult.  This does change with CLR in the […]



Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022


Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout


I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs


Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers