SQL Server

You must use a dedicated administrative connection in SQL SERVER 2005 to view the tables that are used during the processEg:sqlcmd-a1>use Test2>go1>sp_decrypt ' P_testa '2>goText----------------------Create procedure P_testaWith encryptionAsSELECT *

SQL Server 2008R2 (Baidu Cloud: Link: Http://pan.baidu.com/s/1qWHgy4G password: qx5r) ASP-mvc4.0+ WEBAPI+EASYUI+KNOCKOUTJS Rapid Development Framework Universal access Management systemOnline Demo Address: http://115.28.135.49:8099/1. Architecture

Original: Backup/restore Principles for SQL Server differential backupsBackup/restore Principles for SQL Server differential backupsRemember one point: Differential backups are based on the difference from the last full backup, not the difference

In SQL Server use JSON string to save in tableLet's look at an example and see where he's strong.SELECT * from Parsejson (' {'): { "firstName": "John", "LastName": "Smith", "Age " : "Address": { "streetaddress": "2nd

When programming with EF, sometimes we can't look at the SQL statements that EF eventually generates, and it doesn't parse the problem well. Let me explain the use of SQL Server Profiler. SQL Server Profiler can view the resulting SQL

I've heard of it before. PowerDesigner can be connected to a database, creating tables, triggers, and stored procedures into a database based on the data model created in PowerDesigner. You can also export an existing database to PowerDesigner as

Recently, when checking a cashier report, I found a problem, that is, when the string value of the time date in SQL Server goes to the datetime type, something strange happens.The query is as follows:You need to check the cashier data for the 2015-07

1. You should try to avoid null values in the WHERE clause, otherwise it will cause the engine to discard the indexFull table scan, such as:Select ID from t where num is nullYou can set the default value of 0 on NUM, make sure that the NUM column in

Recently took over to maintain a good project, telnet to the server when the program execution special card, the use of Task Manager to view the system resource usage, monitoring for a period of time found that the CPU is small, but memory

DBCC LoginfoDBCC log (' Qssys ', type=2)GoSELECT * from Sys.fn_dblog (null,null)Select [Dirty pages],[minimum lsn],[checkpoint end],[chkpt Begin DB version],[checkpoint begin],operation,context,[log Record length],allocunitname from Fn_dblog

SQL Server Database performance optimizationRecent project needs, did a period of time SQL Server performance optimization, encountered some problems, but also accumulated some experience, now summed up, with June share. SQL Server performance

For a full database backup, the speed of the backup depends largely on the following two factors: Read disk data, log file throughput, write disk data file throughput.Is the change of disk in the backup process:Read throughputThe size of the read

Operation with Root privileges1. Install Unixodbc "http://www.unixodbc.org/"SH Configure--PREFIX=/USR/LOCAL/UNIXODBCMakeMake install2. Install FreeTDS "http://www.freetds.org/software.html"SH

In C # program development often need to deal with SQL Server database, below we understand the C # operation of SQL Server database method: 1. The first step is to add the necessary references and some data members to our program. Because our

It is convenient for SQL Server to export data using bcp, for example, to export Pubs.dbo.sales records into Excel format, and at the command prompt, enter:(1) Specify table or view name exportBCP pubs.dbo.sales out c:\exp.xls-w-S testdb-u "sa"-P

System environment:Microsoft Windows Server 2003 Enterprise Edition Service Pack 2[Microsoft Windows NT-5.2 (3790)]SQL Server Enterprise Edition 8.00.2066 (SP4)CentosMysqlDeployment steps:Linux Environment1. Create an account in MySQL and Access

(This article also published in my public number "dotnet daily Essence article", Welcome to the right QR code to pay attention to. )Preface: As big Data becomes a buzzword, the technology associated with big data is becoming more and more hot,

text and image functions　　1. Find a specific string patindexSyntax is the same as String patindex.　　2. Get text pointer textptrWhen SQL Server stores text types (ntext, text), and image data types (images), the default is stored separately from data

Definition of UDFSimilar to stored procedures, user-defined functions are also an ordered set of T-SQL statements, and UDFs are pre-optimized and compiled and grams as a unit of love. The main difference between UDFs and stored procedures is how the

SQL Server connection query details, SQL Server Query details When querying multiple tables, we often use "join query ". Connection is the main feature of the relational database model and a symbol that distinguishes it from other types of database