Viewing 15 posts - 5,521 through 5,535 (of 9,241 total)
APA0876 (5/30/2012)
what do you recommend for 2 nodes active\active , 2 sql server instancesThanks
APA
Are you expecting a large amount of remote transactions on each instance? One DTC for each instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 31, 2012 at 4:21 pm
SQL Kiwi (5/29/2012)
A recent discussion on the MVP mailing list came to the unanimous conclusion that 4GB was fine for large-memory systems.
Were they Windows server MVPs?
GilaMonster (5/29/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 29, 2012 at 4:10 am
michael vessey (5/28/2012)
does that include the heartbeat IP addresses as well?
No Mike, and for 3 very good reasons
➡ Your public network possibly services 100's or 1000's of IP addresses and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 3:52 pm
The page file is a windows host configuration best practice. Ideally you should size it appropriately and place it on a separate disk
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 3:43 pm
to get the date of the latest stats updates for a given database, use the following
SELECTt.name
, i.name AS index_name
, STATS_DATE(i.object_id, i.index_id) AS statistics_update_date
FROM sys.objects t inner join sys.indexes i
on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 10:02 am
viswanathan.mathi (5/28/2012)
Hi Friends,I want to know the no of ip address required for active passive cluster active/active cluster
You require
1 IP address for each cluster node
1...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 28, 2012 at 9:54 am
Great, thanks for posting back
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 27, 2012 at 6:46 am
MysteryJimbo (5/26/2012)
Theres a risk of accidentally deleting or loosing the files when in a detached state.
Take a database offline and then try to delete, move or rename one of its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 4:33 am
Check your cluster validation report. Have you put all related disks for the mount pints into an app group and set the dependencies
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 3:49 am
cfradenburg (5/25/2012)
A user (db level) doesn't work without a login (instance level).
It does, but you to use EXECUTE AS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 3:46 am
I've never found a detached database difficult to re attach, unless of course some clown moves the files instead of copying them.
Even with backup and restore you want the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 26, 2012 at 3:44 am
sbaker-757360 (5/24/2012)
I tested complete network failure as described above...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 4:06 pm
anthony.green (5/24/2012)
Only SQL authentication accounts become "orphaned"
Unless of course you're crossing domains 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 10:58 am
Its already been said but actually restoring is the best way, however, you can also use
RESTORE HEADERONLY
RESTORE FILELISTONLY
If you can read the filelist and header details there's an extremely good...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 10:56 am
michael vessey (5/24/2012)
the syntax for rebuild is as followsALTER INDEX [PK_mytable] ON [dbo].[mytable] REBUILD
or to defrag
ALTER INDEX [PK_mytable] ON [dbo].[mytable] REORGANIZE WITH ( LOB_COMPACTION = ON )
For info, you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 24, 2012 at 10:53 am
Viewing 15 posts - 5,521 through 5,535 (of 9,241 total)