Thanks ChrisM@Work and everyone.

All I am asking is simple questions. Please forget what I am trying to accomplish or what I am trying get.

After running below query (AdventureWorks database). I get 7...

Please forget about previous ones.

My question is:

Is there alternative (best) solution for this? ( database AdeventureWorks, table Sales.Customer). In my case, StoreID, AccountNumber and rowguid have duplicate values.

select * from...

Is there alternative (best) solution for this? ( database AdeventureWorks, table Sales.Customer). In my case, StoreID, AccountNumber and rowguid have duplicate values.

select * from Sales.Customer where

StoreID = 934...

I need to find:

1. OrderNo. for 111 John 1/3/2015

2. OrderNo. for 111 Mike 4/4/2015

3. OrderNo. for 222 Mike 5/5/2015

4. OrderNo. for 222 John 1/6/2015

5. OrderNo. for 333 kim 3/7/2015...

Thanks pietlinden for formatting the query. The table already exists with OrderNo. and more columns. I need to retrieve OrderNo along with TranId, Name, Date.

TranId Name Date [OrderNo.]

111 John...

oh, I didn't mean that. I meant, I connect sql server prod instance from my laptop using SSMS. Thanks for you time.

Hi Gila. Did not get your 'don't'? Can you please explain.

Hi Alan,

Thanks for your reply. How about best way to connect to SSMS on Prod?

Thanks Lynn,

I was practicing delete million rows in small batch to prevent log size getting big.

Both I guess. Don't I need to install 'failover Cluster' on the window server to configure 'AlwaysON' High Availability group?

Thanks for your reply. It's not Production. Just test servers. don't have plan to use in Prod.

Thanks spaghettidba, I was just looking for to track 'space available'/'unallocated space' thru a table on A database.

I may not have explained correctly. when I do 'page' compression (heap table) I see 50% compression, just say 5GB gain after compression.

Now around 5 GB increase to the...

ScottPletcher thanks for you reply. Here's the thing I am trying to do. when I do 'page' compression on a table I see almost 50% space 'savings'. But I do...