I'm not really in a position to change code at my company but will definitely consider, thanks for all your input so far also.

Interestingly when I run DBCC USEROPTION on...

Hi Lowell

I wasn't the one who wrote this code -it was developers who wrote code years ago but I'm not going to defend them :-). I found this code from...

Hi Eric

Thats brill but does it support Window 10? I'm on Win 7 but will upgrade within the next few months :-

https://diskcryptor.net/wiki/Main_Page

Cheers

Can Bitlocker be installed after the Window OS has already been installed?

The website says that the OS has be installed first which is problem for Home Users who usually...

Hi Jeff

For now I was just wanting a list of the duplicates. I'm learning its mostly a matter of preference whether we use the GROUP BY or WITH statements or...

Hi

After I've found the duplicates I'm going to contact the customer to confirm if he'd still like them removing. Removing them is the easy part as I've found a previously...

Hi Piet

Thanks for guiding me. I've didn't even know about CTE before I started this topic. I'm trying to learn it but its just out of my grasp at the...

The table could contain this for example :-

ColumnA Value

1/1/2015 5

1/1/2015 5

2/1/2015 ...

Hi

That's better, ta.

The percentage complete column is really useful.

It only took 15 minutes to reply rebuild a 65GB database as well so all good 😀

Cheers

James

Hi

I've ran your script but it just returns 0 rows though while the index is still running.

Cheers

Matt

Hi kreuzer

Thanks very much - I'm about to run another rebuild in 30 minutes times so this could come in very handy!!

Also when I ran a rebuild before, it only...

Hi SSC

My 5 year old laptop has twice as much memory compared to this ---- lol.

I'll drop a post to say how this peters out.... Just need to prove that...

Hi Gila

If its still slow on Monday I'll advise that the customers have to put up with it as it'll be better in the long run.

Cheers

James

Hi Luis

I've hit a snag. I've set a customers system to rebuild all their databases this weekend. I'm just a bit worried that the reindexing will still be running on...

Hi Luis

This is a real eye-opener. Thanks for recommending this book - I'm reading it already. Can't wait to figure it all out better 🙂

Kind Regards

James