Mindy Curnutt

Mindy Curnutt is an Integration Architect for Unisys (http://www.unisys.com)
working with Windows 2000 Data Center Server and SQL Server 2000. She has
worked with relational databases since 1995; SQL Server since version 6.5.
She has been involved in the development of manufacturing (MRP),
sales/accounting (ERP), customer relations (CRM), medicare billing,
equipment maintenance management, image/document tracking and development
process control systems. Mindy is a member of the North Texas SQL Server
User's Group (http://www.immedient.com/SQLUsersGroup/). She enjoys
developing databases, data driven webpages, playing guitar, singing,
gardening, rubber stamping and geneology.

All authors

Technical Article

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-02-25

724 reads

All authors

Blogs

Why sys.fn_dblog Is Undocumented And Why It's Still There

By

Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...

T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup

By

When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...

A Last Minute Trip to the EU

By

My life has some crazy travel stretches for sure. Between speaking, office visits, customer...

Read the latest Blogs

Forums

Implementing Type 4 Slowly Changing Dimensions in SQL Server

By Dinesh Asanka

Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...

The Disabled Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Disabled Index

Server-Level Table sizes

By Artur Sanin

Comments posted to this topic are about the item Server-Level Table sizes

Visit the forum

Question of the Day

The Disabled Index

I run this code on SQL Server 2022. 

CREATE TABLE Drink
(
    drinkid INT NOT NULL
        CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
    drinkname VARCHAR(20),
    rating NUMERIC(2, 1)
)
GO

INSERT INTO Drink
(
    drinkid,
    drinkname,
    rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result?

See possible answers