Viewing 15 posts - 8,746 through 8,760 (of 9,248 total)
Mike Levan (11/20/2008)
which is faster and best(performance) approach when compared with moving database files and attach or restoring backup file.
i have found detach, copy and re attach generally quicker
November 20, 2008 at 12:08 pm
if you're uncomfortable with T-SQL you can via management studio drill down through tables to the index level and right click then select rebuild all
November 20, 2008 at 12:06 pm
splitting tables uses partitioning.
Fill factors are used for index build operations and determine the fill level of the leaf pages.
do you mean partitioning tables?
November 20, 2008 at 8:18 am
rbarryyoung (11/17/2008)
venkat.saginath (11/17/2008)
If the user complaint you that application is running very slow. As a DBA where do you start your work ???
Usually on my cell phone as...
November 20, 2008 at 6:19 am
that's not how it works, a virtual CPU has no knowledge of cpu cores. The physical host is licenced per physical socket. You need to weigh up your licensing requirements....
November 19, 2008 at 6:14 am
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...
November 19, 2008 at 5:16 am
venki
you can of course also use the management studio if you prefer GUI interraction
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...
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...
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...
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...
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...
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...
November 18, 2008 at 5:38 am
Viewing 15 posts - 8,746 through 8,760 (of 9,248 total)