repository

Technical Article

RE: Low Priority SQL?

  • Reply

I think that you are referring to Online vs. Offline operations (From Books Online):DBCC INDEXDEFRAG is an online operation. While this operation is running, the underlying table is available to users of the database. DBCC DBREINDEX is an offline operation. While this operation is running, the underlying table is unavailable to users of the database.AFAIK, […]

2005-05-20

Technical Article

RE: Cannot Register an Instance of SQL Server 2000

  • Reply

Hi rmizzar!It might be caused by what protocols that are used. I would try to first set the language to tcp/ip and if that does not work, to named pipes.If you are logged in on the server when you do this, use the Client Network Utility and go to Aliases tab. Type in the servername […]

You rated this post out of 5. Change rating

2004-07-28

Blogs

Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox

By

Are you ready to take your SQL skills from theoretical to tactical? If you've...

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers