Viewing 15 posts - 8,746 through 8,760 (of 9,241 total)
Ted Stryker (11/19/2008)
There's nothing else running on the box, max server memory is set to leave 6gb for the OS and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 19, 2008 at 5:16 am
venki
you can of course also use the management studio if you prefer GUI interraction
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 4:59 pm
Leo (11/18/2008)
Why RAID 5 need minimum of 3 drives?
Leo (11/18/2008)
Disk 2 -Promise 1+0 Stripe/RAID 0 SCSI DISK (400GB FREE)
RAID 1+0, this requires even more disks than RAID 5. It would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 4:55 pm
ssismaddy (11/18/2008)
It is replicated and we can't change the recovery model....But I m all set now with the dynamic views above....Thank you
even if it is replicated you can still change...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 4:42 pm
to delete a trace you have to stop and close it
exec sp_trace_setstatus traceid, 0 --stop trace
exec sp_trace_setstatus traceid, 2 --close trace
all of this is no good until you know the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 10:53 am
SQL2005 must be licenced per virtual processor. However if you licence the physical sockets on the host box you are covered for unlimited virtual cpus\VM's on that host
check for more...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 10:50 am
Leo (11/17/2008)
I have similar situation at work. My IT guys build a Test Server for SQL 2005 and he said that we have 2 400GB x RAID 5 drives...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 5:45 am
it's also worth noting that under bulk logged and simple recovery models the following are minimally logged
ALTER INDEX
CREATE INDEX
we always set our db recovery models to bulk logged, rebuild indexes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 18, 2008 at 5:38 am
i have books from Wrox which are fantastic
Professional SQL 2005 programming
Professional SQL2005 performance tuning
I recommend these. They go into a lot of detail about the database engine (datafiles, logfiles,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2008 at 10:28 am
it could be the backup is larger than the free space available!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2008 at 10:12 am
database mirroring provides a warm standy copy of the database.
Log shipping works differently, log files are shipped to a remote database and applied. The database has 1 of 2 states,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 17, 2008 at 10:10 am
samuel.tillman (11/10/2008)
6x72GB HHDs. What I have been asked to do specifically is setup the raid configuration and the backup scheme for the Databases and Transaction Logs.
RAID 5 is ideal for...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2008 at 6:24 am
Marios Philippopoulos (11/16/2008)
I have heard that Microsoft does not officially support virtualized SQL Server installations.
untrue as far as i am concerned. I had a call open recently with MS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 16, 2008 at 6:15 am
Ninja's_RGR'us (11/15/2008)
Wow, amazing stuff, you guys should write an article about this!!!
i have been tempted for some time 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 2:33 pm
why not just run the scripts through a sql job, no need to use SSIS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 15, 2008 at 12:17 pm
Viewing 15 posts - 8,746 through 8,760 (of 9,241 total)