SQL Server

All information about the SQL Server database is stored in its system table. I wonder if you've spent more time checking system forms because you're always busy with user forms. However, you may need to do something unusual occasionally, such as all

SQL Server automatically creates a database named tempdb for use as a workspace, when you create a temporary table in a stored procedure, such as (Create TABLE #MyTemp), regardless of which database you are using, The SQL database engine will create

Another powerful new feature of SQL Server 2005 is database snapshots. A database snapshot is a read-only copy of a database that is a map of all data in a database, and determines its content by the point at which the snapshot is executed. These

In the Web, security is mainly embodied in two aspects: one is the program security, that is, to prevent the Web page in the insertion of malicious code, the other is database security, which we can often back up the database to achieve. In the

--╔════════╗--===============================║if Statement Use example ║-- ╚════════╝declare @a int set @a=12 if @a>100 Begin print @a end ELSE begin print ' No ' end--╔══════════╗--========== The ==========

Mistaken idea #25: Several mistaken ideas about filling factor It's all wrong. 25a) filling factor is always present. No, through Books Online you can see (translator: I did not find this phrase in the new version of BOL): Important: The fill

SQL Server Data tools–business Intelligence for Visual Studio 2012 installation Prompts "The CPU architecture ..." solution For now, the rapid increase in CPU frequency and the rapid growth of the number of CPUs have not been able to promote the

To wrap the print statement inside the output, you can do this /* SQL newline tab char (9) newline character char (a) return char (+)/ print ' Test ' +char + ' Name ' print ' Test ' +char + ' age ' PRINT ' Test ' +char (9) + ' Tel '

Manually grow the log file, which is actually modifying the size of the log file in megabytes The log file size below is set to 2048MB ALTERDATABASE[GPOSDB] MODIFY FILE (name=gposdb_log,size=2048) EXEC sys. [sp_helpdb] @dbname =

Part of the database tuning effort involves troubleshooting IO issues, such as the speed of IO or the inability of RAID levels to respond to fast requests under high concurrency. The most common is to see the disk's response speed per read and write,

A. Stored procedures 1. Classification of stored procedures A stored procedure is a database object that is stored in a database and can be executed by an application through one call, and Allows users to declare variables, perform conditionally,

For a system administrator, to manage multiple database servers in a network at the same time or multiple database servers that are divided into different networks in the Internet, the problem of accessing these database servers at the same time is

Brief introduction When the query optimizer (queries Optimizer) parses a T-SQL statement and selects the least-consumption execution plan from the execution plan, the specific execution is performed by the execution engine (Execution Engine). This

How do you know how efficient an SQL statement is, knowing only 3 of the following: 1. Analysis of disk activity (IO) information through SQL statement execution:set STATISTICS io on (open)/ set STATISTICS iooff (closed) 2. Time spent parsing,

Many SQL Server programmers are confused about the use of subqueries (subqueries), especially for nested subqueries (that is, a subquery that contains a subquery). Now, let's look at this question in the right way. There are two types of seed

In fact, a lot of friends have asked recovery Interval, have asked this is why, have asked how to adjust this value, so write a small blog today, once and for all. As we all know, SQL Server relies on log to ensure performance and data persistence

It is well known to mention like statements, for example, to find all users with "C" in their username, we can use the MyDatabase select * FROM table1 where username '%c% ' Here's another way to write the above function:use mydatabase select * from

Two servers with two SQL Server A, B A,B table Structure A,b the same A,b will do some insert,update,delete operation, require the data of AB to keep consistent (That is, a new data, request B also add, a change a piece of data, B also change the

I. Understanding the structure of an index The role of an index in a database is similar to the role of a directory in a book to improve the speed of finding information. Use the index to find the data, without having to scan the entire table to

The OUTPUT clause in SQL Server 2005 allows you to return data to a table variable from the Modify statement (INSERT, UPDATE, delete). Useful scenarios for DML with results include cleanup and archiving, message processing applications, and other