SqlServer-QA.net

TechNet Webcast: SQL Server 2008 (Part 3 of 3): Integrate Growing Data Volumes (Level 300)  Attend this session to learn how to integrate growing volumes of data with the new enhancements in Microsoft SQL Server 2008. We cover new technologies, like Change Data Capture and MERGE SQL statement, in addition to scalability improvements in SQL ...

You all might know this SQL-HomePage would take you to the SQL Server webpages on Microsoft and now with recent launch 2008 wave another new site created specific to SQL Server 2008, which is SQL-Server-2008. Nothing major difference here as the first link would also take you through but with few clickes and bookmark this new link if you ...

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual platform for BI & Relational Databases that are built in latest operating system with new ...

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 (i.e. a single CPU socket that has more than 1 core appearing as multiple logical CPUs) is a ...

Its nearly 90 days from SQL Server 2008 November CTP and as per the CTP release cycle (90 days) the next instalment of SQL 2008 may be ready by end of this month. I feel that may be the last one before the RTM or as per the communication from Microsoft product development team feedback, but looking at the recent release ...

Using SELECT @@VERSION statement you can get simply get information of SQL Server you are running , when connected to that SQL Server instance. What if to know same for the Analysis Services components, we don't have such an easy way to find out! I mean there isn't a straight way to find out, but using few statements you could get it, by ...

You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that there is a change in behaviour between SQL 2000 and 2005 versions. The problem here is ...