SQL Server

To connect to a remote server in SQL Server and to create and delete a new database tutorial First, create a new library /*Test in sql2005 through Query Analyzer, connect to sql2000, and create tmpdb library: Successful P_createdb ' tmpdb1 ', '

"51" When the system reinstall, without uninstalling SQL Server 2008, try to install SQL Server 2008R2, the installation prompts a successful but prompted a few errors, found no ssms, and in the SQL Server Configuration Manager services are only a

Creates a temporary table that reports errors when inserting data into a temporary table. A start prompt does not open the primary key, and then the primary key is turned on to prompt the above error exception. Find information from the Internet

An asymmetric key contains a database-level internal public and private key that can be used to encrypt and decrypt data in a SQL Server database, either imported from an external file or assembly, or generated in a SQL Server database. It is not

Background:in the process of using a database, we often want to pursue performance, especially when dealing with large quantities of data. So for SQL Server, the database is optimized for high-volume inserts, and here is a special introduction to

A few weeks ago, the latest CTP version of SQL Server 2016 had been released: CTP 2.4 (CTP 3.0 is now). This preview version contains a number of different improvements than the previous CTP. In this article I'll talk about a significant increase in

As a DBA, it is one of our responsibilities to exclude SQL Server issues, and many people each month bring us a variety of performance problems that we cannot explain. I've heard many times that previous SQL Server performance issues were fine and

1. View the version of the database SELECT @ @version 2. View the machine operating system parameters of the database EXEC master.. xp_msver 3. View Database Startup Parameters sp_configure 4. View Database Startup time Select CONVERT (varchar,

How do you get server hardware and system information through SQL statements in SQL Server? Here's how to get the processor (CPU), Memory (Memory), disk, and operating system-related information through an SQL statement. If there are deficiencies

Setting the Accesscount field can be added to the accesscount on a specific time scale if the same IP access is required. Copy Code code as follows: Create Table Counter ( Counterid int identity (1,1) not NULL, IP varchar (20),

Open SQL Server Configuration Manager, then double-click the Open Properties dialog box with the left mouse button, and then select the Advanced tab to see the version information Often used the following statements to look at version

The code is as follows: EXEC sp_rename ' table name. [Original column name] ', ' new column name ', ' column ' Transact-SQL Reference sp_rename Changes the name of a user-created object (such as a table, column, or user-defined data type) in the

1. Query all tables in sql: Select table_name from database name. Information_schema. Tables Where table_type= ' BASE table ' is executed, you can see the names of all the tables in the database that belong to you 2. Query all tables and

Environment: SQL Server 2008 R2 Question: SQL Server date, datetime, Smalldate difference Solve: Datetime Date and time data from January 1, 1753 to December 31, 9999, with an accuracy of 3% seconds (equal to 3.33 milliseconds or 0.00333 seconds)

Speaking of the tuning of SQL Server, I think everyone would like to know this knowledge. I am also exploring the way, we have any good ideas, welcome to discuss and study. Win the people's long, can avoid weaknesses. This article is mainly from

Objective:Sometimes we want to access the local area network SQL Server server, such as test environment database in the company intranet, back home or at the customer site to connect to the database in the intranetThe first step: if you can connect

The process of restoring a database file, only MDF files, how to restore? In the original SQL Server 2005, click the database directly and then attach it can be restored, but in the 2008 version of the database file will be an error (only MDF

Create a database and table for testing, to make inserting data faster, the primary key in the table is a GUID, and no index is created in the table. GUIDs are bound to be faster than self-growth, because you will have less time to generate a GUID

Explain the SQL Server database architecture and objects, define data integrity, SQL Server Preface In this section, we will continue our SQL journey. In this section, we will talk about some basic knowledge and precautions. If there are any

Detailed description of the data type in SQL Server, SQL Server Preface In the previous articles, we have explained the index-related knowledge. In this section, we will continue to explain the following content, including brief content and in-depth