That's what I dunno if I should do or not, because like I said my physical...

eventhough the table has a primary key? and a non-clustered index?

non-clustered indexes are supposed to be inserted in a specific order right? :ermm: please correct me if I am mistaken...

Hi I think it would be something like this:

select idNumber,count(idNumber) from dbo.Empleado

group by idNumber

and if you only want the records that appear more than once, then you should probably add...

Thanks for the reply, I described my pages read and written just because I thought it had something to do with all the RAM memory being consumed, but as you...

I finished rebuilding one of my indexes on more than 10 million rows. I was happy to see this working. Thanks.

But there is one thing now, even these process has...

thanks guys for the quick replies, I just killed my 100 hour process XD

I have restarted my dev server and everything seems to be back to normal, my biggest table...

everything is still running, just my RAM is being exploited, more than 1.5gb is being used. Disk space is still normal, no changes, and my database log hasn't increased, could...

Jerry Hung (9/26/2008)

---

Wow, that is LONG

How much was the fragmentation %? I wonder if REBUILD (instead of REORGANIZE) would've been quicker

Was this tested in other environments to estimate the hours...

the problem is that I can't get a connection to my sql server. My SSMS is not able to get a connection to my server because as my SSMS says...

I didn't have any other processes running on my server when I started my indexes rebuilt.

And hhhmmm :ermm: excuse my question :ermm: but how do I check if I am...

Well I just found out that it comes with any type of SQL Server you get. But check this out "Microsoft SQL Server 2005 Assessment Configuration Pack for Sarbanes-Oxley Act...

Sorry about not being so clear in explaining what I wanted 🙁

Yeah after a while of wandering around the web, as you said, there isn't apparently any relationship between my...

but from T-Sql???

Hi I think I have tried with the same commands in order to execute a SSIS but I can' get it to work please any suggestions?

but that didn't solve the problem of trying to execute an SSIS from an stored procedure, did it?

I am using a version of the code but it just wouldn't work...