SqlServer-QA.net

It has been a while in posting X64 related information here, so that comes now about configuration gotchas you may need, for a starter though.   X64 computing platforms have become common installations now a days due to the hardware reduced costing and availability, at the same time the DBA will have big job to tune the platform in terms of ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the ...

Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL Server. It is always better to be proactive than reactive, when it comes to identifying and ...

Can we get install SQL Server Express 2005 edition on X64 environment? Yes and No. Yes for SQL Server Express on X64  and EMT64 that too in Windows on Windows (WOW), but No it is not supported on IA64 systems. This enhancement is enabled since the service pack2 release of SQL Server Express 2005 edition. So on the above enabled X64 ...

  Cursors are based for a definitive purpose, but heavy usage of such methods will prove as costly expense on database performance. The process of cursor is prolonged, as a cursor first has to be defined with its features set, then populated after positioning (scrolled) to a set of record(s) and fetched every time. Finally once the ...

If you are building on the new features in the .NET Framework 3.0, such as Windows Workflow Foundation (WF), Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), and Windows CardSpace, you'll want to preview the The .NET Framework 3.5 Beta 1 release, which will ship with Visual Studio 2008. .NET Framework 3.5 adds several ...

In SQL Server, you can create database roles for easier administration of permissions in a database. Instead of granting individual permissions to each user separately, you can group users with the same permission needs by making them members of the same regular database role, and then assigning permissions to the database role itself. Unless a ...

Take the Application Platform Infrastructure Optimisation assessment to measure the effectiveness of your current infrastructure in platform-agnostic terms, and compare your application platform infrastructure against industry best practices and the latest IT research. http://www.microsoft.com/business/peopleready/appplat/ac/apio.mspx