Viewing 15 posts - 136 through 150 (of 265 total)
Great series of posts....
I never work on oracle but it was really great to know all this....
Though I tried to consolidates all that discusstion but due to confrontations of opinions...
December 22, 2003 at 2:55 am
Make sure you have SQL Analysis services experience, before replying on this...Please put reference of sql central on the mail...
Prakash Heda
December 22, 2003 at 1:27 am
As far as I remember I used to do this by shrinking the second log file and then remove.
Prakash Heda
December 22, 2003 at 1:23 am
There are many tools available to access some common machine which you can use for sql changes. User can connect to such machines and do their job....
Netmeeting is free...
like that...
September 1, 2003 at 9:11 pm
No direct way to do that....
You can try "log explorer" to generate script for the changes made to one of the database and can implement those changes to other database....
Cheers..
Prakash...
August 29, 2003 at 1:32 am
Use this syntax to change recovery state...
restore database northwind with recovery
Change northwind with database name...
Let me know what happened
Cheers..
Prakash Heda
Sr Consultant DBA
Bangalore, India
Chat: hedafriends@yahoo.com
August 27, 2003 at 8:41 pm
would be great to see this code... please post...
Cheers..
Prakash Heda
Sr Consultant DBA
Bangalore, India
Chat: hedafriends@yahoo.com
August 27, 2003 at 2:25 am
Provide an alias to this table...
SELECT *
INTO #temp
FROM (Select * from TBL_test) ttttt
Cheers..
Prakash Heda
Sr Consultant DBA
Bangalore, India
Chat: hedafriends@yahoo.com
August 27, 2003 at 1:08 am
Just an addition to all.... NIC card is probably the culprit and 100 MBPS NIC's capability is to transfer data is maximum 44 GB an hour.. see if that's the...
August 27, 2003 at 12:42 am
Quite interesting, Keep me in the loop...heda_p@yahoo.com
Prakash
August 26, 2003 at 10:45 pm
I have vb then just generate the connection string from ther and use this...
Other thing remove the unneccessary steps from ur code ur purpose should be to test the connection...
July 31, 2003 at 2:34 am
here's some more details....
I am having some 50+ customer boxes to connect and run one common script on them instead of going to one and one which is a time...
July 24, 2003 at 5:57 am
Come on guys no reply's?? just tell me if it's possible or not? a pointer would be great.....
Prakash
July 24, 2003 at 12:34 am
AS far as performance is concern it will degraded as the columns added...
If one table is having 200 columns and current size of the data in each row comes to...
June 24, 2003 at 4:18 am
Viewing 15 posts - 136 through 150 (of 265 total)