Create knowledge
[?]
|
(rate this)
|
 |
anjali khandelwal
| Answered
| 2 years ago
|
|
Expand Databases. Depending on the database, either select a user database or expand System Databases, and then select respective database. Right-click the database, point to Tasks, and then click Restore, then select from databse /from device...
|
|
 |
Thanigachalam T
| Answered
| 2 years ago
|
|
please Refer http://msdn.microsoft.com/en-us/library/ms187510.aspx http://msdn.microsoft.com/en-us/library/ms177429.aspx
|
|
Answer: "How to: Restore a Database Backup (SQL Server Management Studio)" deleted from your view.
|
(rate this)
|
Top 5 DBA tasks that are a waste of time Some tasks performed by DBAs on a regular basis not only have little to no benefit to SQL Server, but can actually be detrimental to the health of their environments. #1. Shrinking the database Daily shrinking of the database is bad for a few reasons. From the technical side, the biggest impact you will see is a greatly increased index fragmentation after each database shrink. In addition, shrinking the database files increases both the physical file fragmentation on the disk subsystem and the I/O load on the server, which decreases performance for other functions while the shrink operation is running. Now it isn't the actual shrinking of the d...
 |
Maruf khan
| Commented
| 2 years ago
|
|
Mr Atul i m to a DBA and having 4+ years of experience in this field i can challange u that the dba task which have specified are the junior dba level task u can do the automation of this task and the way dba works no other can work i can debate u...
|
|
|
|
Thanigachalam T
| Commented
| 2 years ago
|
|
Good Article!!!! But the DBA is the "Mother" for Database, who Taking care of the Database without Downtime. These activities are very import for the DBA's and its day to day activity, which will make database health down. We can still handle this...
|
|
 |
Prarthana Devi
| Commented
| 2 years ago
|
|
Nice article Mr. Atul, one can look at the role of DBA in this way also, but whatever it may be, the importance of DBA cannot be denied in an organisation.
|
|
Insight: "DBA Waste of Time" deleted from your view.
|
(rate this)
|
1
Its very fast because SQL Server Database Engine tracks the changes
2
Backup Method Advantages and Disadvantages
|
|
Thanigachalam T
| Added idea
"Its very fast because SQL Server Database Engine tracks the changes"
| 2 years ago
|
|
Incremental Backups is the best method to use in large scale databae(TB) and 24/7 DB, which will take more more resources of the system. This will make more performance issue for end users. To overcome this we can use Incremental...
|
|
 |
ravindra shrivastava
| Added idea
"Backup Method Advantages and Disadvantages"
| 2 years ago
|
|
method:Advantages Files are easy to find - Since full backups include all data contained on a device, you don’t have to search through several media to find a file that you need to restore. There is always a current backup of your entire system...
|
|
Ideate: "What Are the Benefits of Incremental Backups?" deleted from your view.
|
(rate this)
|
|
|
md majid akhter
| Answered
| 2 years ago
|
|
SQL is a language while oracle is RDBMS.Basically you write the SQL query into interface provided by Oracle (SQL* loader ) which compiled and execute by oracle DataBase Engine.
|
|
|
|
Thanigachalam T
| Answered
| 2 years ago
|
|
SQL is a “Structured Query Language” which is English based. PL/SQL (Procedural Language) or TSQL (Transactional) are extension to SQL.
|
|
Answer: "Is Sql A part of Oracle.Or they both are same" deleted from your view.
|
(rate this)
|
|
|
Thanigachalam T
| Answered
| 2 years ago
|
|
start your learning skill with oracle/SQL Server, look into sql queries and learn the concepts. "Technology may change but the Terminologies will be same".
|
|
|
|
Thanigachalam T
| Answered
| 2 years ago
|
|
start your learning skill with oracle/SQL Server, look into sql queries and learn the concepts. "Technology many change but the Terminologies will be same".
|
|
Answer: "how can i start up with DBMS and sql as a beginner(which dbms is worthy to start with?)" deleted from your view.
|
(rate this)
|
|
Yes
|
5
|
VS |
1
|
No
|
|
|
Thanigachalam T
| Argues in support of
"Yes"
| 2 years ago
|
|
Yes, This will be supported for SQL SERVER. Already we are using this in our environment.
|
|
 |
Harshil Shukla
| Argues in support of
"No"
| 3 years ago
|
|
I think so that Database Virtualization is not total worth, because for it we need each and every database like Oracle, MySQL, MS-SQL etc. to come on an one platform, also cost of creating virtual database and actual database, if there will be one...
|
|
Debate: "Database Virtualization - Is it worth it ?" deleted from your view.
|
(rate this)
|
1
7 Parameters of highly effective IT strategy
2
IT strategy should be quantifiable
|
|
Thanigachalam T
| Supported idea
| 2 years ago
|
|
Thanks,
|
|
 |
Ajay Ziz
| Added idea
"IT IS JUST A MEANS OF REALISING ORGANISATIONAL GOALS."
| 2 years ago
|
|
IT IS JUST THE CATALYST WHICH ENHANCES THE CHEMICAL REACTION OF ACCELERATING THE JOURNEY TOWARDS ORGANISATIONS END GOAL :: I.E SURVIVAL : PROFITABILITY AND BECOMING AN ETERNAL ORAGANISATION::
|
|
Ideate: "What are the parameters that will decide the IT strategy for an enterprise?" deleted from your view.
|
(rate this)
|
|
Oracle 11g
|
10
|
VS |
9
|
Microsoft SQL Server 2008
|
|
|
Ray Adams
| Argues in support of
"Microsoft SQL Server 2008"
| 1 year ago
|
|
Price, price and price again. MS SQL 2008 R2 even in standard edition has more features than Oracle Standard. MS SQL license is affected by physical CPU only , not by amount of cores in CPU. So why should I pay twice and more for less...
|
|
|
|
Thanigachalam T
| Argues in support of
"Oracle 11g"
| 2 years ago
|
|
I work for Oracle SQL Server, Mostly i can see SQL Server has implemented the Oracle Core methods like Schema based system, merge statements, ..... I can saw oracle is MASTER COPY.
|
|
 |
Alok Saxena
| Argues in support of
"Oracle 11g"
| 3 years ago
|
|
I definately recommend Oracle 11g even though I never used it. You short description dose give all answer of your question. Oracle is a very powerful, reliable and secure database . No doubt sql server 2008 also have those capibilties. It's good...
|
|
Debate: "Oracle 11g vs. Microsoft SQL Server 2008" deleted from your view.
|
(rate this)
|
|
SQL SERVER 2008
|
12
|
VS |
6
|
MY SQL
|
|
|
andri tjiu
| Argues in support of
"SQL SERVER 2008"
| 2 years ago
|
|
for most of my project SQL Server 2008 provide the best performance for big data
|
|
|
|
Thanigachalam T
| Argues in support of
| 2 years ago
|
|
SQL Server 2008 will provide best performance compare to MY SQL.
|
|
 |
Dennis Aries
| Argues in support of
"SQL SERVER 2008"
| 2 years ago
|
|
There is very little difference in performance in the two of them. MySQL performs better on the Unix/Linux-platform and improves when 64bit-OS is used. Thanks to the database-structure, the isn't that much CPU needed for accessing the database....
|
|
Debate: "Which one is best in performance SQL SERVER 2008 or MYSQL" deleted from your view.
|
(rate this)
|
|
Yes
|
10
|
VS |
15
|
No
|
 |
Aishwarya Kapoor
| Argues in support of
"Yes"
| 1 year ago
|
|
Having read certain scriptures, we should not be aloof that this age is of total tyranny and requires an individual to invest trust and faith in *higher sources*... These higher sources include GOd, Guru, Parents, etc... But talking about a guru,...
|
|
|
|
Thanigachalam T
| Argues in support of
| 2 years ago
|
|
Its realy waste of time...
|
|
 |
SARVESH KUMAR SINGH
| Argues in support of
"No"
| 2 years ago
|
|
It can b taken into consideration that exception doesn't make a rule ...but what is the use to follow such gurus n make them comparable to god...n once they dont come to ur expectation u start making his life hell as well as their follower too...
|
|
Debate: "Yet Another Godman caught in a scandal , & its Sex once again." deleted from your view.
Follow me on
