how?

The db consists of 4 datafiles and 1 log, two valid and two invalid( the offline ones ) I tried this

USE [database]

GO

ALTER DATABASE [database] REMOVE FILE [corruptedfile]

GO

ALTER DATABASE [database]...

Thank you so much!!

This is perfect!

Hi

I am almost sure that I updated the statistics, just in case I am doing it since a couple hours ago,

I could post a query, but really you won't...

I already tried downloading it again, same problem

Actually I am pretty sure i have the right media, I use it to install another server

The machine is a fresh install of Windows server 2003 R2

9.00.1399.06RTMStandard Edition

I used this same installer, on another server and it installed enterprise version, I downloaded the installer again and got the same results, ideas????

Thank you guys,

Now I have what I needed 🙂

Thank you

but.. what happen when I get this after running sp_lock:

spid__dbid__ObjId__indId__type__resource__mode__status

545___6_____0_____0_____DB_____________S____GRANT

There isn't an objectid....

on a diferent db I ran that query and one of the results says this:

name_______impact_____________seeks_ scans_equalitycolumn_inequalitycolumn___included

table1______229918.581387738___2080___0____[pronumber]___NULL_____________NULL

but I do not have a column named pronumber on that table, any Idea of...

The book is "SQL Tuning" Dan Tow

Thank you All

I found a really good book about best practices and such

With my sproc i just ran a query for missing index, modified on index to add some included...

Actually I didn't post that info on purpose, I just wanted to show a case where the best practices aren't the bes, and the question at the final part of...

Already did that test

Part A, original sproc 14 minutes/New sproc 15 minutes