Viewing 15 posts - 76 through 90 (of 285 total)
Post your execution plan as well for the query which takes an hour.
September 30, 2011 at 4:37 am
Thank you for directing the same. However my quetsion was about any stored procedure which does the same in SSMS.
September 22, 2011 at 10:06 pm
Try with this select Database_name,
COALESCE(Convert(varchar(20), MAX(backup_finish_date), 101),'Backup Not Taken') as
LastBackUpTakenDate,
COALESCE(Convert(varchar(20), MAX(user_name), 101),'NA') as BackupTakenUser
from msdb.dbo.backupset
GROUP BY Database_name
September 22, 2011 at 4:19 am
I am not sure how can we cheat the blocking...However giving the content as below:
To configure login auditing
In SQL Server Management Studio, connect to an instance of the SQL Server...
September 22, 2011 at 1:58 am
I guess my question is not clear. Sorry for that.
DBMirroring, the transactions are going from principal to mirroring through tran logs.
How it is been handled in AlwaysON? I guess now...
September 20, 2011 at 11:59 pm
I do not think enabling the option will cause issues. I heave read Glen's article once in SSC stating the same. Do not have the link handy.
However, if there are...
September 20, 2011 at 11:24 pm
Please check out the BOL topics from the link below. If this is not sufficient then I suggest that you buy one of the Inside SQL Server books. There are...
September 20, 2011 at 10:53 pm
Thank you for your reply.
However I was about to ask a question like how AlwaysON will move the committed data from Primary to secondaries? Is this still based on transaction...
September 20, 2011 at 10:50 pm
Thanks you for all for replies with the great explanations!!! I buy it!!!
September 20, 2011 at 10:46 pm
steveb. (9/20/2011)
i would avoid SQLmail especially since you are runnig SQL 2008.
Why is this? It is a deprecated feature for future versions. However it works in 2008 R2 as...
September 20, 2011 at 5:52 am
Jayanth_Kurup (9/20/2011)
Security is another issue.
CLR is the way to go . I wouldn't suggest SQL Mail on a higher enviornment.
Could you please let me know the issues that youi...
September 20, 2011 at 5:51 am
sqlzealot-81 (9/20/2011)
There are system procedures to read the data of inbox mails.Please google out it been long time that worked...
September 20, 2011 at 4:41 am
You may look at SQLMail option. (Am not talking about DBMail).
There are system procedures to read the data of inbox mails.Please google out it been long time that worked on...
September 20, 2011 at 4:35 am
Viewing 15 posts - 76 through 90 (of 285 total)