I'll pick up some black candles and incense on...

What, other than the NOLOCK hints, is the problem?

Um...

http://www.sqlservercentral.com/Forums/Topic1691210-2799-1.aspx

Crystal ball to aisle 5 please. (or maybe we need something a tad stronger)

Implement *what* in a query?

Alvin Ramard (6/3/2015)

---

I think I'm ready for a new thread. I'm seeing way too many responses to questions that not really related to the question asked. The...

It would help, just a tad, if we had a clue what the definition of the Times table looks like and what the data in it consists of.

Read the question? What heresy is this, Alvin???

You can't do anything to an index when the database is offline though. Offline database means inaccessible.

I suspect the article means offline as in, don't use the ONLINE = ON...

My general guideline is 'new question -> new thread'.

If I open a thread and notice that the OP is a year old, I probably won't look any further.

You asked how to connect to Management Studio that's running on the server. You don't. You run SSMS locally and connect to the SQL instance from there.

Don't. Run SSMS on your local machine and connect to SQL running on prod.

Follow the debugging in https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

You'll need to query sys.master_files on each instance to get a list of the mdf and ldf files associated with each instance.

The demo code I used in a recent article.

Setup:

CREATE TABLE Transactions (

TransactionID INT IDENTITY PRIMARY KEY,

TransactionDate DATETIME,

Amount NUMERIC(12,4),

Filler VARCHAR(200)

);

CREATE TABLE Results (

Rows INT,

SumAmount NUMERIC(28,4) -- should now be large enough

);

WITH...

You can,...