SQL Server

We all know that SQL server log files are used to record transaction logs. However, the SQL Server database engine divides each physical log file into multiple virtual log files for management. In addition, the number of backlogs affects the

DBCC commands are very easy to use, but there are a lot of syntax for commands. How can we quickly remember them? Whether or not all data needs to be backed up. Actually, you don't need to. You only need to know the role of each command and remember

A few days ago, I saw someone asking why I couldn't see SQL server statistics on a table. This table is a newly created heap table with no indexes and has never been accessed. To answer this question, we need to go back to how SQL Server creates and

A table named TQ has the following structure:Tq1, varcharTq2, varcharIn the Enterprise Manager, create a stored procedure:Create procedure inserttqAsInsert into TQ(Tq1, tq2, tq3)Values('A', 'B', 'C ')GoThere are no errors in the syntax of Several

This is a new method. It is actually a technology that has been used for a long time! In. net, you know that you can use system. Web. Mail to send emails. Verification is supported in Framework 1.1. Private void page_load (Object sender, system.

The table user1 contains the field ID, username, email, and address. The delta2_user1 table contains the field ID, username, email, address, and status. When table user1 inserts a record, a record is also inserted in delta2_user1, and 'insert' is

Suppose I have an array: A (1) = 111, A (2) = 222, A (3) = 333 ......W I want to pass the array into the stored procedure, but sqlserver does not support arrays. Search for Baidu and find a strong method:1. First convert the array into a string

Sysaltfiles: files stored in the database in the master database Syscharsets primary database character set and sorting order Sysconfigures master database configuration options Current configuration options of the syscurconfigs master database

Many developers want to be a database administrator, and many people first position themselves as a DBA. What knowledge and skills do DBAs need to master? The following are some of the thirty questions I have asked about DBAs during my DBA job and

It is worth noting that you must set it in classpath.Commons-dbcp-1.2.2.jar; commons-pool-1.4.jar; naming-common.jar the path to a fileThese three files can be downloaded directly from the Apache website. If Tomcat is installedYou can also

Hash is used in many system designs, including OS and SQL Server, to greatly improve the system performance. In fact, we can also use the hash function of SQL Server to achieve the same effect. For example, you can create a hash index for text with

In Part1, we mentioned that you can use fn_dblog to view active logs. However, if the logs are backed up, can we still view them? The answer is yes. Use fn_dump_dblog.   Below is my own test: 1. -- insert data to table Insert into

In some cases, familiarity with the use of SQL Server wildcard can help us solve many problems.   -- Use the _ operator to search for the names of the three letters ending with an in the person table Useadventureworks2012; Go Select firstname,

I have a question on the internet today: Does the SQL Server Computing column occupy space? In fact, you can find out the result by checking the msdn or Bol. When creating a calculated column, you can specify persisted as a parameter. You can use

In sqlserver 2012 always on, we can create an availability group listener to provide client connections to the database of the given availability group. The availability group listener is a virtual network name (vnn) that the client can connect to

A friend once asked me if my data was deleted and when it happened without using a third-party tool. SQL Server provides an uninitialized ented function fn_dblog, which allows us to view the active transaction log. Syntax: : Fn_dblog (@ startinglsn,

SQL Server Profiler templates http://msdn.microsoft.com/zh-cn/library/ms190176.aspx You can use SQL Server Profiler to create a template and define the event classes and data columns to be included in the trail. After defining and saving the

The SQL Server developer T-SQL functions interview questions Written by: Jeremy kadlec From: Http://www.mssqltips.com/tip.asp? Tip = 1588 ProblemIn the latest installment of the mssqltipsInterview question series we are going to cover questions on T-

Updlock The update lock is used when reading the table, instead of the shared lock, and the lock is kept until the statement or transaction ends. Updlock allows you to read data (without blocking other transactions) and update data later. It also

In the software development process, we often encounter database promotion problems for many reasons, such as acsess access speed ratio.SQLServer slow, after deleting data recordsAccessWill leave a blank file, the file is getting bigger and bigger