Scripts

Script to obtain datadictionary from a SQL2000 db

This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]

2001-08-27

3,095 reads

Blogs

How Many Bytes Per Character in SQL Server: a Completely Complete Guide

By

A Completely Complete Guide to how many bytes are used to represent characters in...

Power BI Monthly Digest – November 2019

By

In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson...

Data Masker Reads Column Classificiations

By

One of the newer features in Data Masker for SQL Server is the ability...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Row Level Security based on multiple factors

By peterg417

Hey there, I recently got a request from some people here to implement another...

Determining if more CPU is needed

By dan-572483

We have a data import & processing process that often longer than expected, often...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The CTE Insert

See possible answers