Viewing 15 posts - 1 through 15 (of 118 total)
Thanks for all of your valuable replies,
Here is the server config for those who wanted to know,Memory 256 GB, Processor Intel(R) Xeon(R) CPU E5-2630...
February 8, 2017 at 11:34 am
As it seems like there is not a standard approach for this, so have to review all the possible suggestions you guys have recommended, will see how we can manage...
February 7, 2017 at 11:24 am
Hi Jeff, you have any articles to support it?
February 6, 2017 at 3:57 pm
Hi,We have a 40 TB DB, and have some big tables and few indexes which...
February 6, 2017 at 3:36 pm
I have tried using resource governor, but whenever the job runs it show the sql server service account in the activity monitor, where as i have another login which i...
April 1, 2016 at 9:44 am
Its not the user who creates the view, other users can create the view with that nametype, and that following user needs to have access to those specific name type...
August 5, 2015 at 10:30 am
Yeah we tried to copy the files into 15 smaller files,
September 4, 2012 at 3:29 pm
44 mins video, will listen for sure...
October 25, 2011 at 3:25 pm
October 25, 2011 at 1:10 pm
I think i got exactly what i needed, i wanted to leave the latest file kept untouched and not delete it, doesnt matter what date the latest file was(1...
August 30, 2011 at 8:43 am
Thanks, It would be great if you can give me a reference/documents.
What will be the alternative approach for this, T-Replication? if not Backup/Restore.
August 17, 2011 at 2:50 pm
i want to do mirroring making 2008 as principal and 2008r2 as mirrored. will that work?
August 17, 2011 at 1:45 pm
This is what exactly i am also facing as mentioned in the below thread
May 12, 2011 at 9:35 am
So, there is no other way to just restore the data without empty file space directly from the backup?
I have the same scenario where i have database bak is 50...
May 12, 2011 at 8:58 am
This worked for me as well......
I was able to shrink the initial size of the database as follows
Right click database in Management Studio
Choose Tasks, Shrink, Files
Select File Name to shrink,...
November 23, 2010 at 11:29 am