Viewing 15 posts - 8,776 through 8,790 (of 9,253 total)
Andrew Peterson (11/5/2008)
The simple approach is to drop and restore the logins with the sid as part of the create login command.
why not just script off the logins from the...
November 14, 2008 at 6:24 am
definitely shutdown SQL server instances.
make sure you have a full backup of the data files before defrag.
Rebuild all your indexes after the defrag
November 14, 2008 at 3:28 am
Hi
the first question i need to ask you is
what platform are you using for virtualisation?
We currently use VMWare VI3 comprising of 10 ESX 3.5 hosts
Dont get ESX server confused...
November 14, 2008 at 3:17 am
stacked IP addresses are another way to have SQL listen on multiple IP's and ports
November 12, 2008 at 3:43 pm
Steve Jones - Editor (11/12/2008)
You can't, but if it's a daily load, why do you care? The space will get reused tomorrow.
that's a very valid point
November 12, 2008 at 3:38 pm
rbarryyoung (11/12/2008)
3GB does not sound like anywhere near enough memory for 1000 databases.
unless of course they're all copies of Northwind and Pubs 😀
November 12, 2008 at 3:13 pm
Dean Jones (11/12/2008)
when enabled and doenst really solve the issue of SQL CLR taking up the whole VAS memory area.
that's not what AWE is for. AWE is so that each...
November 12, 2008 at 3:10 pm
thats more like it although essentially with node 5 inactive you could argue you still have active\passive clustering 😉
November 12, 2008 at 10:15 am
GilaMonster (11/12/2008)
indexes were been rebuilt sunday evening. Those are logged operations and the log reader has to read through them.
not logged under simple or bulk logged recovery models 😉
November 12, 2008 at 9:59 am
mtassin (11/12/2008)
Well presently it's a 4 node all active cluster with 3 GB of Ram given to each SQL instance.
if the cluster has only 2 instances then 4...
November 12, 2008 at 9:47 am
if you have 4GB RAM or over you need to enable AWE for each instance. What version OS do you use and what version SQL server. You should also configure...
November 12, 2008 at 9:40 am
Mike Levan (11/12/2008)
Many DBa's say that shrinking is a bad idea,
in a word "fragmentation"
Mike Levan (11/12/2008)
but that is what we do to gain disk space every time.
i hope not,...
November 12, 2008 at 9:35 am
kendal.vandyke (11/6/2008)
We have multiple datacenters and each datacenter has 2 controllers for redundancy.
all these DC's are on the same domain then are they?
kendal.vandyke (11/6/2008)
November 7, 2008 at 9:32 am
the following stored procedure
sp_attach_single_file_db
attachs a single file database, however it relies on the MDF not the LDF. M$ went to all the trouble of cov ering this, I'm sure if...
November 7, 2008 at 9:25 am
kendal.vandyke (11/5/2008)
November 6, 2008 at 6:18 am
Viewing 15 posts - 8,776 through 8,790 (of 9,253 total)