SQL Server

With SQL Server identity of the SA login successfully entered, everything is OK, with window identity can not login, the problem is as followsThe cause of the problem: is the current Winodow user does not have permission to log on, SQL server2008

2010-01-26sp_spaceused can view the space occupied by a table, but cannot view all the tables at once. Today, we studied this SP and wrote the following query:--Refresh system dataDBCC UPDATEUSAGE (0) with NO_INFOMSGS--8k per pageSelect name =

1.row_number () is the line number2.rank: Similar to Row_number, except that it processes the order by field, and if the field value is the same, the line number remains unchanged3.dense_rank: Similar to rank, the difference is whether the row

Left join returns records that include all the records in the left table and the equivalent of the junction fields in the right tableRight join returns records that include all records in the right table and the junction fields in the left

Online about SQL Server 2005 database log loss processing method basically is to modify the database system table, but I test n many times are unsuccessful, finally with the English keyword Google, found a feasible method, tortured me two days to

3.  installation"fail-over cluster"function3.1 Open Server Manager on SQL01 and click on "Add Roles and Features"650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/73/2B/wKiom1X21zzR-bvUAAJZ73g2tdI680.jpg "title=" 1.png " alt=

Original address: http://www.cnblogs.com/sydeveloper/archive/2013/04/03/2992881.html First, the Database design optimization 1. Do not use cursors. Using cursors not only takes up memory, but also locks tables in incredible ways, so that all the

SQL2008 's Shrink logBecause SQL2008 is optimized for file and log management, the following statements can be run in SQL2005 but have been canceled in SQL2008:(SQL2000)--Prog:xinsoft--Time:2005-03-26 10:34SET NOCOUNT onDECLARE @LogicalFileName

About the SQL statement paging, there are many online, I posted part of it, and summed up their known pages to the following, convenient for future inspection.Method 1Applies to any version of SQL Server SELECT TOP Page size * From

Overview:As a DBA, it is often necessary to update the official database with the SQL script provided by the developer, but a more reasonable development process, when the script is submitted to the DBA, there may already be hundreds of SQL files,

SQL Server uses the boot page to crash RecoveryLooked at the cover of a general articleHttp://www.eygle.com/archives/2008/11/oracle_internals_preface.html The first block of the data file records important checkpoints, SCN, and other

Recently done Oracle and SQL Server database compatibility, feel that SQL Server really does not use Oracle, stored procedures can only return int type, crazy crazyThe difference between output and return of a stored procedureSQL Rounding Ceiling

In this essay, our main focus is on Key-range Lock. Key-range Lock has s-s, S-u, I-n, x-x several cases. One by one, we strive to understand. Unfortunately, this may be lengthy, so deadlock analysis has to be postponed in turn.Get rule for Range s-s

SQL Server ReplicationReplication is a combination of technologies that you can use to replicate data and database objects from one database to another.The copy of the English is replication, repeating the meaning, not copy. The core function of

The primary role of TDE is to prevent a database backup or data file from being stolen, and the person who steals the database backup or file cannot recover or attach the database without the data encryption key.use [master];GO--See if the master

========================dos command to start the MySQL or SQL Srever step =================A. DOS command to start MySQL1. Enter the DOS command window2. Start MySQL server, net start MySQL3. Log in to the MySQL server, mysql-hlocalhost-uroot-p123456

1. View the user tableSelect from Sys.tablesSelect from where type='U'Select from where xtype='U'where type or xtype value:U = user table S = system table V = view FN = scalar function TF = table function P = stored procedure TR =

Sometimes when querying the database will be found (such as when the name of the duplicate check): The database query is not sensitive to case, that is, a and a are the same. That is to say select * from tabletest where name = ' A ' and select *

Original: Limit challenge-c#100 Data import SQL Server database in only 4 seconds (with source)In actual work sometimes need to import a large amount of data into the database, and then for various program calculations, this experiment will use 5

SQL Server custom exception raiserror example, serverraiserror When using SQL Server Stored Procedures or triggers, custom exceptions are usually used to handle some special logic. For example, the cursor is destroyed and the transaction is rolled