|
|
|
|
|
|
|
|
|
|
 |
Avoid Auto Close and Auto Shrink.
|
| Total Hit (3037) |
I was on-site with a client, whose had a server which performing very sluggishly. It was a beefy brute with heaps of memory and processing power, so clearly something was just not what it should have been.
For me step 1 in doing any sort of trouble-shooting is to look at the logs. Yup, always a
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
using NT Authentication to login into SQL
|
| Total Hit (1117) |
This is for using NT authentication (NT users already setup in the Domain)
So you need to get the correct spelling of each user in User Manager for Domains.
Then it will get the user from NT when they log in and bingo they have permissions to the SQL server database too.
....Read More |
Rating
 |
|
|
|
|
|
|
|
How Do I Develop a Backup and Restore Strategy?
|
| Total Hit (1036) |
One of the most critical aspects of administering SQL Server is the Backup and Restore or Disaster Recovery strategy. Frequent questions in this forum indicate a general lack of knowledge and planning for backup and restore operations.
|
| Rating
|
|
|
|
|
|
|
|
Shrinking Databases and Logs - SQL 7 and Higher
|
| Total Hit (1873) |
SQL 7 and SQL 2000 allow automatic file growth. Therefore, the files can grow large. It is important to understand how to reduce the database and log files sizes.
There are two DBCC commands to help shrink databases and files. Both are needed to reduce and maintain file sizes.
....Read More |
| Rating
|
|
|
|
|
|
|
|
How do I know what type of index to create?
|
| Total Hit (1311) |
We get a lot of index questions related to what type of index should be created given a particular situation. I compiled the items below from books-online to facilitate this discussion:
Before creating clustered indexes, understand how your data will be accessed.
....Read More |
| Rating
|
|
|
|
|
|
|
|
How to Schedule a Job Programatically with VB
|
| Total Hit (839) |
First off, set a reference to Microsoft SQL-DMO in your VB project. You will need to have SQL Server 7 installed on your box for this. I haven't tried this under SQL 2000 or SQL 6.5
|
| Rating
|
|
|
|
A better Soundex code
|
| Total Hit (1044) |
Terms that are often misspelled can be a problem for database designers. Names, for example, are variable length, can have strange spellings, and they are not unique. American names have a diversity of ethnic origins, which give us names pronounced the same way but spelled differently and vice versa
....Read More |
| Rating
|
|
|
|
|
|
How do I set up and configure SQL Mail?
|
| Total Hit (1195) |
SQL Mail provides a way to send EMail from Micosoft SQL Server. The focus of this FAQ is configuration of SQL Mail. There are other ways to send Email from SQL Server. Links to articles about these alternatives to SQLMail are listed at the end of this FAQ.
....Read More |
| Rating
|
|
|
|
xp_regex: Regular Expressions in SQL Server 2000
|
| Total Hit (619) |
Regular Expressions are probably the best tool for text parsing. Using Regular Expressions GREATLY simplifies anything for which you would normally use CHARINDEX, PATINDEX, SUBSTRING, STUFF, REPLACE, etc.
|
| Rating
|
|
|
|
Summarizing Data with ROLLUP
|
| Total Hit (630) |
Oftentimes, when building Web-based reporting tools we need to show totals and sub-totals for information stored in the database. For example, imagine that you worked at an eCommerce site like Amazon.com that sold products from a variety of categories: books, electronics, clothes, etc. Managers woul
....Read More |
| Rating
|
|
|
|
Dynamic ORDER BY Statements in Stored Procedures
|
| Total Hit (1650) |
When creating data-driven Web applications, it is ideal to place the actual SQL statements into stored procedures, and to have the Web pages, then, call the appropriate stored procedures rather than executing the SQL statements themselves. (If you are unfamiliar with what stored procedures are, or t
....Read More |
| Rating
|
|
|
|
SQL Server and XML
|
| Total Hit (1112) |
Read the sample chapter from a new book released by Wrox Press, "Begining SQL Server 2000 for Visual Basic Developers". This chapter explores new XML features in SQL Server 2000 and takes a look at how you can exploit them to your benefit. We will also take a look at how we can use XSL (Extensible S
....Read More |
| Rating
|
|
|
|
Introduction to SQL : Sample chapter from Beginning SQL Programming
|
| Total Hit (696) |
This introductory chapter covers topics that students usually ask in the first hour of classes; essentially, just what do we mean by SQL? We start by explaining what SQL is and also what it is not, and we provide a brief overview of the history of the language. We'll also clarify some confusing term
....Read More |
| Rating
|
|