MsSQL Subcategories |
SQL Server Settings Optimization Tips |
| MsSQL | Views: 0 | |
| In his latest article, Alexander Chigrik offers nine little known tips that you can use to ensure your SQL Server environment is performing in the most efficient manner possible |
SQL Server Security Part 1 |
| MsSQL | Views: 0 | |
| *Site Registration Required In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for ge |
SQL Server Replication from 6.5 to 2000 |
| MsSQL | Views: 0 | |
| These are the steps needed to successfully establish transactional replication from SQL Server 6.5 to 2000. They has been tested and are known to successfully work. This article assumes you have some previous experience with SQL Server replication |
SQL Server Optimization Tips for Designing Tables |
| MsSQL | Views: 0 | |
| Alexander Chigrik offers 15 optimization tips for ensuring that you've constructed your SQL Server tables to perform in the most efficient manner possible |
SQL Server 2000 Undocumented System Tables |
| MsSQL | Views: 0 | |
| In this article, Alexander Chigrik reveals numerous undocumented system tables shipped with SQL Server 2000. These tables are used by some system stored procedures and stored in the master database |
SQL Server 2000 Table Hints |
| MsSQL | Views: 0 | |
| Learn how to use table hints to boost the performance of SQL Server 2000 |
SQL Server & XML integration |
| MsSQL | Views: 0 | |
| XML has emerged as the standard for data. Learn how to utilize XML when working with SQL Server databases, focusing on the FOR XML clause |
Simulating Constants Using User Defined Functions |
| MsSQL | Views: 0 | |
| This article comes from Jeremy Kayne. He writes "the ability to globally store and access constant values in SQL Server has always been at the top of my wish list. Since this is not a functionality that is currently available, I have created a simple sol.. |
Secure SQL Server: Installing for security |
| MsSQL | Views: 0 | |
| Securing SQL Server is vital to the proper design of any database system. See how to install SQL securely, protect data, and ensure its validity |
Scalability and High Availability of Microsoft SQL Server 2000 (Part 3) |
| MsSQL | Views: 0 | |
| Marcin Policht takes a look creating a scalable and highly available configuration by combining SQL Server 2000 clusters with Distributed Partitioned Views |
Scalability and High Availability of Microsoft SQL Server 2000 (Part 2) |
| MsSQL | Views: 0 | |
| SQL Server 2000 is tightly integrated with the clustering software. For example, SQL Server service can be stopped from SQL Administrative tools (like Enterprise Manager or Service Manager), rather than from the Cluster Administrator. The best example of |
Scalability and high availability of Microsoft SQL Server 2000 (Part 1) |
| MsSQL | Views: 0 | |
| Marcin Policht presents a number of solutions that provide high availability and load balancing of Microsoft SQL Server 2000, focusing on solutions available natively in the SQL Server 2000 and Windows 2000 |
Retrieving Data as XML from SQL Server |
| MsSQL | Views: 0 | |
| Well hidden in the latest version of MS SQL Server 2000 is an exciting new feature. Here's a hint: it has something to do with XML! Mitchell explains the new power of SQL Server 2000 |
Replicating SQL Server 2000 across Heterogeneous Databases |
| MsSQL | Views: 0 | |
| Replication enables data and database objects to be copied and modified from one database to another across different networks and platforms |
Picking a Random Record Using a Stored Procedure |
| MsSQL | Views: 0 | |
| There are a number of articles here on 4Guys and ASPFAQs.com that examine how to return a random record from a database table. One approach is to use a stored procedure that builds a temporary table in order to remove the gaps between a column's identity |
Performing a Cascade Delete in SQL Server 7 |
| MsSQL | Views: 2 | |
| This article comes to us from Tim Young. Tim writes "One of the (few) very handy things about Access is the cascade delete function. If you delete a record from a parent table, all relating records in the child tables are also deleted. I couldn’t find an.. |
Performance Tuning for SQL Server Developers |
| MsSQL | Views: 0 | |
| Don't think that performance tuning your SQL Server applications is regulated to the end of the development process. If you want your SQL Server-based applications to scale and run at their full potential, you must begin considering scalability and perfo.. |
Optimizing Stored Procedure Recompiles |
| MsSQL | Views: 1 | |
| Developed this article after a similiar problem with the database I cam currently working on. Stored procedure recompiles are a optimizing point that most DBAs tend to overlook. This article will explain why a stored procedure may make unnecessary recomp.. |
Optimizing SQL Server Stored Procedures to Avoid Recompiles |
| MsSQL | Views: 0 | |
| Learn how to tune your stored procedures so that they don't suffer from unnecessary recompiles. |
Learn SQL Server 2000 in 15 Minutes a Week: Intro to SQL and T-SQL |
| MsSQL | Views: 0 | |
| Mike Aubert's latest article in the Learning SQL Server Administration in 15 Minutes a Week series focuses on introducing the reader to Structured Query Language, or SQL, and also covers T-SQL and transaction logs |
|
