SQL Server

Original: Set up Scheduled Tasks using SQL Server 2005 jobsThe company has an old project because directly to the terminal shot pictures in the form of binary saved to the database, the database is larger so need to often delete these redundant data,

Original: SQL Server determines if there is a database, table, column, view1 determining whether a database existsif exists (SELECT * from sys.databases WHERE name = ' database name ')drop database [DB name]2 Determining whether a table existsif

Resetting the seed of SQL Server self-growing columnsTransferred from: http://hi.baidu.com/zbphot/item/41c55982c2d02dd05e0ec184If the data in the table is not available, use the following statement: TRUNCATE TABLEIf the statement in the table is

Reprint Address: http://hb.qq.com/a/20120111/000216.htmWith the widespread popularization of Internet application, the storage and access of massive data has become the bottleneck problem of system design. For a large-scale Internet application,

1. PhenomenaUsing cacti monitoring, there is a graph about the temporary tableYou can see that the temporary table being used is very large in active temp tables, and is maintained at about 400 during non-working hours. It feels very strange, so

Original: SQL Server log file large shrinkage method (measured and useful)These two commands are executed consecutively, with less time and more apparent (multiple runs) until the effect is reached-- truncate BACKUP LOG to DISK = ' NUL ' --

There are two parameters in SQL Server, syntax:ISNULL (Check_expression, Replacement_value)Check_expression and Replacement_value data types must be consistentIf Check_expression is NULL, the Replacement_value is returnedIf Check_expression is not

1 determining whether a database existsif exists (SELECT * from sys.databases WHERE name = ' database name ')drop database [DB name]2 Determining whether a table existsif exists (select * from sysobjects where id = object_id (n ' [table name] ') and

The so-called world events, a long time will be together, a long time will be divided, for the partition table is the same. Before we described how to delete (merge) a partition in a partitioned table, let's look at how to add a partition to a

In the previous section we described how to create and use a partitioned table, with an example of placing data from different years in different physical partitions. The specific partitioning method is:1th Small table: Data prior to 2010-1-1 (not

Partition please think twice:1, although the partition can bring many benefits, but also increased the implementation of object management costs and complexity. Therefore, consider carefully before partitioning to determine if the object should be

One of the most important features of SQL Server 2012 rollout, AlwaysOn, is a new feature set before cluster and mirror, which solves the problem of cluster dependent shared storage, It also solves the problem that the mirror cannot be read in real

Considerations for SQL Server Installation:Do not select, or a 18456 error will occur when SQL Server logs on after running for a period of time.Scenario where a 18456 error (SA can be logged in) resolves a local user logon problem: using SA login

The development of the machine, the system situation is as follows:1. Server 2003 SP2 x862. Patch Installation 3603. Upgrade to IE8Because of the worry that the SERVER 2003 SP2 not be able to update automatically, most recently with 360 patching,

Materialized view: The normal view used before, the normal view is a logic statement, the performance does not have any elevation, and can not create indexes, and materialized view will be the view of the data queried in the database to create a

Description and comparison of database storage types (nchar, char, nvarchar, varchar) for database SQL Server1.char Type:The English (ASCII) characters occupy 1 bytes, a Chinese character occupies 2 bytes, char is convenient to store the fixed

Cursor Concept In database operations, we often encounter this situation, that is, reading a record one by one from a specific result set. How can this problem be solved? Cursors provide us with an excellent solution. Cursor is a data buffer

Find the source of SQL Server deadlock and blocking-find the source of SQL Server deadlock and blocking Copy codeThe Code is as follows:Use masterGoDeclare @ spid int, @ bl intDECLARE s_cur CURSORSelect 0, blockedFrom (select * from sysprocesses

Recently, a small tool is required for the project. Requirement: the customer uses the old database and stores some data. After a while, we modified the new database based on the new features proposed by the customer. These modifications have many

Strictly speaking, Having does not need a subtable, but Having without a subtable does not have practical significance. If you only need one table, you can use the Where clause for all purposes. For practice, Having assumes at least two tables and a