SQL Server

Original: SQL SERVER memory allocation and common memory issues (2)--DMV queryMemory dynamic management view (DMV):Starting from Sys.dm_os_memory_clerks.SELECT [Type], sum (virtual_memory_reserved_kb) as [VM reserved], sum

If the data in the database is updated in real time, and the report we use to evaluate it is based on such real-time data, then we can take the SQL Server Reporting Services (SSRS) service. A more superficial scenario is that we need to look at the

The time interval for SQL Server DateTime is 3.33 milliseconds (3.33ms), so the default time for the database does not increase if you increase by 1 millisecondsC # Development timeDateTime dt=new datetime ();Dt=datetime.now;Dt=dt. Addmilliseconds (1

When you are prompted that the database is in recovery mode, rebuild the log file to resolve DBCC rebuild_log (' db_name ', ' C:\mssql7\data\dbxxx_3.LDF ')MS SQL Server provides a number of database repair commands that can be tried when the

SQL Server Auditing (Audit)--Auditing componentsThe architecture for auditing is as follows.650) this.width=650; "title=" clip_image001 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "alt=" clip_image001 "src="

SQL Server Auditing (Audit)-Considerations for using auditingmove a database that has an audit specification createdIf you move a database that has been created with an audit specification to a new server by using attach or restore, you will not be

SQL Server Ring buffer--Ring_buffer_scheduler_monitor Gets the CPU utilization of the SQL processThe ring buffer stores information about the CPU utilization. This information is updated every minute. So you can track the CPU utilization at a given

Use masterSelect Loginame,count (0) from sysprocessesGROUP BY LoginameOrder by count (0) descSelect Nt_username,count (0) from sysprocessesGROUP BY Nt_usernameOrder by count (0) descIf one of the SQL Server user name Test connections is more, view

Original: SQL Server replication-publish subscription (SQL Server data Synchronization)SQL Server synchronization is achieved through SQL Server's own replication tool, with 2 major strides in sub-publishing and subscription.A, copy-publishBefore

1. Download the Adventureworksdb.msi database file.2, put in the specified directory installation3. Open sqlserver2005 attached database.650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4D/EB/wKiom1RcZ42DgPHNAAD03qkN2x0517.jpg "title=" y8z9

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/2B/wKioL1V1n5CCsWKSAAGOd13jecU236.jpg "style=" float: none; "title=" 64.png "alt=" Wkiol1v1n5ccswksaagod13jecu236.jpg "/>650) this.width=650; "src="

SQL Server can deploy mirroring and replication at the same time, combining high availability on both sides to ensure better availability and disaster recovery for the database.About Mirroring: Database mirroringAbout Replication: Database

text and image functions　　1. Find a specific string patindexSyntax is the same as String patindex.　　2. Get text pointer textptrWhen SQL Server stores text types (ntext, text), and image data types (images), the default is stored separately from data

Original: Initial SQL Server performance issues (1/4): Server overviewWhen you are a DBA, many people will complain to you: "This program data loading and snail, you see the server is not a problem?" "There are many reasons for this problem. May be

This time we talked a lot of pages and now we can look at how these pages are organized in the data file.As we all know, SQL Server divides data files into 8k pages, which are the smallest operating units of IO. SQL Server marks page 1th in the data

Unlike programming languages such as C #, Java, in SQL Server, the initial value of a numeric type such as int is null, and the assignment operator can be assigned null, and a variable with a value of NULL cannot display its value in the message bar,

Recently encountered a more interesting problem in the project, the online search for some methods, summarized here to share.We often encounter such a scenario: the need to query data, there are some query conditions, but when the query, we hope

This article is the second of the SQL Server Agent series, please refer to the original text for more information. The SQL Server Agent job consists of a series of one or more job steps. A job step is assigned to a specific job subsystem (the

Example: DateDiff (Dd,add_time,getdate ()) not between 0 and 7Select COUNT (*) fromtable where DATEDIFF ([second], ' 2004-09-18 00:00:18 ', ' 2004-09-18 00:00:19 ') > 0DescriptionSelect DATEDIFF (Day, time1, time2) corresponds to the following

SQL Server database stored procedures Introduction, server Stored Procedures What is stored procedure If you have been familiar with other programming languages, you can understand that the stored procedure is like a method. Even if he is a method,