SQL Server

Ms SQL Server Log File slimming Organizations use asp net forums free forum SQL Server 20002 years later, the log file is fully loaded with 7 multi-GB hard disks (an oracle test server is also installed on the same server) If you want to delete

The dynamic memory allocation mechanism introduced by SQL Server 2000 is generally unable to recycle the memory well, especially on the website server. A period of time may cause excessive memory consumption on the machine. If the computer is not

/*************************************** ************************ File: fnsplit. SQL** Name: fnsplit** Description: Split the string.Split string** Return values: @ temp** Parameters: @ SQL, @ splits** Author: mygodness)** Date: 2005-1-11** Use

User 'sa 'Login Failed. Cause: it is not associated with a trusted SQL server connection. Compiled DatabaseProgramThis error occurs when you connect to a remote SQL Server database. The reason is that the SQL Server logon authentication mode is not

1. What is the database size? Exec sp_helpdb Select * From sysfiles 2. query a database space Use dbname Sp_spaceused 3. query a tablespace Sp_spaceused tablename 4. view the log file content DBCC log (dbname, type = 4)

Paging query using SQL statements in SQL ServerCreate a table: Create Table [testtable] ([ID] [int] identity (1, 1) not null,[Firstname] [nvarchar] (100) Collate chinese_prc_ci_as null,[Lastname] [nvarchar] (100) Collate chinese_prc_ci_as

A transaction is a mechanism and an operation sequence. It contains a group of database operation commands. All the commands will be used as a whole, and they will be submitted or revoked together to the system. The requests will either be executed

When you query a product on a product introduction website, because the introductory text of the product may be very long, if you use like for a fuzzy query of the product introduction field,Performance is definitely a problem. How can this problem

/*************************************** ************************ File: fndateinterval. SQL** Name: fndateinterval** Description: Get the interval between the start date and the end date.Use the format as "number years and number months and number

1. query database tables Select * From sysobjects where (xtype = 'U ') C = check ConstraintsD = default value or default ConstraintF = foreign key constraintL = LogFn = scalar functionIf = embedded table functionsP = Stored ProcedurePK = primary

When I was doing Oracle, PL/SQL developer could easily debug and write the stored procedure. Recently, when I tried to write the stored procedure of SQL Server, it was just a bit of a black, it cannot be debugged. I really don't know if the stored

SQL Server backup and log processing   SQL Server backup and log processing I have seen many problems on the Internet

5.2 clustered indexes (Clustered index)(Page 122)   The clustered index determines the physical order of a table's data. Therefore, a table can have a clustered index. Limit 5.1 indicates the structure of a clustered index. Fig 5.1 The structure of

Delete TB where ID> 100DBCC checkident ('tb', reseed, 1)DBCC checkident ('tb', reseed)-- The result sets the auto-incrementing seed of the TB table to the maximum value of the ID column in the current table.-- Add the data again and the number will

/*Environment: Local (XP + sql2005 ):Select @ version Icrosoft SQL Server 2005-9.00.1399.06 (Intel x86)Oct 14 2005 00:33:37Copyright (c) 1988-2005 Microsoft CorporationDeveloper Edition on Windows NT 5.1 (build 2600: Service Pack 3)Data Server (Win20

-- Test environment If object_id ('tb') is not null drop table TBGoCreate Table TB(Id int,Name varchar (20 ),Constraint pk_tb primary key (ID) )GoInsert TBSelect 1, 'A' Union allSelect 2, 'B' Union allSelect 3, 'B' Union allSelect 4, 'B' Union

-- Obtain the maximum, minimum, and common SQL statements for grouping-- Test environmentIf object_id ('tb') is not null drop table TB;GoCreate Table Tb (Col1 int,Col2 int,Fcount INT)Insert into TBSelect 11,20, 1 Union allSelect 11,22, 1 Union

DBCC dropcleanbuffersDBCC freeproccacheSet statistics time on; With T(Select 1 as numUnion allSelect num + 1From tWhere num )Select * from tOption (maxrecursion 0)Set statistics time off/*DBCC execution is complete. If DBCC outputs an error message,

Not sorted.     -- 1Although deadlocks cannot be completely avoided, the number of deadlocks can be minimized. Minimizing deadlocks can increase transaction throughput and reduce system overhead because there are only a few transactions:Rollback

SolutionSQL ServerInstallation pending When installing SQL Server, the following error occurs: "A previously installed program has created a suspended file on the installation computer. You must restart the computer before running the installer.