Viewing 15 posts - 8,041 through 8,055 (of 8,416 total)
goparaju.chandu (5/5/2009)
my d:\\ drive was full. i wnt to some space to D:\\ .
Mke sme space by delting some file you no lnger need.
May 5, 2009 at 6:55 am
tobe_ha (5/5/2009)
Excuse me. It's a INSERT INTO .. SELECTThe clustered index is on the target table.
As I said, unless the table is empty before you start, INSERT...SELECT will be fully...
May 5, 2009 at 6:51 am
tobe_ha (5/5/2009)
There is a clustered index as well.
Eh? There's a clustered index? I thought you were doing SELECT...INTO - which would be bulk logged.
INSERT INTO...SELECT into a table...
May 5, 2009 at 6:37 am
GilaMonster (5/5/2009)
tobe_ha (5/5/2009)
Is there a History where I can see, what recovery models were set in the past?
It doesn't appear to be stored in the default trace (I just checked),...
May 5, 2009 at 6:32 am
Oh yeah that's it! I knew there was some funny behaviour around log backups if a full has never been taken. Sadly I remembered it exactly backwards -...
May 5, 2009 at 6:23 am
This was wrong so it was deleted to avoid confusing anyone else...
May 5, 2009 at 6:00 am
Tobias,
It might be that the SSIS package is running the whole thing in a transaction; however the SELECT...INTO will be bulk-logged if the database is set to Simple, so the...
May 5, 2009 at 5:12 am
Hey there,
I don't normally reply where the thread-starter doesn't post a working test-rig set-up script (in SQL!) or where (s)he hasn't shown the results of his or her efforts so...
May 5, 2009 at 5:02 am
EdVassie (5/5/2009)
Wow what a lot of posts!
Yep, not bad. But nothing like the discussion that ensued over the string-splitting routines... 🙂
EdVassie (5/5/2009)
May 5, 2009 at 4:27 am
Darn it. I missed it by one day.
My one chance this year to say to RBarryYoung: "May the 4th be with you"
:crying:
May 5, 2009 at 1:19 am
Bruce W Cassidy (5/3/2009)
[font="Verdana"]I'll see your 9th century date and raise you one in 20009.[/font]
Eeeek! :pinch:
User-developed Access databases with no validation make baby Jesus cry...
May 3, 2009 at 3:22 pm
Florian Reischl (5/3/2009)
I HATE EXCEL!!
Count yourself lucky.
One of my current jobs is to redesign and transfer a database to SQL Server - from Access 2007 :w00t:
Flame-retardant coating: It is possible...
May 3, 2009 at 3:07 pm
Steve Jones - Editor (5/3/2009)
-snip-
Personally I'd lean towards separate dbs, especially as...
May 3, 2009 at 2:36 pm
Gail,
To distill that down a bit.
The whole point of the discussion is that I am challenging Michael's statement that creating separate databases was the only way to meet the OP's...
May 3, 2009 at 7:09 am
GilaMonster (5/3/2009)
You gain significantly over having multiple separate databases?
Yes. Take the OP's example where he has 13 databases.
You seem to be assuming that 13 DB2 databases -> 13 SQL...
May 3, 2009 at 6:57 am
Viewing 15 posts - 8,041 through 8,055 (of 8,416 total)