Viewing 15 posts - 2,371 through 2,385 (of 2,897 total)
Not much to it. There're another 100 or so tables with this same format.:
DELETE
from TI_CMS.dbo.language_type
September 4, 2007 at 7:44 am
Idera just announced that their SQLSafe backup product also does object level restore. I already have their previous version and am eager to upgrade and try it out.
August 31, 2007 at 8:30 am
"...rewritten the same report, bringing back the same data in 30 different ways..."
Sounds like a good application of Pivot Tables. You can write the base SP,...
August 17, 2007 at 1:04 pm
select
'sp_changeobjectowner ' + ''''+'tead.'+name+''''
August 15, 2007 at 12:53 pm
So, how do I start the in-place upgrade ? I thought running 2005 setup again would prompt me for an instance, but it just tells me I already have 2005...
August 15, 2007 at 11:40 am
Based on your questions, confirm that you have the table (and DATA) well backed up before you do any deleting or truncating.
August 14, 2007 at 2:39 pm
Also, we have multiple drive arrays on our production box, so even if you're reporting off the same server, you can put your reporting DB on different drives, to reduce...
August 14, 2007 at 1:50 pm
Ideally, it should be on another server. But, since you mentioned budgeting, I suggested a different DB on the same server as a way to reduce reporting impact on production....
August 13, 2007 at 11:01 am
Depending on your setup, it might not require much in the way of funds. If you have a small group of tables that are queried a lot, you could create...
August 13, 2007 at 9:01 am
Is it just a "select" query, or it updating ?? If it's just selecting, use WITH(NOLOCK) ..... Also, you might want to consider the bigger picture and replicate to a...
August 10, 2007 at 2:05 pm
" .. LiteSpeed Pro has the added benefit of allowing object-level recovery, I have restored individual tables without having to restore the entire database. ... "
Interesting !! Very useful ! ...
August 10, 2007 at 10:43 am
Out RAID 0 drive (actually a group of drives) is used only for short term backups that are written to tape shortly afterwards.
August 3, 2007 at 9:35 am
Viewing 15 posts - 2,371 through 2,385 (of 2,897 total)