Viewing 15 posts - 196 through 210 (of 479 total)
Hi
I wouldnt say no straight out. Sure, its not ideal, but using fg's to seperate out objects (ie. data vs index or audit objects) isnt a bad thing and...
June 27, 2003 at 9:34 pm
well blow me down..
the table is empty, the space usage reported by dbcc tab and dbcc page was still marking the pages as being used by the object. This...
June 27, 2003 at 3:56 am
Hi Robert, good article, ive used this sort of technique with large data migration efforts and works well. I cant only dream for managed exception handling for t-sql in...
June 26, 2003 at 12:33 am
Hi
The biggest ive seen to date hosted in oracle is a 450Gb beast. The size is one thing, but really high throughput db's and massive numbers of users is...
June 25, 2003 at 9:41 pm
Hi there
Yep, the KISS methodology is always the best option. Wrapper in and transaction perhaps just in case there are issues, or goto temp tables first then "cutover", its...
June 25, 2003 at 9:30 pm
Hi
With the info provided, I would consider replication, simple enough and effective. Do you need to go back the other way or it will be 1-way replication only? ...
June 25, 2003 at 8:48 pm
Hi Steveo
Long shot #1 - Did you profile the statement? checking the execution plans very carefully.
Long shot #2 - any other jobs running, run perfmon at the same time with...
June 25, 2003 at 2:13 am
Hi there
Your in luck, we do this all the time, not huge numbers of users mind you (perhaps 5 concurrent max at times), but still, files are big. We...
June 25, 2003 at 2:05 am
Hi
Im an SSWUG member, its pretty good as a general portal and cheap- main thing i get from it is the daily emails re key events and happenings in 3...
June 24, 2003 at 11:36 pm
Hi
a) service account login name changed? password invalid, accont locked etc? (try admin account 1st then move back to other user name)
b) messages in the event logs?
are...
June 24, 2003 at 10:16 pm
Hi there
Its very simple, lookup BOL on "FOR XML" and have a careful read, the developers here use FOR XML RAW and whack it directly into the MS DOM for...
June 24, 2003 at 7:13 pm
use this:
create table #mytmptable (<etc>)
or the double ##
as mentioned, if you want "perm" temporary tables for general working purposes, then I would rethink what your trying to do here. ...
June 24, 2003 at 4:06 am
Hi Len
If you want any more details, feel free to email me off line, more than happy to share leasons learnt etc.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle...
June 24, 2003 at 4:04 am
hmm.. i was trying to get out of that 🙂 but no matter, thanks for the post.
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
June 24, 2003 at 2:49 am
Hi
Interesting problem..
8.00.679 SP 2 + Q316333
8.00.534 Service Pack 2
Try applying Q316333 and try again.
See http://www.krell-software.com/Resources/mssql-builds.htm
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
June 24, 2003 at 12:01 am
Viewing 15 posts - 196 through 210 (of 479 total)