MsSQL Subcategories |
Learn SQL Server 2000 in 15 Minutes a Week: Database Creation Basics |
| MsSQL | Views: 0 | |
| Mike Aubert's latest article in the Learning SQL Server Administration in 15 Minutes a Week series focuses on the files that make up a database and creating your first database. Topics include database files, database filegroups, and creating databases |
L Server 2000 SP3 and xp_cmdshell Woes |
| MsSQL | Views: 0 | |
| The problems caused by the SQL Sapphire Worm, also know as the SQL Slammer, have caused many sites to do a quick upgrade to SQL Server 2000 Service Pack 3 (SP3). It includes the fix that prevents infection by the worm. While moving to the latest service .. |
Introduction to MSSQL Server 2000 Analysis Services: Drilling Through to Details: From Two Perspecti |
| MsSQL | Views: 0 | |
| Explore the drillthrough capabilities that debut in Microsoft SQL Server 2000 Analysis Services. Join Author Bill Pearson in a hands-on tutorial that examines the exciting new drillthrough capabilities, from both user and design perspectives, and discove.. |
Introduction to MSSQL Server 2000 Analysis Services: Custom Cubes: Financial Reporting - Part II |
| MsSQL | Views: 0 | |
| Author Bill Pearson returns in the second half of his Custom Cubes: Financial Reporting article. This lesson presents hands-on practice in building core cube structures from multiple data tables, then combining cubes containing specialized financial data |
Integrated Security Mode |
| MsSQL | Views: 0 | |
| Learn how to connect to SQL Server through Integrated Security or Windows Authentication Mode |
Increase SQL Server stored procedure performance with these tips |
| MsSQL | Views: 0 | |
| Database developers often use stored procedures to increase performance. Here are three tips to help you get the most from your SQL Server stored procedures. We've even thrown in a bonus performance tip for counting records without accessing a table |
How to Troubleshoot SQL Server 7.0 Installation Issues |
| MsSQL | Views: 0 | |
| Find out how to troubleshoot failed SQL Server 7.0 installations |
How to Script User and Role Object Permissions in SQL Server |
| MsSQL | Views: 0 | |
| Use these scripts to help you move object permissions from one database to another |
How to Perform a SQL Server Performance Audit |
| MsSQL | Views: 0 | |
| This lengthy article written by Brad, explains how to check the performance of your SQL Server |
How to NOT trap errors in a stored procedure |
| MsSQL | Views: 0 | |
| I was trying to track down an error in one of our internal OLAP collection processes, when I noticed something very peculiar: An insert was failing, appeared to have the proper error trapping, but was not causing an error. How does that work |
How to Install SQL Server 2000 Clustering |
| MsSQL | Views: 0 | |
| SQL Server 2000 clustering can add much needed reliability and fault-tolerance to a production SQL Server 2000 system. But as you might imagine, its installation and configuration is not as easy an installing SQL Server 2000 on a single server |
How to Delete SQL Server Database Duplicate Rows from a Table Using a Specified Column List and No T |
| MsSQL | Views: 0 | |
| As much as we try and prevent it, duplicate data still finds its way into corporate data systems, but the good news is that purging duplicate rows can be a relatively simple task |
How to Connect to a SQL Server from Visual FoxPro |
| MsSQL | Views: 0 | |
| Sayed explains how one could connect from Visual Foxpro to a SQL Server, and the problems related to making this connection |
How does the Identity property work? |
| MsSQL | Views: 0 | |
| *Site Registration RequiredIf you are like most DBAs, you have probably implemented some type of hash function for some of your tables at one time or another. This article takes a look behind the scenes as to how t |
Getting Something Back from Your SQL Server Stored Procedures |
| MsSQL | Views: 0 | |
| You give so much to your database . . . sometimes you just want something back. What do you give your database? Plenty. You give it new records (INSERT). You give it changes to existing records (UPDATE/DELETE). Every now and then, you just look around (.. |
Generating ADO Parameters with Information Schema Views |
| MsSQL | Views: 0 | |
| In this article I show how to use an Information Schema View to generate ADO Parameter code. Even if you don't use ADO, you'll want to read the section that describes Information Schema Views. If you work with SQL Server long enough, I am positive you wi.. |
Finding Similar Sounding Names using SOUNDEX |
| MsSQL | Views: 0 | |
| The situation: you've got a database containing information about each employee in your company. You decide to provide a search interface, allowing fellow employees to search for information on their coworkers by their last or first names. The only probl.. |
Enable Database Access and Updates Through Exchange Any Email Client |
| MsSQL | Views: 0 | |
| The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications |
Detecting "Runs" or "Streaks" in your data |
| MsSQL | Views: 0 | |
| This article comes from Jeff Smith. Jeff writes "It can be difficult in a set-based language such as SQL to determine when a number of records in a row (when ordered by a unique key) have the same values in a particular field. For example, you may have a |
Data Page Structures in SQL Server 6.5 |
| MsSQL | Views: 0 | |
| In this article, I want to tell you about data page structure in MS SQL Server 6.5, which are substantially different that what you currently find in SQL Server 7.0 and SQL Server 2000 |
|
