Viewing 15 posts - 5,791 through 5,805 (of 9,253 total)
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...
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...
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 😉
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...
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...
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...
March 30, 2012 at 4:31 pm
wayne.mcdaniel (3/30/2012)
- get the physical file names and locations
- put the database in single user mode
-...
March 30, 2012 at 4:02 pm
You shouldn't need to set the database single user first, just issue the following
alter database set offline with rollback immediate
[/Code]
March 30, 2012 at 1:10 am
Agreed, use the backup.sqlbackup method via SMO. You'll also be able to display a nice little progress bar too
March 30, 2012 at 12:57 am
MiguelSQL (3/28/2012)
I have a two node Windows 2008 cluster, for which I'm running two instances of MS SQL 2008 R2 SP1 64 Bit Enterprise Edition in an active/active configuration.
Customer wants...
March 29, 2012 at 12:11 pm
SSRfromChennai (3/28/2012)
how to validate a windows login in domain through SQL queries
use the stored procedure xp_logininfo
March 28, 2012 at 2:44 pm
to change the instance name you would have to install a new instance
March 28, 2012 at 2:36 pm
SQL_Helper (3/27/2012)
Greate, thanks for the response.
I am expanding this discussion 1 step further.
Now we have 3 nodes cluster (2 active and 1 passive), Please help to answer following queries.
Requirement:
==========
a) I...
March 27, 2012 at 10:24 am
In addition to Jeffrey's comments you may also query the table msdb.dbo.backupfile, this will detail the logical and physical filenames for the databases that were part of a backup operation
March 26, 2012 at 6:46 am
Lynn Pettis (3/14/2012)
Windows Server 2003 R2 on 32 bit servers only supports 4GB ram.
Standard edition yes, Enterprise and above have a much higher memory limit
March 26, 2012 at 6:30 am
Viewing 15 posts - 5,791 through 5,805 (of 9,253 total)