SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) : ssms

SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?

Mon, 27 Jul 2009 06:53:00 GMT

I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...(read more)

Do you know how many Monitoring Tools and Resources available in SQL Server?

Mon, 01 Jun 2009 07:25:00 GMT

Monitoring Tools and Resources are essential for performance tuning & better manageability in SQL Server. Many times the users think that collection and analysis of performance data is not a day-to-day job, also I feel that it is difficult at best...(read more)

SQL Server 2008 tools installation issues when SQL Server 2005 client tools are present - FAQ and gotchas.

SqlServer-QA.net — Fri, 02 Jan 2009 10:25:00 GMT

How many times you have faced the problems in installing SQL Server client tools? Have you ever tried to install latest version of SQL Server tools on previous version? Recently I have run into such a problem when installing SQL Server 2008 client tools...(read more)

Recover a database with no transaction log file - SQL Server 2005!

SqlServer-QA.net — Tue, 11 Nov 2008 07:16:00 GMT

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 2008 features and getting through CTP, RC, RTM. Are we there yet?

SSQA.net — Wed, 14 May 2008 08:23:00 GMT

I'm not going to shoot any questions to Microsoft about RTM release for SQL Server 2008, as it was made it clear from The Data Platform Insider blog post as: Extract: "Over the coming months, customers and partners can look forward to significant...(read more)

SSWUG.ORG - SQL Server Virtual Conference II

SSQA.net — Tue, 13 May 2008 07:31:00 GMT

What are the Top 16 things to know about SQL Server? Here are a couple MORE from our series of 16 specific tips ( you can even still watch the previous release of tips too! )... Do you keep getting advanced level SQL Server information when you could...(read more)

The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005

SSQA.net — Tue, 06 May 2008 15:07:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...(read more)

Query Execution Plans security and new feature within SQL Server 2008 Management Studio

SSQA.net — Tue, 04 Mar 2008 08:04:00 GMT

If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...(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

SSQA.net — Mon, 03 Mar 2008 08:02:00 GMT

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 2008: Administer multiple servers by designating configuration servers

SSQA.net — Wed, 27 Feb 2008 09:00:00 GMT

Ok, they give you new tool and in next release it has been taken away! This is similar to Surface Area Configuration tool from SQL Server 2005 and after 3 years you don't see from next release which is SQL Server 2008. How do you manage or can administer...(read more)

SQL Server Management Studio snap-in - get alerted when executing a TSQL code!

SSQA.net — Fri, 15 Feb 2008 10:26:00 GMT

Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...(read more)

Using Management Studio unable to select "create one file per object"?

SSQA.net — Wed, 17 Oct 2007 09:06:00 GMT

One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects...(read more)

SQL Server 2005 how to copy database maintenance plans between the servers?

SSQA.net — Mon, 15 Oct 2007 13:54:00 GMT

How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version. Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed...(read more)

Export SQL Servers registration using Management Studio?

SSQA.net — Wed, 03 Oct 2007 09:05:00 GMT

If you are managing hundreds of SQL Server and you might have organised your Management Studio screen with relevant server groups under Server registration. In this case if a new starter has joined and required to assist you in monitoring all of the SQL...(read more)

How to set the Animation Speed and make best use of SQL Server Management Studio tool?

SSQA.net — Mon, 01 Oct 2007 13:12:00 GMT

SQL Server Management Studio (SSMS) is a powerful tool in SQL 2005 that is re-written from previous of SQL Server, that also reduces the flaky features from Enterprise Manager. How to set the Animation Speed and make best use of SQL Server Management...(read more)

How to read Database transaction log in SQL Server?

SSQA.net — Fri, 28 Sep 2007 00:13:00 GMT

Another frequently asked questions in the forums and newsgroups, I have seen similar ones recently. I believe most of the newbie users ask this question and even more as interview based questions. So here is the catch in order to accomplish the task,...(read more)

OLAP Connectivity from Pivot Table in Excel - security permissions

SSQA.net — Tue, 25 Sep 2007 09:14:00 GMT

Security permissions in OLAP is similar to normal OLTP based environment. Say if you are using Pivot Table object in MS Office Excel to display the reports using OLAP objects like Cubes. To achieve this it should connect to an OLAP Server and database...(read more)

Whats the best way to setup memory on a four-node cluster?

SSQA.net — Thu, 06 Sep 2007 09:42:00 GMT

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...(read more)

FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated"

SSQA.net — Thu, 23 Aug 2007 20:17:00 GMT

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...(read more)

On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan

SSQA.net — Thu, 23 Aug 2007 20:15:00 GMT