Viewing 15 posts - 76 through 90 (of 279 total)
You can check in report, where was backup done RMB on DB->Reports->Standard Reports->Backup and restore Events or manually query msdb tables backupmediafamily and backupset
October 5, 2015 at 1:00 pm
Did you updated statistics? How was set on the old server max degree of parallelism and cost threshold for parallelism. What are waiting stats? You could try using sp_AskBrent which...
September 1, 2015 at 1:55 pm
The mirroring is deprecated in 2012 but still available, because AlwaysON is an enterprise feature.
http://www.brentozar.com/archive/2011/07/how-set-up-sql-server-denali-availability-groups/[/url]
July 19, 2015 at 10:50 am
Yes it is huge, eg. if app doesn't use stored procedures in db it can be a real pain for app. But still it depend on app, so test it...
July 18, 2015 at 5:16 am
Too quick assumption. It still can be a parameter sniffing that mention Gila. You can use sp_BlitzCache http://www.brentozar.com/archive/2014/05/introducing-sp_blitzcache/[/url] or check min and max values from sys.dm_exec_procedure_stats, if there are huge...
July 18, 2015 at 5:03 am
No, account that use SQL Agent must be a member of sysadmin role. https://msdn.microsoft.com/en-us/library/ms191543.aspx
July 12, 2015 at 2:29 pm
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/[/url]
If not help, post an error message from errorlog.
June 22, 2015 at 5:22 am
Here you will find a licensing guide for MSSQL 2008 and a formula to calculate required licenses (chapter 4)http://download.microsoft.com/download/6/F/8/6F84A9FE-1E5C-44CC-87BB-C236BFCBA4DF/SQLServer2008_LicensingGuide.pdf
May 7, 2015 at 3:41 am
Unfortunately online index rebuild generates a lot of log entries, in my case it was almost 3x index size :w00t: the only solution is switch to bulk-logged, but this may...
April 13, 2015 at 1:43 pm
Here you have a nice doc on compression https://technet.microsoft.com/en-us/library/dd894051%28v=sql.100%29.aspx
March 10, 2015 at 4:29 am
Read and learn 🙂 http://www.sqlservercentral.com/articles/Administration/64582/
March 9, 2015 at 7:39 am
Because MSSQL is waiting for another resource eg. disk, etc. You could use sp_whoisactive to check on what resource the MSSQL is waiting or extend events.
March 8, 2015 at 4:40 am
TNS is not resolved correctly, start by checking TNSNAMES.ORA, complete checklist you can find here, search for ORA-12154:
https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm
March 7, 2015 at 6:38 am
First of all, you shouldn't store even an encrypted password, this is a serious security hole. Correct solution is storing only hash values.
During encryption using EncryptByKey there are added salt...
March 7, 2015 at 6:05 am
What is exact error message in error log?
February 22, 2015 at 4:57 am
Viewing 15 posts - 76 through 90 (of 279 total)