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,665 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

Weekly reading #22

By

A little bit late but it is here! It is Wednesday already and we...

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Read the latest Blogs

Forums

Upgrading tables without downtime

By mikael_ljunghorn

Hi, We are in the process of a larger upgrade of an existing database....

-ExcludeJob with list dbatools

By abdalah.mehdoini

Hello everyone , I would like to transfer job sql lists through dbatools through...

Bulk Export of History Reports

By les.61

We are shutting down a SQL Server and would like to know if there...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers