Viewing 15 posts - 3,931 through 3,945 (of 5,393 total)
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...
-- Gianluca Sartori
July 31, 2010 at 4:48 pm
Alvin Ramard (7/31/2010)
-- Gianluca Sartori
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...
-- Gianluca Sartori
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....
-- Gianluca Sartori
July 29, 2010 at 9:12 am
Jeff Moden (7/26/2010)
Gianluca Sartori (7/26/2010)
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
July 26, 2010 at 3:57 am
Tom.Thomson (7/25/2010)
Matt Miller (#4) (7/25/2010)
-- Gianluca Sartori
July 26, 2010 at 1:49 am
Congrats, Lynn. All the best.
-- Gianluca Sartori
July 23, 2010 at 10:51 am
Looks like a "catch-all query":
...
FROM @init init
JOIN tbl_ldf_mtgtype mtg
...
-- Gianluca Sartori
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...
-- Gianluca Sartori
July 20, 2010 at 7:47 am
select serverproperty('isclustered')
This should help
-- Gianluca Sartori
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...
-- Gianluca Sartori
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.
-- Gianluca Sartori
July 16, 2010 at 8:25 am
Tom.Thomson (7/16/2010)
Kanji is Japanese written with Chinese characters...these two versions of Yokogaki have different Japanese names
Thank you Tom. I thought that Japanese was Japanese, period. It's a very fascinating...
-- Gianluca Sartori
July 16, 2010 at 8:23 am
Viewing 15 posts - 3,931 through 3,945 (of 5,393 total)