Viewing 15 posts - 301 through 315 (of 1,179 total)
Yes, it will be good idea to perform reindexing on a larger table with respect to specific index or table as mention by Gail. Thus it will be easy to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2014 at 4:54 am
Check the following link which might help you:
http://www.microsoft.com/en-us/server-cloud/products/sql-server/Try.aspx#fbid=uFieoHjkMcs
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 11:07 pm
You can use tape drive to take backup. Once backup is done in one domain you can use same tape to restore into another domain.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 10:59 pm
You are asking to do computing on shutdown machine. It is not possible. To do any process your database should up and accessible. Now if you do have job it...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 10:51 pm
How about linked server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 10:47 pm
Check if any filters are there and stopping all the rows to transfer.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 10:44 pm
Good one, Thanks Steve.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 10:39 pm
Check the list of extended events and see if it satisfies your requirements.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 6:40 am
rajsin7786 (4/7/2014)
Okay I was being impatient , I must have taken your experts words. It took around 75 minutes but its over now. Thank god.
OK 😎
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 5:23 am
Check the current execution on the server and see if still spid is active?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 5:20 am
Do you mean index physical statistics?
Be patience and wait for sometime it will take some time to pop up report.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 5:05 am
Ryan Keast (4/7/2014)
From ih -
name,rows,reserved,data,index_size,unused
em_comm_costing,384191,1011704 KB,512424 KB,498648 KB,632 KB
From ih_restore
name,rows,reserved,data,index_size,unused
em_comm_costing,384191,119808 KB,62960 KB,56088 KB,760 KB
Any change in index?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 5:00 am
DBCC SHRINKDATABASE will Shrinks the size of the data and log files in the specified database. Free unallocated space in the database.
PAGE COMPRESSION will result into Data compression. You can...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 7, 2014 at 3:57 am
Are you planning to publish same articles across the all subscribers databases/servers?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2014 at 11:48 pm
From the security and connectivity perspective it would be good to keep sql servers on domain. If it's on work group connectivity will be an issue.
Why you are keen...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 6, 2014 at 11:44 pm
Viewing 15 posts - 301 through 315 (of 1,179 total)