SQL Servers Resource Center
SQL Servers Resource Center

sql performance

1 2

Removing Transaction Log Files in SQL Server Suspends Database Mirroring
In Microsoft SQL Server 2008, you can configure the database mirroring between two database. It improves database reliability and prevent data loss situations, if one database gets damaged due to any reason. In case of failure, you can restore the copy of your database from mirror database. However, if you unintentionally remove the transaction log files on SQL database, database mirroring session is broken by principle server.

Some of MySQL Key area of performance tuning
6 general issues to consider when optimizing the performance of mySQL

SQL Server Fragmentation Demystified
What is SQL Server defragmentation? How does it happen? How can it be measured? How can it be minimized? How can it be fixed? Is it important? The answers to these questions are no mystery. Depending on the version of SQL Server in use, the procedures to determine and correct defragmentation are not terribly complicated and in newer versions downright simple. In addition, they can be accomplished without unnecessary disruption of the system.

Storing SQL Server Databases on Network Server May Cause Corruption
Microsoft usually urges that you should use a SAN (Storage Area Network) or locally attached hard drive to store MS SQL Server database (MDF) files as this configuration improves SQL Server reliability and performance. Use of network database (stored on network server or NAS [Network Attached Server]) is disabled by default in Microsoft SQL Server. In order to ensure complete data safety and to prevent need of SQL Database Recovery, you should not use SQL database on networked server.

Advantages and Disadvantages to Using MySQL vs. MS SQL
Two of the most popular database systems used by web developers today are MySQL and Microsoft’s MS SQL server. Both are similar in regards to being storage and retrieval systems. The two systems support primary keys, along with key indices which allow you to speed up queries and constrain input. Furthermore, both systems offer some form of support for XML.

1 2


Related News:

Home Site Map

Subscribe to our Monthly Email Newsletter

Subscribe to the sqlservers.net RSS Feed

Tags:

10 Steps to Becoming an SQL Database Analyst
The position of database analyst is also often referred to as business analyst. It encompasses a wide range of analytical skills. You must be able to analyze large amounts of data. Some databases of hundreds of gigagytes and millions of rows of information.

A High Level Comparison Between Oracle and SQL Server
Organisations often employ a number of database platforms in their information system architecture. It is not uncommon to see medium to large sized companies using three to four different RDBMS packages. Consequently the DBAs these companies look for often have to have a broad range of skills across a number of areas.

SQL Server Replication for Data Storage for Your Business
SQL Server Replication is the process of replicating data from your companies database to a database stored on another SQL Server. Many don't know you can use the internet to replicate your database to third party suppliers.


Privacy Policy | Copyright/Trademark Notification