MsSQL Subcategories |
Your First SQL Server 2000 Database |
| MsSQL | Views: 1 | |
| Curious about SQL Server 2000? Learn how to create databases in Enterprise Manager and Query Analyser today |
Writing Your Own Script File to Migrate a Database |
| MsSQL | Views: 0 | |
| Learn how to write a script file using SQL Server's Bulk Copy Program for easy and speedy database migration.
|
Why do I get a closed recordset from my stored procedure? |
| MsSQL | Views: 0 | |
| If you have tried to work through the resulting Recordset, you may have difficulties. This is due to how SQL Server and ADO work together when using stored procedures with multiple SQL statements. To learn how to fix this, and to allow for multiple SQL s.. |
What To Do When tempdb Is Full |
| MsSQL | Views: 0 | |
| Sim writes "I would like to know if tempdb has become full and what to do if you cannot truncate the log? I want to understand the process why you cannot truncate it." |
What is the Maximum Page Size in SQL Server 2000? |
| MsSQL | Views: 1 | |
| *Site Registration RequiredI have always read that 8060 bytes is the maximum size. This is stated over and over again in Books Online, the MS site and numerous other sites, including this one. However a post in our |
Using Triggers to track database action history |
| MsSQL | Views: 0 | |
| Tal Kelley demonstrates how to use triggers in SQL Server in order to keep track of who is modifying your database tables |
Using Triggers to Track Database Action History |
| MsSQL | Views: 0 | |
| Have you ever need to record each and every database insert and update statement for accounting purposes? This article, by Tal Kelley, examines how to use Microsoft SQL Server triggers to automatically record all updates and inserts for a particular data.. |
Using NEWID to Randomly Sort Records |
| MsSQL | Views: 0 | |
| We've got a quite a few articles on randomly selecting and ordering rows. I'm still amazed how popular that topic is. I recently stumbled across a post in the forums that led me to a better way to accomplish this. This has actually been posted a few time.. |
Using FTP in Transact-SQL |
| MsSQL | Views: 0 | |
| I’ve seen a few posts asking “How do I ftp a file into SQL” Well, if you have 6.5 or 7.0 this article should be helpful. Unfortunately it’s not an easy answer, but it’ll work great once you’ve set it up. The answer is .. |
Using Derived Tables to Calculate Aggregate Values |
| MsSQL | Views: 1 | |
| Calculating aggregate values can be simplified by using derived tables. In this article I show you how to use derived tables to calculate two independent aggregate values in a single SELECT statement |
Use This SP to Generate a SQL Server Job Report |
| MsSQL | Views: 0 | |
| Have you ever wanted to create a report listing all of the SQL Server jobs on your SQL Server 7.0 or 2000 servers? This is easy if you use the stored procedure I have created just for this purpose |
Understanding Identity Columns |
| MsSQL | Views: 1 | |
| Karla writes "How can I reset an Identity column and not start where it left?" I've been getting quite a few questions about identity columns lately. This article should cover everything I know about them. I'll cover creating them, populating them, reset.. |
Troubleshooting OLAP Problems |
| MsSQL | Views: 0 | |
| Alexander Chigrik shares 20 tips for solving problems with Analysis Services.
|
The sql_variant Datatype |
| MsSQL | Views: 1 | |
| Microsoft introduced the sql_variant in SQL Server 2000. You can use the sql_variant to store data of an unspecified or inconsistant type. Or to store data of almost any SQL Server datatype |
Take a bite out of your workload with SQL Server 2000 user-defined functions, part 2 |
| MsSQL | Views: 0 | |
| User-defined functions (UDFs) add new functionality to custom SQL Server 2000 applications. UDFs are similar to built-in functions, but you create them to perform specific tasks unique to an application, and you can modify them as needed. UDFs provide fa.. |
Stored Procedures in SQL Server |
| MsSQL | Views: 0 | |
| Stored procedures offer great performance, security and abstraction benefits to SQL Server developers |
Stored Procedures and Caching |
| MsSQL | Views: 0 | |
| *Site Registration RequiredOne of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of su |
SQL Server: Balancing access and security |
| MsSQL | Views: 0 | |
| Using SQL Server requires interaction with objects inside the database. And interaction requires users to access objects. This article explains how user access is granted |
SQL Server Upgrade Recommendations and Best Practices Part 1: Upgrade Overview and Project Planning |
| MsSQL | Views: 0 | |
| First in a series of new articles on how to best upgrade SQL Server. |
SQL Server System Databases |
| MsSQL | Views: 0 | |
| This article gives you an overview about role of the system databases in SQL Server |
|
