 |
How to recover database from suspect mode?
|
| Total Hit (26305) |
Sometime your database may go into suspect mode. A database can be marked suspect for one of the following reasons (this is from SQL Server Books Online):
«code LangId=0»If one or more database files are not available.
If the entire database is not available.
If one or more database files are
....Read More |
Rating
 |
|
|
|
|
|
|
|
Strip dirty characters from a numeric string.
|
| Total Hit (1732) |
A technique to search & remove dirty characters from a numeric string. This problem shows how you can simplify the solution by looking at only what is needed.
|
Rating
 |
|
|
|
|
|
|
|
Conditional Firing of Triggers.
|
| Total Hit (2078) |
This sample shows how you can conditionally fire triggers. This example shows how to suppress the trigger logic while inserting data from a SP & allowing other inserts to go through fine. A SQL6x/70/2000 version of the example is shown first & another one using the SQL70/2000 cursor function is show
....Read More |
| Rating
|
|
|
|
mark the stored procedure to automatic execution
|
| Total Hit (2758) |
You can use the sp_procoption system stored procedure to mark the stored procedure to automatic execution when the SQL Server will start.
Note. Only objects in the master database owned by dbo can have the startup setting changed and this option is restricted to objects that have no parameters.
....Read More |
| Rating
|
|
|
|
Implementing CRUD Operations Using Stored Procedures: Part 2
|
| Total Hit (547) |
In database terms, CRUD stands for the four essential database operations: Create, Read, Update and Delete. To create a high performance system, these four operations should be implemented by stored procedures, each procedure implementing one of the four operations. This is the second in a two part
....Read More |
| Rating
|
|
|
|
|
|
Implementing Error Handling with Stored Procedures
|
| Total Hit (630) |
This is one of two articles about error handling in SQL Server. This article gives you recommendations for how you should implement error handling when you write stored procedures, including when you call them from ADO.
|
| Rating
|
|
|
|
|
|
|
|
Using Microsoft SQL Server Constraints
|
| Total Hit (1255) |
In this article, I want to tell you about SQL Server constraints: what a constraint is, when it is used and for which purposes. You can find in this article some examples of constraint creation and SQL Server 2000 constraints enhancements.
|
| Rating
|
|
|
|
|
|
|
|
SQL Server "Yukon" Beta 1 Transact-SQL Enhancements
|
| Total Hit (940) |
This white paper introduces several of the new enhancements to Transact-SQL in Microsoft SQL Server "Yukon" Beta 1. These new features can increase your expressive power, the performance of your queries, and your error management capabilities. This paper focuses mainly on relational enhancements tha
....Read More |
| Rating
|
|
|
|
|
|
Encrypt and Decrypt Data in Yukon
|
| Total Hit (1066) |
Reports of more than 2 million credit card numbers stolen from merchants and data brokers in early 2005 brought about the expected knee-jerk reaction from federal lawmakers— new legislation that proposes to protect individuals against identity theft, such as the "Comprehensive Identity Theft Protect
....Read More |
| Rating
|
|
|
|
MDX in Analysis Services: Intermediate Concepts - Part 2
|
| Total Hit (913) |
This is the third tutorial article of the series, MDX in Analysis Services. The series is designed to provide hands-on application of the fundamentals of MDX from the perspective of MS SQL Server 2000 Analysis Services (to which I will refer in most cases as simply "Analysis Services," to save time
....Read More |
| Rating
|
|
|
|
Looping, Importing and Archiving
|
| Total Hit (667) |
One of the most common things asked for by people using DTS is the ability to loop through a directory and process files along the way. This is how I do it. Although it may look a little complicated for what is quite an easy task it isn't trust me.
|
| Rating
|
|
|
|
Report Definition Language Specification
|
| Total Hit (1016) |
In today's database reporting market, most vendor applications use a proprietary format for representing the definition of a report. In addition, vendors that provide a report execution environment usually only support their own design tools. For customers, this means that reports cannot be easily m
....Read More |
| Rating
|
|
|
|
|
|
|
|
Linked Servers : An overview
|
| Total Hit (1948) |
Linked servers provide connectivity to external data sources, allowing you to access data and run procedures in SQL Server other than the one you are currently running on.
|
| Rating
|
|
|
|
|
|
Random Sampling in T-SQL
|
| Total Hit (784) |
Imagine a company with a data warehouse that contains tens of millions of records on individuals. The analysts want to use it to do statistical analysis or data mining. Because it can be time-consuming to work with such a large number of records, analysts often select a small, random subset of recor
....Read More |
| Rating
|
|
|
|
A Comparison of SQL Server 2000 with Access 2000
|
| Total Hit (1014) |
Often people in newsgroups ask about some comparison of Microsoft SQL Server and Microsoft Access. In this article, I compare Microsoft SQL Server 2000 with Microsoft Access 2000 regarding hardware and software requirements, price, features and products limits.
....Read More |
| Rating
|
|
|
|
|
|
Developing with English Query
|
| Total Hit (794) |
It is easy enough to build a query form that allows users to search based on one or two fields, but it is much more difficult to build form-based Web pages that allow searches across multiple tables and multiple fields. A more flexible search is difficult to implement (there are many problems beyond
....Read More |
| Rating
|
|