Viewing 15 posts - 3,841 through 3,855 (of 5,393 total)
naunton (10/11/2010)
Oh sorry..I'm running it on sql2000.
but, when I run on sql2008
got error : 'Linkserver' is not configured for RPC.
Think my DBA need to do something configure on linkserver.
Yes,...
-- Gianluca Sartori
October 11, 2010 at 3:19 am
I don't think it's possible.
You can clear sys.dm_os_wait_stats and sys.dm_os_latch_stats with DBCC PERF, I'm not aware of other DMVs that can be cleared without a restart.
-- Gianluca Sartori
October 11, 2010 at 2:59 am
Are you sure you're working on SQLServer 2008? With version 2005+ this should work.
-- Gianluca Sartori
October 11, 2010 at 2:37 am
Don't shrink the database. If it grows, this means it needs the space. If you shrink it, it will grow again.
If you don't want your log files to grow,...
-- Gianluca Sartori
October 11, 2010 at 1:56 am
The description of your problem is not very detailed, so that my answer cannot be detailed either:
take a backup, upload it to the target machine.
-- Gianluca Sartori
October 11, 2010 at 1:47 am
Restore data from a good backup set. There's no "undo" command that you can issue.
If your database is in full recovery model, you can restore to a point in time...
-- Gianluca Sartori
October 11, 2010 at 1:29 am
WayneS (10/10/2010)
Jeff Moden (10/10/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.It's nice to see everyone can learn.
Heh... the lion sleeps. That...
-- Gianluca Sartori
October 11, 2010 at 1:08 am
Sergiy (10/10/2010)
Which way Capricorn is recorded in your table?
Interesting question. I'm curious.
-- Gianluca Sartori
October 11, 2010 at 12:59 am
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
-- Gianluca Sartori
October 8, 2010 at 10:21 am
PaulB-TheOneAndOnly (10/8/2010)
saurabh.deshpande (10/8/2010)
So, what they are giving new with Oracle 10g/11g.So, what's new?
Now it works 😉
Really, does it? 😛
-- Gianluca Sartori
October 8, 2010 at 6:05 am
Jeff Moden (10/8/2010)
-- Gianluca Sartori
October 8, 2010 at 3:32 am
October 8, 2010 at 1:41 am
PaulB-TheOneAndOnly (10/7/2010)
saurabh.deshpande (10/7/2010)
Thanks for Short explanation about Oracle RAC.
...
-- Gianluca Sartori
October 8, 2010 at 1:19 am
Viewing 15 posts - 3,841 through 3,855 (of 5,393 total)