SQL Server

1. Common analysis statementsDBCC freeproccache -- clear CacheDBCC dropcleanbuffers -- clear the Buffer Zone -- Get performance informationSet statistics profile on Set statistics Io on Set statistics time on Use the set statistics XML on

Run SQL Server Profiler to generate and connect to the database. Normal. When you click Run To Start tracing, the error "only TrueType fonts are supported. There id not a TrueType font" is returned ". Microsoft has made great progress. It seems that

When the log file is full and the SQL database cannot write the file, you can use either of the following methods:Method 1: Clear logs.1. Open the query analyzer and enter the commandThe following is a reference clip:Dump transaction database name

  Method 1:Step 1:BackupLogDatabase_name with no _Log Step 2:Compress all data and log files of a specific database and execute DBCC shrinkdatabase (database_name) Method 2: Another method is risky becauseSQLServer log files are not written to

N a long time ago, I read the technical insider's section on CPU analysis. I wrote one article, but before I finish writing it, I have something to do. Later I thought I had published it. I saw it in the draft box today. I sorted it out and

Why does the SQL Server DBA learn PowerShell? From: http://www.simple-talk.com/ SQL /database-administration/why-this-sql-server-dba-is-learning-powershell/ Joe. TJ is used only for the purpose of disseminating information. Windows Management

Data Page cache is the main aspect of the memory usage of SQL Server, and also the most occupied part. On a stable DB Server, the memory usage is relatively stable. SQL Server caches frequently used data in memory (that is, data page cache) to speed

Category: Miscellaneous SQL Server knowledge point 2010-05-15 554 people read comments (2) collect reports SMOIs the abbreviation of SQL Mangagement Objects. It corresponds to ADO. Net. However, the difference is that ADO. Net is used for data

I used to understand concepts. I have no in-depth understanding. I found some materials for study last night. Take notes on your understanding. When you are doing something, you can directly splice SQL statements with databases, and rarely use

An example of a stored procedure with output parameters: Alter procedure [dbo]. [GetCustomers](@ Rowcount INTOUTPUT)ASSELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone],

First, I declare that this is my answer. It is not an official answer. Do not blindly pursue it because I think this question is representative and many people want to know it, by the way, you can also score yourself. Because I usually use sqlserver2

-Deadlock. In short, two or more trans simultaneously request an object being requested by the other party, causing both parties to wait for each other. A simple example is as follows: Trans1 trans2 ---------------------------------------------------

The following script demonstrates how to use a Gmail account in SQL Server 2005/2008 to configure the database email function.   -- ===================================================== ============ -- Enable database mail -- ========================

In our applications, we sometimes need to delete the primary keys of some tables first, and then do some exception operations, and then re-create the primary keys, but we do not want to use SQL server manager studio or, when using code in a program

SELECT'Table name' = case when a. colorder = 1 then d. name else' 'end,Table description = case when a. colorder = 1 then isnull (f. value, '') else'' end,FIELD No. = a. colorder,Field name = a. name,Id = case when COLUMNPROPERTY (a. id, a. name,

-- Shows all user tables and row counts for the current database -- Remove OBJECTPROPERTY function call to include system objects SELECT o.NAME, i.rowcnt FROM sysindexes AS i INNER JOIN sysobjects AS o ON i.id = o.id WHERE i.indid AND

Today, we are studying the full-text retrieval function of SQL Server. Some good information found on the Internet: [SQLSERVER] Full-text retrieval in SQL)Instance demonstration enable full-text search in SQLUse full-text retrieval of SQL SERVER 2000

Create table OverTableTest(Id int identity (1, 1), -- IDVal int, -- ValueTyp int, -- type)GoDeclare @ cou intSet @ cou = 1While @ cou BeginInsert into OverTableTestSelect @ cou, @ cou % 5 + 1 Set @ cou = @ cou + 1EndGo Select * from

Functions in SQL Server)1. Because the stored procedure cannot be used in update, it must be calculated based on some fields in the update table. We often use the cursor method. Here we use the Function Method for implementation. Function

Select hardware Choosing the best hardware for your SQL Server application involves many factors, such as the size of the database, the number of users, and the way the database is used (OLTP or OLAP. Although there is no success formula to