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...
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
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
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...
April 7, 2014 at 10:51 pm
How about linked server?
April 7, 2014 at 10:47 pm
Check if any filters are there and stopping all the rows to transfer.
April 7, 2014 at 10:44 pm
Check the list of extended events and see if it satisfies your requirements.
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 😎
April 7, 2014 at 5:23 am
Check the current execution on the server and see if still spid is active?
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.
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?
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...
April 7, 2014 at 3:57 am
Are you planning to publish same articles across the all subscribers databases/servers?
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...
April 6, 2014 at 11:44 pm
Viewing 15 posts - 301 through 315 (of 1,179 total)