Generate Insert Statements

If you wish to save the contents of your database as insert statements, this script will generate a text file that has all data formatted as insert statements. This way you can save off the data as a script to send to a client or combine with a create script to rebuild the database on […]

2005-07-29 (first published: )

838 reads

Generate Quick Snapshot of table structures.

I use this script to quickly compare databases. In the past, I would generate creation scripts and compare those but that is tedious at best. This script generates a report of the metadata in an easy to read format that includes...- Table and Field Listing with types.- Foreign Key information- Primary Key and Index information- […]

5 (1)

2005-07-28 (first published: )

575 reads

Blogs

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Steps for a Successful Data Migration Session at Microsoft Ignite

By

I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Using mode() in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using mode() in R

Machine Learning Services on Database Server verses R Lang Execution on Laptop

By HookSQLDBA7

We are running SQL Server 2017 (RTM) on Windows. The question came up, if...

Stored Procedure "Caching"

By LightVader

I'm having an issue with a database that I recently moved from SQL 2014...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers