Atlanta Custom Software Development 

 
   Search        Code/Page
 

User Login
Email

Password

 

Forgot the Password?
Services
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
Programming
VB VB (1648)
VB.net VB.net (736)
C# C# (15)
ASP.net ASP.net (779)
ASP ASP (41)
VC++ VC++ (25)
PHP PHP (0)
JAVA JAVA (4)
JScript JScript (5)
  Database
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
Automation
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
OS/Networking
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
Graphics
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
Links
» ASP.net (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» VB.net (4)
» VC (3)
» HTML/CSS/JavaScript (10)
Tools
» Regular Expr Tester
» Free Tools

 

How to improve performance with pinned tables
Total Hit (1862) SQL Server experts know that the DB engine never accesses directly the data pages on disk; rather it uses a special module called "Cache Manager". It is possible, by using some T-SQL commands, to force the selected tables to stay in the buffer for a longer time. This technique increases the performa ....Read More
Rating
Improve I/O throughput of intelligent subsystems to favor SQL Server
Total Hit (1857) One of the peculiar features of Microsoft SQL Server is its capability to keep alive multiple threads at the same time for performing I/O operations. The configuration options that affects how many threads available for these operations is max async IO. The default value for this option is 32, which ....Read More
Rating
Monitor stored procedure and batch activity from remote workstations
Total Hit (1889) Using the sp_user_counterX stored procedure (where X is a number between 1 and 10) you can set internal SQL Server counters. This values are read by the Performance Monitor, the standard Windows utility that monitors system activity. The Performance Monitor is able to monitor not only the activities ....Read More
Rating
The fastest way to retrieve number of records in a table. This is an alternative of the standard "select count(*)...".
Total Hit (2743) To get the total row count in a table, we usually use the following select statement: «Code LangId=6» SELECT count(*) FROM table_name «/Code» This query performs full table scan to get the row count. You can check it by setting SET SHOWPLAN ON for SQL Server 6.5 or SET SHOWPLAN_TEXT ON for SQL ....Read More
Rating
Retrive record count of all tables in the database . This is the fastest way to get record count.
Total Hit (2580) Because SELECT COUNT(*) statement make a full table scan to return the total table's row count, it can take very many time for the large table. There is another way to determine the total row count in a table. You can use sysindexes system table, in this case. There is ROWS column in the sysin ....Read More
Rating
Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
Total Hit (2347) In this article, I want to tell you about some useful undocumented DBCC commands, and how you can use these commands in SQL Server 7.0 and 2000 for administering and monitoring. DBCC is an abbreviation for Database Console Command. DBCC commands are generally used to check the physical and logica ....Read More
Rating
Analyze Trace File data using T-SQL.
Total Hit (1938) Demonstrates the new system function fn_trace_gettable to read a capture trace file & analyze it using SQL.
Rating
How to perform case-sensitive ordering on case-insensitive servers?
Total Hit (2992) This script demonstrates the COLLATION capabilities in SQL Server 2000.
Rating
How to use the CHECKSUM function to find orphan rows & duplicates?
Total Hit (2470)
Rating
This is a link to a different site Benchmarking Performance of a Query - Part 2 CPU and I/O
Total Hit (1695) This is the second article in a series discussing benchmarking T-SQL query performance. The first article in this series discussed different methods of capturing the elapsed time of a T-SQL batch, pieces of a batch, or a single T-SQL statement. This article will discuss how to determine the amount o ....Read More
Rating
This is a link to a different site Benchmarking Performance of a Query - Part 1 Elapsed Time
Total Hit (711) How many times have you had more than one way to do something and wanted to determine which method was faster and/or which one used more resources? I am going to guess that most developers have run across this dilemma more than once. So how do you decide with method is faster--or which method requir ....Read More
Rating
This is a link to a different site Application Design Optimization Tips
Total Hit (821) Here are fifteen tips that you can use to ensure your Application Designs are performing in the most efficient manner possible.
Rating
This is a link to a different site SQL Server Bulk Copy Optimization Tips
Total Hit (1572) If you're having trouble with bulk copy, check out these 14 tips from Alexander Chigrik.
Rating
This is a link to a different site Examining SQL Server's I/O Statistics
Total Hit (647) Reading and writing to the disk is the heart of what any database management system does, SQL Server included. Input/Output (I/O) performance can make or break an application. This article discusses the diagnostic tools that can be used to examine SQL Server's I/O statistics so that you can make fac ....Read More
Rating
This is a link to a different site Scripting Traces for Performance Monitoring on SQL Server
Total Hit (823) The SQL Profiler is a great tool for monitoring and analyzing SQL Server Performance. I use it all the time to watch the detailed actions of a stored procedure, trigger or user-defined function (UDF) that I am developing. It can also be used to monitor aggregate performance of an entire SQL Server i ....Read More
Rating
This is a link to a different site Scalability and High Availability of Microsoft SQL Server 2000 (Part 4)
Total Hit (880) While clustering (covered in the first two parts of this series) provides high availability and distributed partitioned views (presented in the part three) helps increasing scalability, log shipping, discussed in this article, combines both types of functionality. As far as high availabilty is conce ....Read More
Rating
This is a link to a different site Scalability and High Availability of Microsoft SQL Server 2000 (Part 3)
Total Hit (848) In the first two articles of the series, I described concepts and implementation details of SQL Server 2000 clustering. Clusters are used primarily to provide high availability through their support for failover. In this article, we will look into Distributed Partitioned Views, which are intended fo ....Read More
Rating
This is a link to a different site How to Do SQL Server Performance Trend Analysis Part 1: Using Performance Monitor to Log Data
Total Hit (714) In this four-part tutorial, you will learn how to use NT Server 4.0's Performance Monitor and Microsoft Excel to monitor and analyze SQL Server performance. You will also learn how to use a SQL Server database to store your Performance Monitor logs. This tutorial assumes that you already know the ba ....Read More
Rating
This is a link to a different site How to Do SQL Server Performance Trend Analysis Part 2: Storing Performance Data in SQL Server
Total Hit (1340) This is part two of a four-part tutorial. This part discusses how to use SQL Server to store Performance Monitor log data. Part three will show you how to use Microsoft Excel to analyze the Performance Monitor Data. Part four will show you how to interpret your results. Read Part One. Read Part Thre ....Read More
Rating
This is a link to a different site How to Do SQL Server Performance Trend Analysis Part 3: Trend Analysis Using Microsoft Excel
Total Hit (1155) This is part three of a four-part tutorial. This part discusses how to use Microsoft Excel to create analysis charts and how to perform trend analysis using Performance Monitor data. Part four will show you how to interpret your results. Read part one. Read part two. ....Read More
Rating
This is a link to a different site How to Do SQL Server Performance Trend Analysis Part 4: Interpreting Performance Monitor Counters.
Total Hit (1800) In the previous three parts of this tutorial, you learned how to use Performance Monitor to collect SQL Server-related performance data, store it in SQL Server, and how to perform trend analysis on it. Now it is time to take a look at how to interpret the data you have collected. ....Read More
Rating
This is a link to a different site Optimizing SQL Server Performance Using Files and Filegroups
Total Hit (1361) There are no devices or segments in SQL Server 7.0 and SQL Server 2000, as there were in SQL Server 6.5. Now databases reside on operating-system files.
Rating
This is a link to a different site RDBMS Performance Tuning Guide for Data Warehousing
Total Hit (1305) This performance tuning guide is designed to help database administrators and developers configure Microsoft® SQL Server™ 2000 for maximum performance and to assist in determining causes of poor performance of relational databases, including those used in data warehousing. It also provides guideline ....Read More
Rating


Recommanded Links

 

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.