SQL Server

Sometimes ah, when we store the data in the database, need to be clear, but for the front desk query out, but also do not want to clear the text out of the time (for example, customer's cell phone Ah, mailbox AH) Such a bit sensitive information,

The service is OK, the Client Management tool opens an error and does not have to be re-installed.Workaround One:Open the directory "C:\Users\ your user name \appdata\local\temp\ ", or Run "%temp%" to open a file with a digital filenameDelete the

PHP 5.4 Successfully connected to SQL Server 2005; sqlsrv30.exe;php_sqlsrv_54_ts.dll1. Download the DLL provided by MicrosoftAddress: http://www.microsoft.com/en-us/download/details.aspx?id=20098I under the SQLSRV30.EXE, this EXE is a

SELECTCreation_time N'Statement Compilation Time', Last_execution_time N'Last Execution Time', Total_physical_reads N'total number of physical reads', Total_logical_reads/Execution_count N'each logical read Count', Total_logical_reads N'total number

Introduction to OLE DB Wait eventsThe OLE DB wait type is one of the most common wait types in a SQL SERVER database. It means that a session (SPID) has a call request through SQL Server Native Client OLE DB provider and waits for the database to

Extracts some of the functions commonly used by SQL Server to facilitate daily learningOne, character conversion function1. ASCII ()Returns the ASCII value of the leftmost character of a character expression. In the ASCII () function, a string of

Background:My company's official website uses PHP for re-development, abandoned the original. NET development environment, but need to use some of the old official website data, so need to do data migration.The environment is as follows:Old official

Recently made a report in which stored procedures, cursors, CTE expressions, temporal tables, and table variables are used in the report.The problem comes when the cursor iterates through the data in the CTE, stores the corresponding data in the

When learning SQL Server memory management, see some term:memory node,memory clerk,memory object, very confusing, here to record their own understanding, so that follow-up learning1,numa Architecture and Memory nodeMemory nodes are created from

When the database is relatively large, and when you want to back up, we can start the database backup compression. This is because the backup file is smaller compression, so the entire backup faster, but also lower the consumption of disk

SQL SERVER 2012 Database: Open firewall causes external connection to database workaroundSave the following code as a Opensqlserverport.bat file :netsh advfirewall firewall add rule name= "Open Port" Dir=in action=allow protocol=tcp

When we build a SQL database or SQL AlwaysON, how do we test if the connection is OK? One way is to "Configure ODBC-connected SQL Server" 1. Open ODBC Data Source Manager: Control Panel--〉ODBC Data source 650) this.width=650; "Style="

I've often been asked this question repeatedly: "I have a poorly performing SQL Server." How do I find the worst performance query? “。 So in today's article you will be given some information guides that make it easy to find answers to your

General countersCollects server performance information for operating system servers, including processor, disk, network, memoryProcessor Processor1.1% Processor time refers to the percentage that the processor uses to perform non-idle threads. This

The reason for the inconsistency between conflicting and subscription data has been found before, and the number of database upgrades that have been discovered is the result of the addition of fields in the publication database and the automatic

Database Table query practice (experiment 3) and database Drill Following the previous two experiments, this experiment has mastered various query operations using select statements: Single-Table query, multi-table join and query, nested query, and

SQL server Bulk Insert command details, bulkinsert Bulk insert copies a data file to a database table or view in the format specified by the user.Syntax: BULK INSERT [ [ 'database_name'.][ 'owner' ].]{ 'table_name' FROM 'data_file' } WITH ( [

Questions raised by sys. dm_ OS _waiting_tasks of SQL Server Applications (I ), Many users wait through sys when viewing SQL statements. view dm_exec_requests. The waiting type is also obtained through wait_type, sys. dm_ OS _waiting_tasks can also

SQL Server FileStream details, FILESTREAM is a new feature in SQL Server 2008. It allows you to store and enlarge object data in the form of an independent file, instead of storing all data in a data file. In the past, there were two methods to

The impact of Tempdb on SQL Server performance optimization and tempdb Performance Optimization First, consolidate the basic knowledge of tempdb. Introduction: Tempdb is an important part of SQLServer, which is used to store temporary objects.