SqlServer-QA.net

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 database is located and further you might see the errors (may familiar to you):2008-11-08 ...

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 product milestones for SQL Server.  Microsoft is excited to deliver a feature ...

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 really use a solid foundation in SQL Server essentials? You're not alone.SSWUG ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and Major Modifications The identity column of the destination table does not contain the same identity values as the ...

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 using the TSQL SET statements such as SET SHOWPLAN_XML or SET STATISTICS XML, or by using the ...

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 on their server. They are still on process of assessing the move from SQL Server 2000 ...

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 the multiple servers with the configuration settings & setup! It is changed now where ...

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 new 'Server Alert' snap-in for SQL Server Management Studio from Danny in SQLBlogcasts will do the rest of job ...

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 per file, and it is still available within SQL Server 2005 using Management Studio. To ...

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 the issues with Service Pack2 for SQL 2005. In general you can take help of ...