MSSQLCity.Com - All about MS SQL
     
About Us  
SSWUG Articles  
Articles  
Administering  
Comparison  
General  
Know How  
Replication  
Tuning  
Undocumented  
UDF  
SQL 6.5  
FAQ  
Scripts  
Tips  
Test Exams  
Advertise  
Download  
History  
Search  
Traffic  
Related Links  
     
Your button logo
Add to Favorites
 
     
 

SQL Server Articles

Administering


Troubleshooting SQL Server Jobs
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server jobs. He also tells you how you can resolve these problems.


Troubleshooting SQL Mail
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Mail. He also tells you how you can resolve these problems.


Troubleshooting SQL Server Alerts
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server alerts. He also tells you how you can resolve these problems.


Stored Procedures Administration
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows you some details about SQL Server stored procedures execution plans and cache.


Managing Users Permissions
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows how you can manage SQL Server users permissions.


Reducing SQL Server Index Fragmentation
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows how you can reduce SQL Server index fragmentation.


Backup and restore databases and transaction logs
Created by: Alexander Chigrik

In this article, Alexander Chigrik describes SQL Server 2000 recovery models and difference between them.


Attaching and Detaching Databases
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows how you can detach SQL Server databases and attach them later.


Troubleshooting SQL Server 2000 installation
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have when you install SQL Server 2000. He also tells you how you can resolve these problems.


Troubleshooting OLAP Problems
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains how you can resolve the SQL Server 7.0 OLAP Services problems and SQL Server 2000 Analysis Services problems.


How to troubleshoot connection problems
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains how you can resolve the connection problems.


How to troubleshoot backup/restore problems
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have during backup/restore operations. He also tells you how you can resolve these problems.


How to troubleshoot DTS problems
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have when you work with DTS. He also tells you how you can resolve these problems.


How to troubleshoot full-text search problems
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have when you work with full-text search. He also tells you how you can resolve these problems.


Troubleshooting SQL Server 7.0 installation
Created by: Alexander Chigrik

In this article, Alexander Chigrik explains some problems that you can have when you install SQL Server 7.0. He also tells you how you can resolve these problems.


Setup full-text search: step by step guide
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows you some general full-text search concepts: software requirements, Microsoft Search Service, maintaining full-text indexes, the comparison of full-text indexes with regular SQL indexes, and how to set up full-text search step by step.


Microsoft SQL Server roles
Created by: Alexander Chigrik

Roles are the new SQL Server 7.0 feature, which was not available in the previous versions. SQL Server roles act like Windows NT local groups.


Locking in Microsoft SQL Server
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows you the methods that SQL Server 7.0 uses when locking data.


Detailed locking view: sp_lock2
Created by: Alexander Chigrik

As a SQL Server DBA, you may often need a reference to information about locks. Microsoft recommends to use sp_lock system stored procedure to report locks information, but it may not provide enough information sometimes. In this article, Alexander Chigrik shows you how to use sp_lock2 to receive more information about your processes.


SQL Server 7.0 Security Modes
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows you the various security models in SQL Server 7.0 and how to change models after installation.


SQL Server 7.0: index statistics details
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows you how SQL Server 7.0 handles statistics.


SQL Server 7.0 Installation
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows you some details about installing SQL Server 7.0 and some of the ways to verify that you had a successful installation.


SQL Server 2000 Installation
Created by: Alexander Chigrik

In this article, Alexander Chigrik shows you some details about installing SQL Server 2000 and some of the ways to verify that you had a successful installation.


 

 
Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators.

(c) 1997, 2010 Bits on the Wire, Inc