sql server profiler

23. Access Microsoft SQL server from the Internet Internet programming concepts Use ISAPI to access SQL Server Use ASP to access SQL Server Use XML to access SQL

A recent project to get some data that exists on other servers is implemented in a way that is pushed by other "servers" to our servers for security reasons. Our server is using SQL Server 2008 R2, other "Servers" are using SQL Server 2000, are running on Windows XP, the who

This section briefly introduces the latches in SQL Server and SQL Server. In today's article, I want to talk about more advanced and lightweight synchronization objects used by SQL Server: Latch ). The lock is a lightweight synchr

error|server| Program Error : "When connecting to SQL Server 2005, the default setting for SQL Server to disallow remote connections may cause this failure. (provider: Named pipe provider, error:40-cannot open a connection to SQL

Prepare to do before copying: 1. Publisher, Subscriber creates a Windows user with the same name and sets the same password as a valid access user for the publication snapshot folder My computer Control Panel Management tools Computer Management Users and Groups Right-click User New user Create a user who is logged on to Windows in the group of Administrators 2. At the publisher, create a new shared directory as the repository for the published snapshot files: My computer D:\ Create a new dir

Label:SQL Server Agent is the core of all real-time databases. Proxies have a lot of non-obvious uses, so the knowledge of the system is useful for developers or DBAs. This series of articles will be popular to introduce its many uses. In the previous article in this series, you learned how to use SQL Server Agent job Activity Monitor to monitor job activ

　　Detection of deadlocks in SQL Server First of all, in a multi-concurrency environment, deadlock is unavoidable, can only be as far as possible through a reasonable database design, good indexes, appropriate query statements and isolation level to minimize. Therefore, the purpose of detecting deadlocks is to know where deadlocks can occur, and to optimize the query/index/isolation level to reduce the like

The following step-by-step article describes how to configure shared disk Cluster for SQL Server on a red Hat Enterprise Linux system and its associated use (for test-only learning, basic article)I. Creating shared disks and ClusterMicrosoft Official configuration document: Https://docs.microsoft.com/en-us/sql/linux/sql