Technical Article

Column_Gitter Part Deux

This script is similar to Column_Gitter.  I noticed this script and wanted to present the same output without the use of cursors.  Both scripts work well and produce the same results.  This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names […]

You rated this post out of 5. Change rating

2003-08-14

83 reads

Blogs

5 Advanced Online SQL DBA Training Courses to Learn in 2024 and Beyond

By

Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...

Dynamically Unpivot columns in SQL

By

Picture this, your data ingestion team has created a table that has the sales...

Friday Basics: RPO and RTO

By

I did a post last month titled RTO and RPO are myths unless you've...

Read the latest Blogs

Forums

Azure SQL how to grant ALTER DATABASE permission

By Coriolan

  I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...

SQL Server Encrypt data into a file, send it and then decrypt

By GBeezy

First off, my apologies for what could potentially be a bad title! I am...

Table partitioning best practice

By JasonO

I've inherited a couple of rather large databases from my ex-colleague when I join...

Visit the forum

Question of the Day

Finding Marks

I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?

See possible answers