Viewing 15 posts - 16 through 30 (of 58 total)
Open the management studio by right click and run as administrator.
February 28, 2012 at 12:06 pm
hemant789 (2/28/2012)
How do we know table is fragmented? Please explain in details.
Below is a example to find the fragmentation of any table.
USE AdventureWorks
GO
SELECT object_id, index_id, avg_fragmentation_in_percent, page_count...
February 28, 2012 at 12:03 pm
Is SSMS from run not working for sql server 2012 ?
February 28, 2012 at 11:54 am
Steve Bramwell (2/28/2012)
Has anyone come across an answer to this.
Recordid 1 contact date 01/04/2011
Recordid 2 contact date 01/05/2011
Days between Recordid 1 contact date and recordid 2 contact...
February 28, 2012 at 11:47 am
To display the Transaction Log Shipping Status report on a server instance
Exec sp_help_log_shipping_monitor
February 27, 2012 at 12:35 pm
February 27, 2012 at 12:21 pm
mail.baberkhan (2/27/2012)
With DB creator can provide access to create the database but what about to provide access to give the import rights can please any one suggest on itThanks
You...
February 27, 2012 at 12:10 pm
Are you using database tuning advisor or upgarde Advisor?
February 27, 2012 at 11:59 am
February 27, 2012 at 11:54 am
Check this link for same issue.
February 25, 2012 at 9:51 pm
LowFatSpread (2/25/2012)
For the recovery model. Given that i'm no sql server guru. Recovery
page verify - checksum.
How can I back up everything logs, database from a procedure? Do you have...
February 25, 2012 at 9:34 pm
I think,this much memory is enough but Its also depends on what things you will do with sql server.
February 25, 2012 at 12:52 pm
Viewing 15 posts - 16 through 30 (of 58 total)