Label:Original: SQL Server DBA work detailsIn a Microsoft SQL Server 2008 system, the database administrator, or DBA, is the most important role in the administration. The DBA's goal is to ensure that the Microsoft
In a Microsoft SQL Server 2008 system, the database administrator (DB administration, referred to as DBA) is the most important role. The goal of the DBA is to ensure that the Microsoft SQL Server 2008 System runs normally and eff
Programmers who write large terminals often have the illusion that the SQL language is simple and the DBA works easily, especially for Android programmers who are accustomed to SQLite and its extended framework Ormlite and Greendao. Especially when an Android programmer sees himself in college and hangs up and repeats his lost friend after working as a DBA: "If y
2YearSQL Server DBAOptimization Summary
When I was a dBA for two years, I felt that some things needed to be shared and discussed with you.
Book order
1. "in-depth analysis of SQL Server 2008 series" is the technical insider series of MSSQL 2005. I am also interested in version 2012. The technical insider series is my
Many developers want to be a DBA, and a lot of people start by positioning themselves as a dba,dba. What kind of knowledge and skills do you need to know? Here's myWhile doing DBA work and interviewing DBAs, some of the 30 DBA issues that have been collated, as well as the s
Why does the SQL Server DBA learn PowerShell?
From: http://www.simple-talk.com/ SQL /database-administration/why-this-sql-server-dba-is-learning-powershell/
Joe. TJ is used only for the
In the company, go into the sales Vice President's office and ask how many salespeople he has.No, I mean you don't have to do that, they'll ask you why the sales tools are so slow. In fact, I mean, if you could just go into his office and ask him the question. I bet he'll answer right away, without a moment's hesitation.Or you go into the CEO's office and ask him how many employees he has, or what the CFO's annual budget is, and they're sure to answer quickly. So my point is that when you're in
Tags: organize return index blog SQL Server point ref href 64 bitOriginal link: http://www.cnblogs.com/fygh/p/3288701.htmlFrom the initial release of SQL Server DBA Eve asked for more than a year, you have some of the issues discussed more intense, to answer these questions
-- The above two phrases will intercept the transaction records, as long as they are executed, the transaction record is not successful until the next complete preparation!-- subtract log the size of the file (LOG file name reduced by up to DBCC Shrinkfile (beedb_log,+)/******** The position of the DB ********/-- Check the location of DBSelectname,Physical_name fromSYS.master_fileswheredatabase_id=db_id(' Salepony ')-- swap out the location of the DBAlter Database Salemodify file
a diagram of the MySQL database structure:MySQL database in the storage engine part of the implementation of pluggable design (pluggable Storage Engines), you can choose different types of storage engine implementation according to the requirements.
Feature
InnoDB
MyISAM
Memory
Storage Limits
64TB
256TB
Ram
Transactions
Yes
No
No
Locking Granularity
Row
Table
Tags: structure resource partition table cannot dba resolves emergency temp SQL1. Talk about the difference between clustered index, nonclustered index, hash index and their merits and demerits, include covering index's function, relative to the advantage of composite index; 2. What is the structure of the log file, what is the difference between the data written to the log file and the data file, the reason why the log file cannot be shrunk, what the
concerned about those indicators (including SQL Server and Windows), how to develop performance baselines, which monitoring software you have used;26. Database migration steps; rebuild a larger set of test systems (minimum of 10 db instances), if the original DB data volume is not large, but DB is more, the new system data are not needed, how to quickly achieve;27. Create cluster brief steps, require a min
10 errors that SQL Server DBA can easily commitTranslated from: http://sqlsentry.tv/top-10-administrative-mistakes-on-sql-server/In addition to the top ten mistakes, other top-ranked errorsAside from SQL
a lot of time, and the speed is slow
2. MASTER: it contains a system table set, which is the central repository of the entire instance. It maintains logon accounts, other databases, file distribution, system configuration settings, disk space, resource consumption, endpoints, andLink to the server. It records sql2005 initialization information, so it is extremely important to the instance. In the process of creating, modifying, or deleting a user dat
The only reason for backupThe only reason for the backup is that we can restore when I first became a SQL Server database administrator, as long as the backup work can run successfully, I feel that everything is fine. I'll look at the SQL Server Agent to make sure those jobs are running, and that's it.I think as long a
Map location.If you want to query the definition of a catalog view, you can use the Object_definition function or sp_helptext to query.SELECT object_definition (object_id('sys.tables'));EXEC ' sys.tables ' ; EXEC ' sys.tables ';There are some other ways to access SQL Server metadata information:
Information Architecture view (information schema views)
Systems functions (System Functions)
s
TechTarget Reporter was fortunate enough to interview SQL Server consultant and popular blogger, Denny Cherry, in June. He talked about three things that SQL Server DBA needs to know, and describes the trends in SQL
to remove the space on both sides!) nvarchar (n): A variable-length Unicode character data that contains n characters. The value of n must be between 1 and 4,000. You can store up to 4,000 characters, both English and Chinese, in 2 characters. varchar: If the possible value of a field is not fixed length, we only know it cannot exceed 10 characters, it is the most advantageous to define it as varchar (10). Stores variable-length data, so it does not fill with spaces, but storage efficiency i
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.