SQL Server

You can optimize database queries, upgrade the database server, but still not enough to guarantee good database performance for your application. This is because the problem may arise from concurrent (synchronous) query operations in the system. In

The first time you enable debugging, you will be prompted as follows: The settings are as follows: 1. Add SQL Server Management studio to the exception. The following figure: Click Enter, select Allow another program to run, select

The meaning of the transaction: For a transaction to have a very clear start and end point, every data manipulation statement in SQL Server, such as SELECT, INSERT, update, and delete, is part of an implicit transaction. Even if there is only one

Installation of SQL Server 2000 1, install SQL Server 2000 Simplified Chinese development version 2, install the SQL Server component 3, install the database server 4, select Local computer 5, create a new SQL Server instance/install Client

This article is originally from an online article, but there are some problems with the original stored procedures, this article has been validated and further modified to increase the backup time automatically increase the backup date, the article

When talking about the transaction log, we have to talk about the checkpoint Checkpoint, referred to as CKP. Both transaction logs and checkpoints exist for the rapid recovery of the database. We need to know what the checkpoint is and what it has

Summary of SQL Server views The view is stored on the physical table, changed by the physical table changes, generally no longer need to update. View as a filter: you can see from the filter name that the main purpose of such a view is to hide, as

If you need to execute a stored procedure or 3200-character SQL statement in SQL Server at regular intervals or at intervals, you can use the admin->sql Server Agent-> job. 1. Manage->sql Server Agent-> Job (right mouse button)-> new Job-> 2. New

1. Test creation table variables impact on IO Before and after the test creates a table variable, the space size of tempdb is currently sized using sp_spaceused, or you can use the view Sys.dm_db_file_space_usage 14use tempdb Go Set Nocount ON

Open a single chapter, log the problems of SQL Server encountered and the solution, to facilitate their own later review. The article will continue to improve 1) SQL Server service suddenly failed to start Problem Description: There has been no

SQL Server cursors use "Go" Posted on 2011-11-26 00:33 Moss_tan_jun Read (206754) Comments (53) Edit FavoritesThe cursor is evil!In a relational database, our thinking about queries is set-oriented. The cursor breaks this rule, and the cursor makes

(1) Definition:Char: fixed length, storing ANSI characters, insufficient complement English half-width space.NCHAR: fixed length, storing Unicode characters, insufficient complement to English half-width spaceVARCHAR: variable length, storing ANSI

One, ISNULL syntax format ISNULL (check_expression, Replacement_value)Ii. Introduction to Parameters Check_expression: An expression that will be checked for NULL, check_expression can be of any type.Replacement_value: The expression that will be

SQL Server provides four types of servers:: 1, Database engine 2, Analysis Services (analytics Service) 3, Reporting Services (Reporting Services) 4, Integration Services (Integration Services)1, Database EngineDatabase Engine: Is the core service

Today, a colleague found a SQL Server statement execution is particularly slow, after the inspection found that the condition plus the time period, before using the time field between XXX and xxx way, then change the time to determine the method,----

Outsourced projects, there is a lot of information stored in JSON, whether it is query or modify information is very cumbersome. Find some useful SQL function to parse, and attach the modified example.Use procedure:1. Need to create a new custom

An aggregate function (statistical function)!!!!!Number of Counts count ()Select COUNT (*) from table nameSum sum ()Select SUM (column name) from table nameAveraging avg ()Select AVG (column name) from table nameMax ()Select Max (column name) from

Create Proc Stored Procedure name（@ Parameter 1 parameter type,@ Parameter 2 parameter type,...--the last line of arguments, don't add a comma, the comma means that there are parameters behind it .）AsSQL commands to executeGOCases:A stored procedure

SQL Server deadlock Monitoring Analysis Solution, SQL Server 1. Background 1.1 alert status Recently, I plan to migrate all my notes to EVERNOTE. Sort out the lock part, and there is a case recorded by myself. I will try again and share it with you.

The performance damage of bookmarks in SQL Server, sqlserver In my blog, I used to talk about searching for bookmarks in SQL Serverl, and there are many problems they bring about. In today's article, I want to further talk about bookmarking from the