Welcome to SSQA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Friday, April 20, 2007 - Posts

TOP 100 Percent ORDER BY Considered Harmful
TOP 100 Percent ORDER BY Considered Harmful Straight to the subject about how it works in SQL 2000 & 2005. Read More...
Posted: Friday, April 20, 2007 7:40 AM by SQL Master | 0 Comments
Filed under: ,
Database Diagram problems when upgraded from SQL 2000 to 2005
When you have tested the application for SQL Server 2005 comtability and upgrade process then your UPGRADE task will be easy to manage. But if you have used the Diagrams within SQL Server during the previous version, then there is a problem and here is Read More...
Posted: Friday, April 20, 2007 5:59 AM by SQL Master | 0 Comments
Filed under: , , , , , , , , ,
TCP Provider: An existing connection was forcibly closed by the remote host
Scenario is like this: Error generated when trying to register the Linked server between 2 SQL instances. SQL Server setup information is as follows: provider:SQL native Client Product Name: SQLNCL1 Data Source: Somewhere IN this world (SQLServer 2000 Read More...
Posted: Friday, April 20, 2007 5:50 AM by SQL Master | 0 Comments
Filed under: , , , , , ,
I/O what I want to know - a newbie question
I/O means Input and Output in simple terms, but in SQL Server world it has a vast significance to handle for performance and tuning. Here are few I/O basics chapters that will help the new users in SQL Server to understand : http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx Read More...
Posted: Friday, April 20, 2007 2:46 AM by SQL Master | 1 Comments
Filed under: , , , ,