SQL Server

Recently, many users have failed to install SQL Server2008 on the WINDOWS2003 server 32-bit operating system, and a large number of errors have occurred. Today, through my repeated test installation, found a convenient installation method, save

Overview Database mirroring is a software-based solution for high availability of databases. It maintains two identical copies of a database, each of which is placed in separate instances of the SQL Server database. It is recommended that you use

Microsoft included several hundred stored procedures in the various versions of Microsoft SQL Server and it has documen Ted a good percentage of them. But Many stored procedures remain undocumented. Some are used within the Enterprise Manager GUI in

Problem phenomenon:System log files (Control Panel – Admin tools – System log)You can find the following two errors:17052:Unable to recover master database. is exiting.18052:Error: 9003, severity: 20, Status: 1. Workaround One: Rename the

Optimizing queries can be a common thing for SQL Server optimizations. Since the optimization of database is a wide topic in itself, this article only talks about how to understand SQL Server query plan when optimizing query. After all, my knowledge

Install SQL Server 2005 for a long time, finally ... During the period of problems, want to take out and share with you.The first type of error appears: Unable to install and configure assembly errors in the COM + catalog:-2146233087Unable to

access|server|sql| comparison Background database:[Microsoft Access]And[Microsoft SQL Server]After the replacement, the ASP code should note some of the areas to be modified: [One] connection problem (for example)[Microsoft Access]Constr =

Server The configuration options for SQL Server servers are those that people understand less and are often misused. When a technical support person asks you to adjust an option in some way, and another technical support person asks you to adjust

 powerful features of Python and SQL Server 2017Python is a new feature of SQL Server 2017. It is primarily intended to allow Python-based machine learning in SQL Server, but it can be used with any Python library or framework. To provide a possible

Original: SQL Server 2008 Performance Troubleshooting (i)--IntroductionRemark: I spent a lot of work time translation, no plagiarism, allow reprint, but please indicate the source. Because of the length, not a post all finished, but also not so fast

partition table in SQL Server 2005 (a): What is a partitioned table? Why use partitioned tables? How do I create a partitioned table? Category: SQL Server2009-12-03 10:17 15325 People read comments (+) Favorites report SQL Server Database

In 2008, the option to block saving changes that require the table to be recreated is added. Symptoms are "blocking" you when modifying the table structure.The solution to the " prevent saving changes that require re-creation of tables " in SQL

"Customer Name": Binzhou Wudi County Hospital of Shandong Province"Software name": Zhong Lian Jia Yu His hospital information management system"Database Version": MS SQL Server 2008R2 "database size": 48GB."Problem description": On the eve of the

This article belongs to theUnderstand the mysteries of performance-slow in applications, fast in SSMS"seriesNext: Understanding the Mysteries of performance-application slow, SSMs fast (5)--case: How to deal with parameter sniffingWe put aside the

It's hard to put it onSQLServer2012 database, but cannot connect to a localDatabase, later found that the lack of some services, so decided to reinstall, but the uninstall is very troublesome, if the uninstall is not clean, reinstall will be

Problem Description:Use snapshot-based transactional replication, add items, execute Snapshot Agent, error message when last published:Error messages:Message:the subscription status of the object could not being changed.Command

Brief introductionThis article details the installation process for a full Microsoft SQL Server 2008 on the Windows 7 operating system. Note: Microsoft SQL Server 2008 has some compatibility issues with the Windows 7 operating system, and you need

SQL Server version requirements: Standard Edition (2 nodes), Enterprise Edition (16 nodes)Before installing, learn about: Getting Started with SQL Server 2008 failover ClusteringSQL Server 2008 clusters are Windows-based clusters: Windows 2008

Question: How to manually delete the default instance, named instance, or virtual instance of SQL Server 2000 [Keyword ]: Web SQL, server, 2000 How to manually delete SQL Server 2000 default instances, named instances, or virtual instances This

The first part indicates that he locks an index range. In this range, all indexes are locked using the T lock;The second part is the Key that has been hit in this range. These keys will be locked using the K lock.In this Range, the locking mode of