SqlServer-QA.net

PASS community connector email that I would like to share! Prove that you've got what it takes! Build the next generation of community applications on SQL Server 2008 in CodePlex: websites, enterprise suites, samples, gadget, tools, guidance, etc.YOU could be a Grand Winner!Don't miss your chance to enter, visit the SQL Heroes 2008 Official ...

Event: SQL Server 2008 Performance and Scalability Technologies Level: 300   SQL Server 2008 supports very large databases, enterprise-scale reporting systems, and data warehouses. It provides growing database systems with tools and features to optimize performance, scale up individual servers, and scale out very large databases. SQL ...

In continuaton to UK User Group conference (2 day) in Microsoft Campus, Thames Valley Park Reading here is my presentation to download that was delivered on 09th April 2008.  If you are unable to download from SkyDrive then click here. Appreciate your feedback.      

Few times I get such error  Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initializeName Microsoft SQL Enterprise ManagerCLSID : {00100100-1816-11D0-8EF5-00AA0062C58F} Tried ...

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 You may receive an error message when a SQL Server 2005 client requests encryption and connects ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition& SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications The auto update statistics option, the auto create statistics option, and the Parallelism setting ...

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 FIX: Error message when you run a stored procedure that starts a transaction that contains a ...

Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise edition instance. Coming to the problem on a server having 6GB RAM and ...

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is: You will find under Management studio open connection against that SQL instance and see under Server ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services & SQL Server 2005 Standard EditionNotification Contents: New and All Modifications A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1http://support.microsoft.com/kb/913090/en-US