SQL Server

IntroducedOften people ask how the profile tool should be used? There is no way to get a poor performance SQL problem. Since I turned to MySQL myself for almost 2 years without using profile, suddenly profile became a little rusty and had to be

This post provides two ways to avoid unhealthy or long-time blocking when SQL Server transactions are locked, allowing users and programs to wait indefinitely, even causing connection pooling connections to exceed capacity.The so-called "blocking"

Such a problem is undoubtedly the first difficult problem for beginners like ours after getting started with SQL Server, "Real-time error '91 'object variable or with Block Variable not set" is exposed in the end? I still can't see anything until I

SQL ServerCategory 4Data warehouse modelingMethods are mainly divided into the following four types. The first type is the three-paradigm modeling of relational databases. We usually use the three-paradigm modeling method to build various types of

SQL Server manages common SQL and T-SQL (2) 1. view the database versionSelect @ versionCommon SQL server patch versions:8.00.194 Microsoft SQL Server 20008.00.384 Microsoft SQL Server 2000 sp18.00.532 Microsoft SQL Server 2000 sp28.00.760

December 10,200 3Troubleshooting SQL server jobs By Alexander chigrik If you have problems with SQL Server jobs, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server Service

SQL Server 2008 ============================ 10.00.2766 SQL Server 2008 SP1 cu7 15 mar 2010 10.00.2757 SQL Server 2008 SP1 cu6 18 Jan 2010 10.00.2746 SQL Server 2008 SP1 cu5 24 No v 2009

  [Introduction]  You work as a database administrator for your company. a SQL Server login named Tom is used only withinAdventureworksDatabase. A new company security policy is being implemented. This new policy states that SQL Server

1. The round () function is used in rounding. The first parameter is the data to be operated, and the second parameter is used to display the number of decimal places after rounding. 2.The numeric function has two parameters. The first parameter

SQL Server is a relational database management system (DBMS) developed and promoted by Microsoft. It was initially developed by Microsoft, Sybase, and Ashton-Tate, the first OS/2 version was released in 1988. It is only one of many relational

Microsoft ole db provider for SQL Server Error '80040e14' The log of database 'mis1' is full. Back up the transaction logs of the database to release some log space. A simple method is used to contract logs: 1. backup log... with no_log2. shrink the

1. confirm that the latest patches for NT/2000 and SQL server have been installed. Needless to say, you should have installed them, but I think it is best to remind you here. 2. evaluate and select a network protocol that considers maximum security

SQL Server 2: full-text search (2) Here we will mainly talk about the contains function used in full-text search, extract articles from others, and share it with you. Suppose there is a table named students, where the address is a column for full

I have written an article about how to replace an expired image certificate: SQL Server image certificate expiration. This is a test preparation for replacing a certificate. In this article, I encountered some problems when I replaced a large number

1. Export SQL Server as Excel:To use T-SQL statements to export directly to the Excel worksheet, you have to borrow an extended stored procedure from the SQL Server Manager: xp_cmdshell, this process is used to execute a given command string in the

In Microsoft SQL Server 2008, database administrators (DBA) are the most important roles. DBA's goal is to ensure that the Microsoft SQL Server 2008 system runs properly and efficiently. DBA is also the busiest job. Both Performance adjustment and

Whether using manual testing or security testing tools, malicious attackers always use various tricks to break your SQL Server System from inside and outside your firewall. Since hackers are doing this. You also need to conduct the same attack to

There are two examples in the previous two blogs to demonstrate the content to be told. Some methods for viewing the database status are mentioned, which is not very comprehensive. This blog lists several of the statuses and data that we will use in

------------------ UDF ---------------- Create a user-defined function. This is a stored Transact-SQL or Common Language Runtime (CLR) routine,-- This routine returns a value. User-defined functions cannot be used to modify the database status.--

◆ Advantages:The execution speed is faster. The stored procedure is compiled only when it is created. Generally, the SQL statement is compiled every time it is executed. Therefore, the execution speed of stored procedures is faster.When stored