Viewing 15 posts - 5,776 through 5,790 (of 9,244 total)
As an extra option you could turn SORT_IN_TEMPDB on, this may offload somewhat to the TempDB rather than using the database filegroup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 6:46 am
shahgols (4/6/2012)
Given the setup below, what would happen if the tempdb on the C:\ drive fills up? Will SQL Server crash or does it continue processing by using...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 4:36 am
Server side traces have much less impact apart the potential for required disk space depending on what you are monitoring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 4:33 am
george sibbald (4/4/2012)
User databases either backup\restore or detach\attach. Backup\restore usually best because the files to copy are smaller and backout is easier if problems with the migration.
The backups generally won't...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 4:12 am
jason07 (4/5/2012)
*** Error: Access to the path '\\WEBSVR-KL1\TransacLogKL1' is denied.(mscorlib) ***
tells you all you need to know
jason07 (4/5/2012)
Permission on folder i check no problem as same with other copy job.
Permission...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 4:04 am
Check connectionstrings.com all the info you need will be there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:52 am
Elliott Whitlow (4/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:46 am
I'd start by runnuning through and verifying any agent jobs that run or have run around that time just to know what they're all doing.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:43 am
Minnesota - Viking (4/5/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:31 am
chumphrey 12211 (4/6/2012)
I was told to shrink the database and rebuild the indexes but that just made the database larger!!!
That's expected, the index rebuild requires enough space to create a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:13 am
opc.three (4/6/2012)
Sure, configuring additional endpoints is common when using NUMA.
No, commonly you would just simply add different port assignments to the TCP\IP address to target database conections to certain...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2012 at 8:12 am
opc.three (4/5/2012)
I suspect it will work in SQL 2008+, but have not tried it.
It's commonly used on hardware based NUMA systems 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 6, 2012 at 2:03 am
@bi (4/4/2012)
How about storing the key and cert in a folder with unique security to that folder.What do you guys think ?
As I said at least use appropriate NTFS ACLs...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2012 at 11:20 am
@bi (4/4/2012)
Thanks Robert. Can you please explain little bit more why we need to save it in a Source control?
At the very least ensure you apply appropriate ACLs to the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2012 at 9:11 am
That's such an open question and all the responses here are valid
Do you have SAN in live and dr?
Do you have a large budget?
Do you have excellent (and i do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2012 at 4:31 pm
Viewing 15 posts - 5,776 through 5,790 (of 9,244 total)