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 ...

As you may be aware about new features within SQL Server 2008, one of the them is Resource Governor which is a feature than you can use to manage SQL Server workload and system resource consumption. It will enable you to specify limits on the amount of CPU and memory that incoming application requests can use and it is configurable in SQL Server ...

The newest ranch of Security - trust worthy features in SQL Server 2005 usage of symmetric keys has an important role. Always the document suggests to use Windows Authentication of security purpose and better control of user/security management, but when you talk about third party tools this is often ignored and you must make use of SQL Server ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and All Modifications FIX: The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the ...

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 ...

So what's coming wth IIS7, the overview session will highlight the key points of interests for IT Pros in Internet Information Services version 7.  IIS7 modularity increases security by allowing a reduced installation footprint and creation of specialized, streamlined servers. Application Pools are now “sandboxed” by default.  You’ll ...

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 ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and All Modifications FIX: An application that is included in SQL Server 2005 may stop responding when you specify a ...

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 ...