Viewing 15 posts - 8,776 through 8,790 (of 9,244 total)
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2008 at 9:25 am
kendal.vandyke (11/5/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2008 at 6:18 am
right click my computer and select properties. Change the domain and reboot. its only the servername that SQL server uses. Domain membership will just affect the accounts who can connect
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2008 at 7:02 am
me and my big mouth, forgive me it looks as though XP_FileExist doesnt accept wildcards 🙁
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2008 at 5:37 am
you shouldnt need to and personally i wouldnt use xp_cmdshell. Use one of the file access extended stored procedures to find the files in the directory and list them to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 1, 2008 at 4:50 pm
is it a default or named instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 31, 2008 at 8:03 am
create and alter index are minimally logged under simple and bulk-logged. i would set the recovery to bulk logged for index rebuilds and back to full afterwards followed by a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 29, 2008 at 3:27 pm
thats assuming he wants to strip data out 😉
personally i would always truncate and de personalise data before giving it to development
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2008 at 11:53 am
michael.anyone (10/27/2008)
shrinking is not a real choice because the DB will be at 100GB within a year
makes this post rather redundant then really as your target server will need the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2008 at 5:07 am
i would disable DHCP and assign each machine a static IP. check the hosts file on each pc to see if there are any entries in there. Its located in
C:\windows\system32\drivers\etc
or
C:\winnt\system32\drivers\etc
set...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 28, 2008 at 4:51 am
there's more than one way to skin a cat my friend 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 27, 2008 at 4:38 pm
Viewing 15 posts - 8,776 through 8,790 (of 9,244 total)