Viewing 15 posts - 8,731 through 8,745 (of 9,244 total)
naushi (11/21/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:21 am
Michael Earl (11/21/2008)
Your admin should be carving these out of individual physical disk arrays. They often really need different RAID configurations.
couldnt agree more, does your SAN admin understand the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 3:17 am
is it absolutely necessary to have dev databases that large??
at most a small subset of data is usually good enough, 400GB is a bit OTT.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 2:51 am
i always prefer a fresh install, that way the original server remains available
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 23, 2008 at 2:46 am
i'm still trying to decipher the last post :blink:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 22, 2008 at 5:43 pm
if using database mirroring be sure the network connection is stable otherwise you could end up with unwanted fail overs. Log shipping would be more preferrable, but it depends on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2008 at 7:37 am
what columns does the table have?
which column(s) were you thinking of creating the index on?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2008 at 3:35 pm
are you running server side trace or through profiler?
what events are you capturing?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2008 at 3:17 pm
try this link
http://sqlug.be/blogs/wesleyb/archive/2007/07/25/memtoleave-issue-in-sql-server-2000-x86.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2008 at 2:59 pm
sounds like a job for SSIS!
replication doesnt replicate all objects, for instance if one of your tables has no PK it will not replicate. Then you have all the stored...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2008 at 12:37 pm
how much cash do you have basically, clustering will cost more to implement and administer
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2008 at 12:33 pm
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2008 at 6:19 am
Viewing 15 posts - 8,731 through 8,745 (of 9,244 total)