sql server admin

In addition to providing powerful management tools Enterprise Manager, reliable security management and database backup and recovery, and built-in replication components, SQL Server includes a number of other tools and reassuring features. In this chapter we'll introduce SQL Mail, SQL

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

Difference between SQL Server table variables and temporary tables (Supplement), SQL Server I. Table Variables Table variables are introduced in SQL Server 2000 for the first time. Table variables include column definitions, colum

SQL Server implements automatic cyclic archiving of partition data scripts, SQL Server Overview We should all know that in many business scenarios, We need to partition some tables with a large record volume, and archive some old data to ensure performance. In many partition tables, IF manual intervention is required f

MS SQL Server Query optimization methodThere are many reasons for the slow speed of queries, which are common1, no indexes, or no indexes (this is the most common problem with query slowness, is the flaw in programming)2, I/o throughput is small, creating a bottleneck effect.3, no computed columns are created causing the query to be not optimized.4, Low memory5, network speed is slow6, query out the amount

SQL Server database downgrade from high version to low version instance details, SQL Server details How to downgrade an SQL Server database from a higher version to a lower version Currently, SQLServer2000 is widely used. Many com

SQL Server paging query processing method summary, SQL Server Paging Sqlserver2008 does not support the keyword limit, so its paging SQL query statement cannot be performed using MySQL. Fortunately, sqlserver2008 provides top, rownumber, and other keywords, in this way, you

Recently, I was working on a project (Asp.net + SQL Server 2000). There was no problem in running it on the originally developed machine. however, when I Debug Programs (local debugging) on another machine, "SQL Server does not exist or access is denied" appears ". I believe that entering such a keyword on any search w

Today, in order to experience the new features of SQL Server 2005, malicious to kill the native SQL Server 2000, installed a SQL Server 2005, experienced a lot of new features, then suddenly remembered that there are some DTS impr

Original posts by QingyunPublished on 2010-6-21 15:44When writing PL/SQL, there is a very important point of attention;Like what:BeginUpdate a SQL Server table @dblink name ...;Update a table for an oracle ...;EndThis PL/SQL execution will error:The error message is:-------------------------------------------

Ms SQL Server ODBC driver SQL Server listing Stack Overflow Vulnerability Created:Article attributes: originalSource: http://www.xfocus.netArticle submitted: flashsky (flashsky1_at_sina.com) Indicate the author and security focusAuthor: flashskySite: www. xfocus. netMail: flashsky@xfocus.org An overflow vulnerability e

these installation logic in a single. The advantage of SQL files is that most host vendors have already supported uploads. SQL files to their host environment, and the ability to run these scripts through their admin control Panel. Assuming you have a web hosting provider that supports this functionality, you can immediately start using the Database Publishing W

SQL Server Performance Tuning methodology and common tools, SQL Server Tuning In earlier articles, we mentioned the DETECT methodology in Performance Tuning. Here we will briefly review the DETECT methodology. Discover the problem: found the problem Lead e the conditions: Explore causes Track down possible approaches:

SQL Server downgrading SQL Server 2000 run the setting method with the GUESTS permission, sqlguests Due to vulnerabilities in the SQL2000 database, hackers can easily obtain system administrator privileges. By default, SQL runs with the SYSTEM permission, which is extremely

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

Tags: Database SQL DBA SQL ServerAn upgrade migration from SQL Server 2005 to SQL Server 2008 was completed last weekend, essentially a server migration process. The more complex is the

SQL statement Import and Export /****** Export to excelExec master.. xp_mongoshell 'bcp settledb. DBO. shanghu out C:/temp1.xls-C-Q-s "gnetdata/gnetdata"-U "sa"-P ""' /*********** Import ExcelSelect *From OpenDataSource ('Microsoft. Jet. oledb.4.0 ','Data source = "C:/test.xls"; user id = admin; Password =; extended properties = Excel 5.0 ')... xactions Select cast (subject number as numeric (255) as nvarch