Data Warehousing

Source system pre-integration analysis

  • Script

Initial analysis of a new source system can be quite time consuming to manually examine tables and columns to determine which even have worthwhile values in the first place. Running this script against the current database will generate useful information for all the columns of all the tables. Details include data types with varchar lengths, […]

5 (1)

2005-06-07

436 reads

Handle Divide by Zero in SQL Reporting Services

  • Script

Out of the box, Reporting services does not handle divide by zero conditions gracefully. There are plenty of posting on how to use the IIF() function to accomplish this, with some rather horrific looking code. In order to simplify the coding process and make the resulting expressions readable by a mere mortal, I wrote the […]

4.5 (14)

2006-07-28 (first published: )

3,669 reads

Frequency of each field in table

  • Script

This SP will generate the frequency of each occurrence in a field or for every field in a table. The syntax isexex sp_freqall , , , , for example:exec sp_freqall utems2000_2001, null,lastname, 100would return a table (with a field name and a count) for each field in the utems2000_2001 table, except the lastname field and […]

2002-10-03

219 reads

Blogs

Understanding Azure Geo-Redundant Storage

By

While at PASS Summit 2019, I gave a session on designing Azure Disaster Recovery...

Prompt in ADS

By

Ever since VS Code and Azure Data Studio came out, people have been asking...

When Too Much is Not a Good Thing

By

Explore how to avoid unwanted results that oft occur due to lack of attention...

Read the latest Blogs

Forums

Do you feeling the Sheila Rashid x Air Jordan 1 Mid?

By stevenrowe98

Sheila Rashid x Air Jordan 1 Mid[/URL] sports a split color-blocking that features Purple...

Licencing Information

By Wecks

Hi Guys, I have the following question I am hoping that you guys can...

Countermeasure to stop forum spam bots

By jonas.gunnarsson 52434

There is a lot of spam from time to time. Is it possible to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers