SQL Server

Copy Code code as follows: --code One declare @cc INT SELECT Newsid,row_number () over (order by Sortnum DESC) as RowIndex into #tb from news with (NOLOCK) WHERE newstypeid= @NewsT Ypeid and Isshow=1 SET @cc = @ @ROWCOUNT SELECT n.*

The table structure is created like the following code Copy Code code as follows: CREATE TABLE TEST_TB ( TestID int NOT null identity (1,1) primary key, Caption nvarchar (MB) null ); Go Solution 1: The first idea

First, the error situationSometimes when you restart the database service, you will find that some databases are recovering, doubtful, suspicious, and the DBA will be very nervous, and here are some proven methods in practice. Once the database

Copy Code code as follows: Use [database name]; --1. Define the keywords you want to find. In search, use fuzzy search: like '% @key_find% ' DECLARE @key_find NVARCHAR (MAX) = ' 123 ';--suppose to find the string "123" --2. Cursor_table

SQL Server Log Vacuuming methodPerform the following three steps sequentially in Query Analyzer, where databasename is your database filename sql2000 Log Empty You can make jb51.ldf files very small, make it easy to back up databases, and so on,

First of allUse [database name];exec sp_helpfile; Use the sp_helpfile query to know the logical name of the log file, and then you can use DBCC to reduce the log fileBACKUP LOG [database name] WITH TRUNCATE_ONLYDBCC SHRINKFILE (logical name of log

First of all, I need to emphasize that this theme is to reveal the heap table delete record to retrieve the principle, I consider the aspect does not apply to each individual situation, hope everyone forgive ~ Many friends think that the database

Myth #29: You can defragment the heap after you drop the heap by a clustered index nooooooooooooo!!! To heap a clustered index and drop it seems to me to be the top 2 in addition to shrinking the database. If you see fragments on the heap

Create a SQL Server database. Copy Code code as follows: Db_size_in_megabytes = 5 Strdbservername = "." Set Objsqlserver = CreateObject ("SQLDMO. SQL Server ") Objsqlserver.loginsecure = True Objsqlserver.connect Strdbservername

It mainly speaks of the difference in performance between except and not. Copy Code code as follows: CREATE TABLE tb1 (ID int) CREATE TABLE TB2 (ID int) BEGIN TRAN DECLARE @i INT = 500 While @i > 0 Begin INSERT into

Brief introduction In SQL Server, the way a database is stored on a hard disk is no different from how normal files are stored in Windows, just a few files. SQL Server manages files by managing the logical filegroups. Understanding the concepts of

Grammar: Row_number () over ([] ) Note: The ORDER BY clause determines the sequence in which the rows are assigned unique row_number in a particular partition. Parameters: The result set generated from clause is drawn into the partition where the

This article is intended to categorize information about each of the operations in the execution plan. Data Access Operations First, the most basic operation is to access the data. This can be done either by directly accessing the table or by

Copy Code code as follows: Use tempdb If object_id (' tempdb.. #table ') is not null drop table tempdb. #table Select name into tempdb. #table From (SELECT * from sysobjects where xtype= ' U ') a Where A.name like '%test_select '

Using NOLOCK and READPAST in query statements One of the recommendations for handling an exception to a database deadlock is to use NOLOCK or READPAST. Some technical knowledge points about NOLOCK and Readpast: For non-banks and other stringent

In industrial applications, the returned data is often stored in binary form, and these binary data represent a hexadecimal data content per 4 bit. Parsing, often a byte (byte) occupies 8 bits (bit), high 4bit represents a hexadecimal data, low 4bit

Using a database in 1.java requires the use of JDBC (Java database connection) to connect and manipulate Download Address: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 2. After the completion of the decompression to

A Little StoryOne day, Xiao Wang is chatting with HR sister, is happy, suddenly received the system alarm message, the database disk is the remaining space 500m,omg, no, the disk is almost full, if the business to stop, then the small king can only

When the MDF or NDF file is large, the traditional DBCC SHRINKFILE command is difficult to take effect, and the current feasible solution: Create a new filegroup by rebuilding the remaining tables and specifying a clustered index to the new

Now you need to query a set of data, which is the grouping of data in a column of fields (COLUMN01) after a range of queries:Select (Casewhen [Column01] >0 and [column01]500 and [column01]1000 and [column01]5000 and [column01]20000 and [column01] 0