SQL Server

The conceptual Data Model (conceptual) is also known as the information model. It is the abstraction of objective things and their connections, the modeling of the information world, the first abstraction of the real world to the information world,

There is a SQL2012 library of the log reached about 100G, usually developers have not done a transaction log backup, and disk space is almost full. Therefore, it can only be truncated. However, since 2k8, SQL Server seems to no longer provide

Recently want to study the SQL SERVER2012 Enterprise version of the database, heard that the function is very powerful. I installed on the Win7, the installation process is very smooth, I am using "Windows Authentication", everything OK, but when

Recently in a large-scale project, because data design uses a discrete database design to facilitate requirements change and user-defined process elements, because the user-defined features, data integrity by code constraints become less realistic,

1. Installation and Installation Mysqlconnector2. Configure MysqlconnectorODBC Data Manager, System dsn-> add->mysql ODBC 5.3 ANSI driver-> fill in the data source name such as Jt,mysql IP, user name, password3. Create a new linked serverEXEC

--------------------------------------------------------------------------------------------------------------- ------------------------------------------First Floor:The service master key, which is automatically generated when needed, such as when

Link:http://sudeeptaganguly.wordpress.com/2010/04/20/how-to-enable-sa-account-in-sql-server/Reference: When you install the SQL Server using Windows authentication mode, by default, the 'sa ' account is disabled. Sometimes, due to

Index of http://www.blogjava.net/allen-zhe/archive/2010/07/23/326966.html Performance optimizationRecent project needs, did a period of time SQL Server performance optimization, encountered some problems, but also accumulated some experience, now

SQL Server deletes all tables in the database-------------------------------------------------------------------------------------------Open SQL Server Management Studio and create a new query in the Open XXX. In the SQL file,

Reference namespaces 1 using System.Data; 2 using System.Data.SqlClient; Connection string 1 //A single instance exists in the Windows Authentication Mode database2 stringConnectionString ="Data

The address space on the 64-bit machine is bigger than before, and it's causing a lot of changes.1, MemToLeave This word does not exist, because SQL Server to no longer do this reserved space, that is to say multiple page want to use how much! As

Background:Modifying a column with an identity can make it grow automaticallyExamples are:CREATE TABLE T (ID int NOT null identity (),Data nvarchar (32));Inserting dataDECLARE @i as int = 1;while (@iBeginINSERT into T values (replicate (CAST (@i as

Here is the creation of the stored procedure, which is called when it is used./** * * * object:storedprocedure [dbo]. [Sq_paging] Script date:09/10/2014 09:57:54 * * * * **/SETAnsi_nulls onGOSETQuoted_identifier onGOCREATE proc [dbo].[Yc_pageselect]@

SceneThe company's most recent database server for SharePoint is always in trouble, and is not working properly once a problem occurs. The main thing is that we have to work overtime to restore the previous database, which is the most headache. So

Http://www.cnblogs.com/Kymo/archive/2008/05/14/1194161.htmlLet's take a look at the SQL Server Online Help related instructions begin Transaction: marks the starting point for an explicit local transaction. BEGIN TRANSACTION The @

Environment: Windows + SQL Server 2008One installation Mysql-connector-odbc-5.2.5-winx64.msiMust be installed 5.2.5, installation mysql-connector-odbc-5.3.4-winx64 will errorTwo configuration ODBCAfter installation in the Control Panel-"Management

You encounter collate conflicts when using SQL to query a table, such as:Select from [dbo]. VmimageunionSelect from [dbo]. [Dicvmimage]Get the error:468 - 9 1 "chinese_prc_ci_as" "sql_latin1_general_cp1_ci_as" in the UNION operation.The initial

Create a temporary table, #代表局部临时表, # #代表全局临时表. What is the specific meaning of local temporal tables and global temporary tables?For example, it is clearer to look at the local temporary table, "New query", enter the following text:After running,

Discussion on Transact-SQL and transactsql Transact-SQL (also known as T-SQL), is in Microsoft SQL Server and Sybase SQL Server ansi SQL implementation, and Oracle PL/SQL properties are similar (not only to achieve ansi SQL, it also provides

SQL optimization tips and guidelines To optimize queries and avoid full table scanning, you should first consider creating an index on the columns involved in where and order. Try to avoid null value determination on the field in the where clause.