|
|
|
|
|
Total Hits: 103 | Today: 0
|
Author: Jasper Smith
|
Rating:
|
|
In this series of articles, I'll demonstrate how to use SMO (SQL Management Objects) to do a variety of common DBA tasks including Backups, Restores,Index Maintenance, Integrity checks and more. These are some of the operations available in the SMO database maintenance utility available on this site - ExpressMaint. In this article we will concentrate on how to perform restores using SMO in SQL2005. For information on how to build and compile a SMO application please review Getting Started with S...
|
|
|
|
Total Hits: 273 | Today: 0
|
|
Rating:
|
|
This step-by-step article discusses the steps you can use to change the SQL Server sa (system administrator) password...
|
|
|
|
Total Hits: 298 | Today: 0
|
Author: Joe Chang
|
Rating:
|
|
Many production databases today are in the tens or hundreds of gigabytes in size. That size is not a problem for production hardware. However, developers generally like to work on their personal computers, including notebooks with limited disk capacity, so a 10-100GB database size is an issue. Furthermore, it can be impractical to transfer such large data files over the network on a regular basis, if working time is lost. For this reason, it is preferable to work on a smaller sized database with...
|
|
|
|
Total Hits: 526 | Today: 0
|
Author: Nils Bevaart
|
Rating:
|
|
As a SQL Server DBA, one of my tasks is to monitor the performance of our databases. Our primary database holds the data of over 18 million people. A web-based application queries the database with a variety of search options. When examining the performance of these queries, most performed very well. But on the other hand, a few queries have resulted in a time-out. One of the first steps in analyzing the time out problem was to find the search pattern used in the slow running queries. I found th...
|
|
|
|
Total Hits: 426 | Today: 0
|
|
Rating:
|
|
This article describes how to configure the SQL Server for .NET applications. By default, the SQL Server denies access to user accounts that have not explicitly been granted access to a database, a table, or a view. By default, ASP.NET applications run in the context of the ASPNET user account. Unless you permit access to the ASPNET user account, an ASP.NET application cannot read and cannot update data in an SQL Server database. This article describes the process that you can use to permit an A...
|
|
|
|
Total Hits: 358 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
sp_readerrorlog can be used to read the SQL Server error logs from within T-SQL. If you call sp_readerrorlog without any parameters, it will display the current error log. You can go back to previous error logs, by specifying a number as the first parameter. So far so good.
...
|
|
|
|
Total Hits: 369 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
This article discusses how to generate SQL scripts for repetitive tasks, using T-SQL
...
|
|
|
|
Total Hits: 291 | Today: 0
|
Author: Krishnan M Kaniappan
|
Rating:
|
|
In this article I would like to discuss about the following two things:
1) About shrinking the transaction log.
2) Different ways of taking the database offline.
...
|
|
|
|
Total Hits: 552 | Today: 0
|
|
Rating:
|
|
This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server....
|
|
|
|
Total Hits: 91 | Today: 0
|
Author: extremeexperts
|
Rating:
|
|
Also called as RDB this is a new concept in SQL Server 2005 which I thought was worth taking a look at. In previous version of SQL Server 2000 whenever we had to upgrade a system defined object we had to drop and recreate. And rollback of the same was also something that we as DBA's had to break our heads. All the service packs have a disclaimer that states we backup our databases before we start the installation sequence . Even though I recommend it strongly, let us take a tour of how the new ...
|
|
|
|
Total Hits: 326 | Today: 0
|
Author: Michael Balloni
|
Rating:
|
|
Relational databases like Microsoft's SQL Server use locks to prevent multiple users from making conflicting modifications to a set of data: when a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and relinquishes the lock. There are exceptions, but let's not go there....
|
|
|
|
Total Hits: 180 | Today: 0
|
Author: Carl Nolan
|
Rating:
|
|
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition. The article then concentrates on XML support, covering XML data retrieval and manipulation, queries, and HTTP...
|
|
|
|
Total Hits: 224 | Today: 0
|
Author: Brian Kelley
|
Rating:
|
|
This article will concentrate on the basic services under which SQL Server 2000 runs. By understanding how SQL Server operates and the permissions thereof, we can quickly narrow down on issues that will occur in a production environment. Also, we can help our NT administrators understand what they shouldn't stop and/or disable when SQL Server needs to be kept running. Ever have a system administrator shut down the SQL Server Agent service running backups by mistake? Not a pretty sight!...
|
|
|
|
Total Hits: 344 | Today: 0
|
|
Rating:
|
|
The starting point in normalizing the current database was to analyze the existing program and database. Because the program is old and has been updated many times there is no programmer available to discuss design issues. The new database design will be based on user input, the existing program, and the existing database....
|
|
|
|
Total Hits: 384 | Today: 0
|
Author: Narayana Vyas Kondreddi
|
Rating:
|
|
In this article I am going to explain, how to track file growths, especially the database files. First of all, why is it important to track database file growth? Tracking file growth, helps you understand the rate at which your database is growing, so that you can plan ahead for your future storage needs. It is better to plan ahead, instead of running around when you run out of disk space, isn't it? So, how can we track file growths? There are a couple of ways....
|
|
|
|
Total Hits: 484 | Today: 0
|
Author: Guy van den berg
|
Rating:
|
|
Index Tuning Wizard - The Problem of Automatic Index Selection. As if by magic…New to SQL Server 7.0 the Index Tuning Wizard is one of the many novel self-administrative features included in this release. Within this series of articles I'll take a look at the wizard, how best to use it and how to interpret its’ output....
|
|
|
|
Total Hits: 591 | Today: 0
|
Author: Divya Kalra &Narayana Vyas Kondreddi
|
Rating:
|
|
This article explains best practices for system administration in a Microsoft SQL Server 7.0 / 2000 environment, including regular maintenance tasks.
...
|
|
|
|
Total Hits: 454 | Today: 0
|
Author: Andy Warren
|
Rating:
|
|
In this article I'd like to continue that discussion by looking at four of the fixed database roles; db_datareader, db_datawriter, db_denydatareader, and db_denydatawriter....
|
|
|
|
Total Hits: 1396 | Today: 0
|
Author: Randy Dyess
|
Rating:
|
|
Trace flags are used to temporarily enable or disable specific database functions allowing you to change default database behavior or to observe hidden database behavior and will remain in effect until they are either manually turned off or SQL Server is restarted. Keep in mind that most trace flags are undocumented and Microsoft can and will change the behavior of the flag between SQL Server versions, service packs or hotfixes....
|
|
|
|
Total Hits: 339 | Today: 0
|
Author: Andy Warren
|
Rating:
|
|
In that article I outlined a "trick" you can use if the new server will have the same logical drive configuration as the old one. If the logical drive configuration is different or you only want to move a portion of your files, usually the easiest way is to detach them from the original server and then attach to the new one, which gives you the chance to change the physical locations of the files for each database. The downside to that is that if you have a lot of databases to move, it gets very...
|
|
|
|
|
|
