Data Dictionary from within SQL Server 2000
Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!
2005-02-04 (first published: 2002-02-11)
35,864 reads
Mindy Curnutt
Get Record Counts for Each Table
This script creates a stored procedure that you can call to get the record count for every table in a particular database. It uses the sp_MSforeachtable system stored procedure and a temp table.
2002-02-25
621 reads
Recompile Views/SPs from DOS from .SQL Files.
This script is very helpful for anyone trying to recreate particular SQL Server Database Versions for Testing. It allows you to automatically recompile any stored procedures or views saved with drop, create and permission statements. The scripts must all be sitting in one directory and end in the same extension. I have found this very […]
2002-02-25
661 reads
Using Stored Procedures for SQL Server DML
Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!
2001-08-01
11,828 reads
Blogs
Last Weeks Reading (2019-05-26)
By KamilN78
It was tremendously extensive week for me (a week ago) when I spent time...
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Proverbial Tree Barking
Hi All, I'm just after a pointer really. I've had an idea. I want...
Transforming rows into columns
Hi Everyone, I have a table with the structure as attached in the Table...
Ask SSC