Viewing 13 posts - 91 through 103 (of 103 total)
If the Database does not allow downtime, you're hosed with the Create CI and Drop trick. (can you imagine if the table has millions of records?)
the BEST option is to...
January 15, 2008 at 4:34 pm
been there done that.
I do NOT Miss "errors and omissions insurance"
and I do NOT Miss making Collections calls.
Other than that, Self Employed route can be quite nice.
January 15, 2008 at 1:28 pm
You pretty much need a clustered index.
any reason why you dont want a ci on the table ?
January 14, 2008 at 12:35 pm
yes the next step depends on what you wish to do.....
Data Architect would be a good next step
Management Positions would possibly make sense
Product Management ???
Project Management ???
Sr. DBAs might be...
January 14, 2008 at 12:20 pm
All too often I see performance problems in production environments due to RAID5 or RAID6 configurations.
You will most definately want RAID 1+0 or 0+1
It's spendy, but hey....it's a production...
December 27, 2007 at 1:58 pm
On another note....
Sure you should try to determine what indexes are needed up front however, index tuning is an on going task for the skilled DBA and Architect.
Dont feel that...
December 27, 2007 at 11:37 am
I used this today to help troubleshoot some production issues.
I cleaned the script up a bit in the following ways:
1. included a "USE MSDB" statement at top because...
December 26, 2007 at 12:58 pm
either make the datatypes identical (The best option IMHO) or just do a CAST in your select when you retrieve the data
Cast(ID As BigInt) As ID
December 11, 2007 at 7:17 pm
conceptually looks good but I'd be afraid of running out of space.
You stated that your DB is ~70GB today. How fast is it growing ?
what kind of activity is on...
December 6, 2007 at 2:07 pm
Thanks for the reply.
Our system is very write intensive.
Even our Reporting sprocs do tons of writes to tempTables before writing out final results.
we are working feverishly on removing all temp...
December 22, 2006 at 8:58 am
this is great info. Thanks for the reply.
December 19, 2006 at 10:47 am
well...I dont "Know" that the location of TempDB is the problem.
I "Suspect" that it is.
I want to be able to definitively prove if my hunch is right or wrong.
December 15, 2006 at 3:06 pm
Involving them early can reduce major problems late in the game.
If dev meetings have ZERO impact on Database, then make invite optional.
Gregory A Jackson MCSD, MCT
November 21, 2003 at 8:29 am