Viewing 15 posts - 16 through 30 (of 53 total)
That's rite.. and all your suggestions are very valuable.
Thanks
December 14, 2016 at 10:04 pm
This is well fabricated one, I am doing something very similar thing RBAC remediation and I am stuck at place where user defined roles got what access , I mean...
February 18, 2016 at 1:21 pm
Refer to the link .. might be helpful understanding the @query parameter and alternative.
http://www.sqlservercentral.com/Forums/Topic1004043-338-1.aspx
November 2, 2015 at 8:39 am
well , in that case why not using backup and restore ... backup to multiple files and restore ... and make it a schedule in or package SSIS.
November 2, 2015 at 7:18 am
There are couple of ways doing this , you can use Replication or regular backup and restore. With regular backup and restore method take the backup into multiple files either...
November 1, 2015 at 4:02 pm
Yes, Well you can use RECOMPILE or OPTIMIZE FOR / PLAN GUIDES query hints ... i never used these but below links helps to understand.
https://msdn.microsoft.com/en-us/library/ms190417.aspx
https://msdn.microsoft.com/en-us/library/hh213001.aspx
basically syntax...
November 1, 2015 at 3:26 pm
Why not using Always ON since you already using 2012. secondaries can be used for reporting with out any changes.
November 1, 2015 at 3:01 pm
I Believe you are talking about two things here , Event Notification Vs Extended Events which is a new feature in 2012 where is no mail alerting mechanism embedded and...
November 1, 2015 at 2:41 pm
Yes thats rite,similar Logical names are not allowed. But its possible to restore the full backup of same logical name backup copy with different logical name.
follow the link
November 1, 2015 at 2:22 pm
You need to modify the table Event Data , Add MC.CompA values if you want to filter depending on CompA values or if you need to select by CompB values...
October 31, 2015 at 10:46 pm
Silly way is disable all constrains and dump the data.
October 31, 2015 at 2:50 pm
What is the current transaction isolation ?
October 31, 2015 at 2:47 pm
Try to use this code to get the error messages
CREATE PROC [sys].[sp_readerrorlog](
@p1 INT = 0,
@p2 ...
October 14, 2015 at 9:23 am
Dell Porducts,
Spot Lite GUI mode but good for understanding and alerting ..
And Foglite i used it every ware but it takes little effort understanding the alerts and configuring but its...
October 14, 2015 at 9:17 am
Viewing 15 posts - 16 through 30 (of 53 total)