Viewing 15 posts - 3,016 through 3,030 (of 3,061 total)
Some day somebody is going to tell me the truth about why SQL Server partitioning is such a nightmare.
Don't understand why. Other RDBMS developed the technology before and made it...
August 8, 2008 at 9:55 am
correct... correct... incorrect.
damn, you failed in the last one. You can take backups using RMAN even if you have set your database to NOARCHIVELOG mode. That's the beauty of...
August 8, 2008 at 9:44 am
... like Oracle's inbuilt primary key ROWID
Oracle's ROWID is not a PK. ROWID is a unique row identifier, nothing else, nothing more.
August 8, 2008 at 9:41 am
The DTS which was part of SQL Server 2000...
DTS was introduced on 7.0
August 7, 2008 at 1:47 am
I'm glad you fixed it.
Just a side note. The fact that you rebuild your indexes in a weekly basis means nothing, how if you are rebuilding once and again indexes...
August 7, 2008 at 1:45 am
You may want to start here... http://msdn.microsoft.com/en-us/library/ms190768.aspx 😉
August 6, 2008 at 7:40 am
Maybe it's 400TB because no-one has been running T-Log backups, they just added more disk space, the data could be just a few GB ?!?!? :hehe:
😀 You made may day....
August 6, 2008 at 7:37 am
I see, you are affected by CAS -short for Crappy Application Syndrome.
CAS is a serious condition the only cure is major surgery -kill the CAS causing agent but in some...
August 6, 2008 at 5:52 am
Dear Ehsan --
Firstly I'm not saying I know everything. I'm saying I know what a Oracle backup is and what a Oracle backup is not.
Secondly. You are correct, I was...
August 6, 2008 at 5:34 am
Here is what I would do...
1- RDC into the remote box.
2- Open SSMS and open the local server
3- Run select @@servername to get the actual instance name.
4- Check error log,...
August 6, 2008 at 4:44 am
Any reason why you don't do something like...
UPDATE intv_schedule
SET program_id = (
...
August 6, 2008 at 4:23 am
Gotcha, your "clients" are actual SQL Server engines.
-Can you ping the remote box by DNS?
-Can you ping the remote box by IP?
-Does the remote "client" SQL Server engine has a...
August 6, 2008 at 3:54 am
Let me summarize your "concepts"...
Exp/Imp based backup strategy?
Daily Cold Backup?
Daily Cold/Hot Backup followed by full Export?
Full Database Reorg?
At first sight I would say -very politely: "what a pile of crap!!!"......
August 6, 2008 at 3:43 am
Not sure if I follow you.
Is your problem that you are unable to access a client station from the server?
If this is the case... are you actually talking about...
August 6, 2008 at 3:31 am
Yes, I have a doubt.
Other that what's the reason you guys do not read what I write... my doubt is: what a big pile of rubbish!!! from which paralell Universe...
August 6, 2008 at 2:00 am
Viewing 15 posts - 3,016 through 3,030 (of 3,061 total)