Welcome to SqlServer-QA.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.

Browse by Tags

All Tags » 2005   (RSS)
Production version of SQL Server 2005 Service Pack 3 (SP3) is released
From the Are you ready for SP3 and SQL2005SP3_WorkStarted posts here, it has been officially announced that the SP3 for SQL Server 2005 (out of CTP) is ready to downlod to test and apply on your SQL Server 2005 instances. The Official SQL Server News Read More...
Download SQL Server 2005 Books Online - Updated DECEMBER 2008
Here is another update on Books Online (BOL) for SQL Server 2005 - Download an updated version of the documentation and tutorials, to see what kind of updates are updated in the documentation once you downloaded & install see the " Additional Information Read More...
Recover a database with no transaction log file - SQL Server 2005!
Have you ever been in a situation that one of the database has been giving hard time! It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that Read More...
SQL Server 2005 Service Pack 3 - public beta for your action
As promised by SQL Server Developmen team about SQL Server 2005 SP3 the public beta is now available for your action and set of tasks for your 2005 environment. So what this public beta provides, this is a rollup Quick Fix Engineering that will have all Read More...
Cumulative Update 8 package for SQL Server 2005 Service Pack2
I felt like somehow I missed to post the availability of Cumulative Update package releases here and referring the last CU7_Update package blogpost now we have CU8 available for download if the specified problem occurs in your platform as per the KBA Read More...
SQL Server High Number of User Connections found on PERFMON, how to resolve it?
I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as Read More...
SQL Server 2005 unable to drop schema error: Cannot drop schema <> because it is being referenced by object
Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was decided Read More...
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?
No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the Read More...
SQL Server 2005 Service Pack 3 - work started
Ok here is the hot news for SQL 2005 users!!! From the Are you ready for SP3 post here, it has been officially announced the SP3 for SQL Server 2005 will be available in CY2008 (calender year 2008) that means before 31st December 2008! More from this Read More...
SQL Server 2005 logging providers - make best use for SSIS packages to diagnose the issues
Log or trace of activities will help you to get detailed information on what's going wrong, that too very useful for ETL based processes. In this regard within SQL Server 2005 using SSIS you can enable such logging within the package's runtime. This will Read More...
End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?
The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement Read More...
Error while executing DMV - Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.
DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the Read More...
The SQL server specified in SSIS service configuration is not present or is not available. This might occur where there is no default instance of SQL Server on the computer
Multiple versions of SQL Server installation is quite common when your enterprise is looking forward to upgrade to latest versions of SQL Server, in this regard recently one of the Application user reported a problem with regard to SSIS & DTS services Read More...
SQL Server license with multi-core CPU technology, confusing concepts?
How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology Read More...
SQL Server consolidation and virtualization - hot topic in the industry
I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall Read More...
More Posts Next page »