SQL Server

Memory usage of SQL Server Every time SQL Server is enabled on a machine, the memory will be very tight whether or not it is used for SQL-related work. Today, I saw this in my book. I Googled it online and found related

  Today, we will mainly discuss the application and Optimization Solutions of SQL Server Stored Procedures. Stored Procedure: As I wrote earlierArticleAn overview of the stored procedure is provided. Today, let's take a look at the advanced

When it comes to this problem, someone will think of three questions: 1. What is system data? 2. Why do we need a mobile system database? 3. We can use attaching and separating mobile system databases. Why do we need to separate them? Let me

  This is just a technique for using management studio.   When writing SQL in SQL Server Management studio, we cannot avoid frequent switching between the browser and SSMs, which is a waste of time. However, SSMs comes with a web browser, it is

Create Table ds_tcategory -- problem category information table (categoryidint identity () primary key, -- category ID, primary key, automatically increasing categorynamevarchar (20) uniquenot null, -- category name (such as default, Major, c ++, C,

Temporary tables vs. Table variables and their impact on SQL Server Performance -- Wang Chenghui translation finishing, post please indicate from Microsoft Bi pioneer http://www.windbi.com/--Original post addressIn the temporary tableCreate

In this article, we mainly focus on key-range lock. Key-range lock has s-s, S-u, I-n, X-X several situations. One by one, we strive to understand. Unfortunately, the deadlock analysis may be prolonged. Acquisition rules for range S-S locks Msdn

Table Alter table name Alter column name nvarchar (100) (type) Collate chinese_prc_ci_as -- Case insensitive ALTER TABLE TBAlter column colname nvarchar (100) Collate chinese_prc_cs_as-- Case sensitive Modify to fieldAlso, in the design

I. query the usage of disk space and the size and utilization of data files and log files in each database:1. query the remaining space of each disk partition:Exec master. DBO. xp_fixeddrives 2. query the data files and log files of the database

1. Database Table Locking Principle 1.1 currently, the C/S and B/S structures all involve multiple users accessing the database. Each time point there are thousands of users accessing the database, and the same data is also accessed, this may

Create a table: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> Set Ansi_nulls On Go Set Quoted_identifier On Go Create   Table   [ DBO ] . [ T1 ] (

 Today, when you assign the datetime type data in the database to the datetime type variable in C #, a problem occurs, that is, the datetime data in the database has a null value. C # by default, null cannot be assigned to the datetime variable,

/* The reliability and performance monitor is a standard tool used by sql08 to monitor servers. It has updated the report counter for SQL Server.You can use these counters to track many different server resources and activities.SQL Server Profiler

SQL ServerMedium DatabaseTransaction ProcessingIs quite useful, given that many SQL beginners write Transaction ProcessingCodeVulnerabilities often exist. This article introduces three different methods to illustrate howStored ProcedureWrite the

In the last two weeks, the memory of the DB server has not been used up, and 32 GB is used. As a result, the memory usage has been around 4 GB, which is really confusing. Normally, around 17 GB should be used. After troubleshooting for half a day,

SYS. sysprocesses is an important system view. It is mainly used to locate and solve SQL Server blocking and deadlock. Msdn: contains information about processes running on an SQL server instance. These processes can be client processes or

1. sysjobactivity table Record the activity and status of the current SQL Server proxy job. Job_id: Job IDRun_requested_date: date and time when the job is requested to runRun_requested_source: the requester requesting to run the job. 1 = source_

/****** Export to excelExec master.. xp_mongoshell 'bcp settledb. DBO. shanghu out c: \ temp1.xls-C-Q-s "JLJ"-U "sa"-P "password0987 "' /*********** Import ExcelSelect *From OpenDataSource ('Microsoft. Jet. oledb.4.0 ','Data source = "C: \ test.xls";

Are you struggling to optimize your SQL Server database? If your database contains many very large tables, the partition function can help you a lot ...... [IT expert network exclusive] Are you also struggling to optimize your SQL Server database?

Preface: Last time I wrote an article about indexes, several insite emails from yuanyou asked me how to store indexes and tables on different hard disks. I think it should be easier to write an article to describe files and file