SQL Server

PROFESSIONAL SQL SERVER? Internals and Troubleshooting a book (downloadable from here), I think the content is very good. I also want to have a more comprehensive understanding of SQL Server 2012, so look at the translation, and the focus of the

1. Click Start-Program--microsoft SQL Server 2008--Performance tool--sql Server Profiler, such as:    2. Then go to SQL Server Profiler window:    3, in the work window pops the Data Connection window, enters the data connection the server and the

Reprinted from: Http://database.51cto.com/art/201108/282631.htmBULK insert how to efficiently import large amounts of data into SQL ServerIn this article we describe in detail how bulk insert can efficiently import large amounts of data into a SQL

There is three DMVs you can use for track tempdb usage:Sys.dm_db_task_space_usageSys.dm_db_session_space_usageSys.dm_db_file_space_usageThe first and then allow you to track allocations at a query & session level. The third tracks allocations across

The entire backup process can be divided into the following two major steps:First, the database of the target SQL Azure is backed up to the local by "Export data-tier Application", the detailed steps are as follows:1. Start SQL Server Management

Lock a table of a databaseSELECT * from table with (HOLDLOCK)Note: The difference between a table that locks a databaseSELECT * from table with (HOLDLOCK)Other transactions can read the table, but cannot update the deleteSELECT * from table with

Data dictionary is a good thing, for development, maintenance is very important.However, it is not convenient to write the description in SQL Server, how to simplify and add the modified extended attributes in bulk?It would be nice to add 2 tables

First, the problem descriptionWhen I first loaded SQL Server 2012, I chose Windows Authentication, and now I want to add a user with SQL Server authentication.Second, specific ideas1. New User2. Add the new user to the appropriate database user list3

Method 1:1. Open the query analyzer and enter the command Backup log database_name WITH NO_LOG 2. Choose "Enterprise Manager"> "right-click the database to be compressed"> "all tasks"> "shrink Database"> "contract file"> "select" Log File ">"

Mssql function DATENAMECopy codeThe Code is as follows:SyntaxDATENAME (datepart, date)ParametersDatepartIs part of the returned date. The following table lists all valid datepart parameters. The user-defined equivalent variable is invalid.DateIs an

What method should I use to remotely connect to the SQL server? The following describes how to remotely connect to the SQL server for your reference. Check whether the IP address of the ping server can be pinged. This is to see whether the physical

All right, go to the database log to search for it and use the time and keyword for batch configuration .. You can use all that you can think.First, assume that you have executed it. No? Okay, either it's too simple, or you're too simple ..Copy

I recently transferred from the client to the backend writing service. It is completely a small bit of white for the background database and service writing, so there is definitely not much technical content recently written.First, let us figure out

At any time, as long as the system has multiple devices and the performance of these devices is different, there is a possibility of constantly changing the work location from a slow device to a fast device to improve the system performance, this is

The Microsoft SQL Server table should not contain duplicate rows and non-unique primary keys. For the sake of conciseness, we sometimes refer to the primary key as "key" or "PK" in this article, but this always indicates "primary key ". Repeated PK

The following is an example:Two tables, SourceTable and TargetTable, are logon tables. If the user accesses the login table, update the authorization level of the authorization table. Otherwise, authorization 0 indicates the visitor. The SQL

The usage is as follows:Copy codeThe Code is as follows:-- ===================================================== ======-- Author: cynimoon-- Create date: 2009-10-09-- Description: sample stored procedure-- ============================================

Copy codeThe Code is as follows:Drop table data TABLE name (permanently delete a data TABLE)Delete record: delete from table name where condition (rqjs_id = ***)Update all records: update table name set field name = ValueConditional update: update

In programming languages with large numbers, the code is processed in the encoding order, but in SQL, the first clause to be processed is the FROM clause. Although the first SELECT statement appears, but it is almost always processed.Each step

Today I received a task with a student information table (Excel table) containing more than 10 thousand records. Now I want to import this table to the database and set the student ID as the primary key, but now the student ID in this table has