SQL Server

SQL 2008 log Files account for 23G of hard disk space, and the transaction log has been truncated (Truncate), the actual log content is small, 1G is not, want to release the extra space occupied by the log files. However, no matter how you shrink

January 1, 2015, the beginning of the new year, should have done a good job to do something meaningful to span a year. As a result, old habits-before going to bed must toss the computer, say dry, to the new DELL computer installed virtual machine,

Today, a colleague encountered the following error when starting his own computer's SQL Server 2012 Configuration Manager: Unable to connect to the WMI provider. You do not have permissions or the server cannot be accessed. Note that you can

One of the most important new features of the offset and fetch is the paging, since to analyze pagination, it is certainly to and before the paging way to compare, especially row_number (), in the comparison process, found quite a lot, but the most

Server| Process | problems Source: Http://www.xfocus.net A, SQL Server patch version of the check SQL Server patch version check is not as direct as Windows patch version check, a system administrator, if you do not understand the SQL Server

server| Server SQL Server 7.0 Data Transformation Services (DTS) object transfer features the ability to transfer logins and users between two servers, but it does not transfer the password for SQL Server Authentication logins. To transfer logins

server| Microsoft Blocking definition =============== Blocking occurs when the first connection from the application controls the lock and the second connection requires a conflicting lock type. The result is to force the second connection to wait

Buffering (buffering) The buffering technology in Visual FoxPro When the remote data is downloaded to the client, the data is pressed into the buffer. The various movements of the data by the client user are not reflected in the data source, but

Microsoft SQL Server Each version will have a corresponding sample project, from the 2000 FoodMart to 2005 after the Adventure Works, inside the design methods and specifications have a lot of things we deserve to learn. Not only do ordinary

All data for Today:Select* fromTable namewhereDateDiff (dd,datetime Type field, GETDATE ()) =0all data for yesterday:Select* fromTable namewhereDateDiff (dd,datetime Type field, GETDATE ()) =1all data in 7 days:Select* fromTable namewhereDateDiff

There are three join strategies for SQL Server: Hash join,merge join,nested Loop join.hash Join: Used to handle data that is not ordered/not indexed, it creates a hash table in memory of the data (the associated key) on both sides of the Join. For

https://gennadny.wordpress.com/2014/11/Since SQL Server 7.0, SQL Server has its own scheduling mechanism, in SQL 7.0 and it is called UMS (User Mode schedu Ling) and later was renamed to SOS (SQL OS Scheduler).  Ums\sos is Non-preemptive\cooperative

One, local time and UTC timelocal timeEach region of the world has its own local time, the entire earth is divided into 24 time zones, each time zone has its own local time.UTC timeIn international radio communications, a standard time is commonly

When you do data coversion for an SSIS project, you often encounter two issues like the following:1.Validating (Error)Messages* Error 0xc02020f4:data Flow Task 1:the column "XXXX" cannot be processed because more than one code page (936 and 1252) is

SQL Server theoretically has 32,767 logical connections, and SQL Server is self-leveling the connection pool based on the system.First, the number of users of the operating system: that is, at the same time through the network connected to the

The SQL Server database has three file types, data files, secondary data files, and log files, where the log files contain all the log information used to recover the database, SQL Server always writes the log file LDF first, and data changes are

This article describes in detail how to use a connection object to connect to a database. For different. NET data providers, ADO. net uses different connection objects to connect to the database. These connection objects shield us from specific

Why does the SQL Server DBA learn PowerShell? From: http://www.simple-talk.com/ SQL /database-administration/why-this-sql-server-dba-is-learning-powershell/ Joe. TJ is used only for the purpose of disseminating information. I started learning

The string search function is frequently used recently. Including 1. fully match the search string2. Fuzzy search for strings Both the CHARINDEX and PATINDEX functions return the starting position of the specified mode. PATINDEX can use wildcards,

The growth of SQL Server Cognition 1. I don't have to graduate or work for a long time. I only know the relationship between SQL and SQL Server Oracle and MySql. I usually think that SQL is SQL Server.2. after several years of work, I have also