Viewing 15 posts - 3,931 through 3,945 (of 5,394 total)
Alvin Ramard (7/31/2010)
GilaMonster (7/31/2010)
Looks like the data transfer should be done around 6am this morning. Then some schema checks, some backups and outa here.
Doesn't sound like a good weekend but...
August 2, 2010 at 1:26 am
BTW, it's sunday, 1.00 am and I'm taking backups of a 800 Gb Oracle database.
Tomorrow I will have to restore it on a different server and I don't have the...
July 31, 2010 at 4:48 pm
Alvin Ramard (7/31/2010)
July 31, 2010 at 4:43 pm
GilaMonster (7/29/2010)
Gianluca Sartori (7/29/2010)
... it's by design, beacase the tables were initially loaded with NOLOGGING optionAnd people still ask for a way to run SQL transactions without any logging....
I...
July 29, 2010 at 10:35 am
For those who are interested I've got a similar trick for Oracle.
It's very simple: just run restore database...
I've just restored a 300GB database to discover it's corrupted in many datafiles....
July 29, 2010 at 9:12 am
Jeff Moden (7/26/2010)
Gianluca Sartori (7/26/2010)
July 26, 2010 at 6:37 am
Tom.Thomson (7/26/2010)
Gianluca Sartori (7/26/2010)
Microsoft dumbness??? This reminds me of a recent discussion on TRY/CATCH...:-P(Just kidding, not trying to compare any of you to Mr. Doobya, but I couldn't resist:-))
Well, just...
July 26, 2010 at 5:53 am
Jeff Moden (7/22/2010)
Maybe that's true in Oracle but it's not true in SQL Server. Oracle is mostly rule based and SQL Server is cost based.
I'm glad you commented...
July 26, 2010 at 3:57 am
Tom.Thomson (7/25/2010)
Matt Miller (#4) (7/25/2010)
July 26, 2010 at 1:49 am
Looks like a "catch-all query":
...
FROM @init init
JOIN tbl_ldf_mtgtype mtg
...
July 23, 2010 at 10:11 am
Generally speaking, EXCEPT, INTERSECT and UNION compare all the fields in the input queries, so it's not always what you want to do.
Anyway, it's just the actual execution plan that...
July 20, 2010 at 7:47 am
select serverproperty('isclustered')
This should help
July 20, 2010 at 7:31 am
Jan Van der Eecken (7/16/2010)
He Gianluca, come down here. It's a sweltering 10deg C today in Cpe Town, and JoBurg is even colder.
Last winter we had -12°C once, and...
July 16, 2010 at 9:42 am
Paul White NZ (7/16/2010)
Hey Tom,You know Gianluca's Italian, right? 😛
Paul
Just one half, if you're talking about blood. 😉
BTW, the Scottish half doesn't feel comfortable with today's 36°C here in Venice.
July 16, 2010 at 8:25 am
Viewing 15 posts - 3,931 through 3,945 (of 5,394 total)