SQL Server

MS SQL Server provides a number of commands for database repairs that can be attempted when the database is challenged or some cannot complete the read. 1. DBCC CHECKDB After restarting the server, perform the following SQL database repairs in SQL

When we use tables in a database, we often encounter two ways to use a table, which is to use temporary tables and table variables. How can we use them flexibly in a stored procedure when we are actually using them, although they are basically the

1. Nested loop join (nested cyclic join) Algorithm: The idea is quite simple and straightforward: for each tuple R of relation R, it is directly compared with each tuple s of relation s in the field of the join condition, and the eligible tuples

The certificate also contains both the public key and the key, which is used for encryption and the latter to decrypt. SQL Server can generate its own certificate, or it can be loaded from an external file or assembly. Because they can be backed up

SQL Server platform modifies self-added column values Since the migration of the SQL Server database was previously processed, a change to its own column value has been attempted, but modifying the self-added column value through an SQL statement

When the database is fully backed up, we may sometimes experience an extreme situation, such as three c,d,e on a server with only 5G of space left But what if it takes 12G of space to fully back up the business library? Use filegroup backup? But

The following tests are used to remove the line separator in any string Copy Code code as follows: --removing consecutive delimiters in a string declare @str nvarchar (200) Declare @split nvarchar, @times int Set @str = ' China 1 2 34 55

Here's a description of what ports are used in SQL Server 2008: First, the most commonly used is the 1433 port. This is the port of the database engine, and if we want to connect to the database engine remotely, then we need to open the port. This

This article sample source code or material download Summary: The table-based partitioning feature in SQL Server 2005 provides flexibility and better performance for simplifying the creation and maintenance of partitioned tables. Trace the

Database mirroring is a new feature of SQL Server 2005 that allows you to mirror the contents of a database in one SQL Server to another SQL Server. It also allows you to make error recovery by mirroring the database in the event of an error. Since

Server|sqlserver| Stored Procedure | access | data | database | problem Recently submitted a Web form with asp.net 2.0 + SQL Server, using C # to write a stored procedure to complete inserting records into a SQL Server database table. When this

server| Security | Raiders Databases are the basis of E-commerce, finance, and ERP systems, and often hold important business partners and customer information. Electronic data from most businesses, organizations, and government departments are kept

Server in SQL 2000, the user can create a custom function, the function return value can be a value, can also be a table. Maybe it's not clear how the custom function works. Previously mentioned in the optimizing database posts, try not to use

You often encounter situations where you need to insert bulk data into SQL Server and then further process the data in a stored procedure. The stored procedure does not have a parameter type such as an array or a list, and the XML type solves the

There are puber in SQL Server Edition of a post server2005+sp3 deadlock problem, due to the recent study of SQL Server some of the problems, out of interest decided to try to help the pubber. Problem Description: My program is multithreaded and

1.3.4 Profiler SQL Server Profiler is a graphical management tool for monitoring the use of SQL Server databases for system administrators It is a spy that monitors user activity 1.3.5 Client Network Utility SQL Server Client Network Utility used

Database Mirroring Database mirroring is a technology that can improve database availability. These changes are also automatically applied to the mirrored database when the principal database changes. When a principal server fails, the client

To obtain all database information on a SQL Server using stored procedures sp_databases Execute command in query analysis exec sp_databases Result: Master 14464 NULL Model 1280 NULL msdb 14336 NULL Northwind 4352 NULL Pubs 2560 NULL Store 1912

The SQL Server Integrated Services (SSIS) used in Microsoft's SQL Server 2005 to replace data transfer services (DTS) contains a number of tools for importing data and translating it into meaningful information, not just passive imports. But one

Note: Windows XP cannot be installed in Enterprise Edition. WIN2000\WIN2003 Server Installation Enterprise EditionOne, hardware and operating system requirementsThe following table describes the hardware requirements for installing Microsoft SQL