Viewing 15 posts - 1 through 15 (of 30 total)
yes, I am filling the available values of the parameter for a dropdown - would you be able to point me to some resources on how format the time in...
June 21, 2013 at 12:41 pm
Nice article. I have a question relating to clearing the wait statistics on an instance. On my production Servers, I capture the wait statistics every hour, as soon as...
February 4, 2013 at 1:49 am
I would not recommend shrinking the transaction log as the log will probably grow again.
How often are you performing your transaction log backups?
You could increase the amount of transaction...
January 7, 2013 at 3:01 am
You could write a powershell script to delete the files and schedule this with the SQL agent or windows task scheduler.
December 1, 2012 at 2:07 am
Assuming that you want to restore a copy of the database over the live principle database, you will have to break the mirror first and then set it back up...
November 22, 2012 at 1:45 am
As Anthony said you will not be able to prevent sysadmins from viewing the data, but you can set up auditing on the accounts to log when they have read\modified...
November 21, 2012 at 2:11 am
To remove a depenancy you need to go to the following registry entry: HKLM\SYSTEM\CurrentControlSet\services\<service>.
There you find a REG_MULTI_SZ key named DependOnService where you can remove any services your service...
November 17, 2012 at 11:49 am
This query will tell you how long the restore will take in seconds:
SELECT Percent_Complete, Estimated_Completion_Time / 1000 as [CompletionTimeSeconds]
WHERE Command LIKE '%RESTORE%'
November 17, 2012 at 10:54 am
Do you have any DNS Suffixes (in the DNS tab of Advanced TCP/IP settings) on the nic card?
October 31, 2012 at 12:49 am
If your backup Server is on a different VLAN to the SQL Server, you could then add another NIC card on the SQL Server and give it an IP Address...
March 15, 2012 at 11:12 am
are the index fragmentation levels the same on both databases?
have you checked to see if there is any blocking?
January 26, 2012 at 10:51 am
Have you checked for any errors in the windows event logs?
January 25, 2012 at 11:11 am
If you can, I would bring both nodes down. Then power on the one with the problem first and see if the clusters go online, then bring the second node...
January 24, 2012 at 11:55 am
As Gail says that will be a system SPID.
Run DBCC INPUTBUFFER (16) and see what the statement is
January 20, 2012 at 12:32 pm
Use Windows Live writer.
You can publish directly to WordPress from there, and it keeps all of the formatting\colours
January 10, 2012 at 12:15 pm