Browse by Tags

64 bit computing configuration with SQL Server 2005 - what you can take-on?

Published 23 April 8 6:31 PM | SSQA.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...

Filed under: application, sql server, performance, x64, hardware, computing, sap, compatability, 64-bit

See how Resource Governor can help you 'in action' in managing SQL Server resources?

Published 8 February 8 2:11 AM | SSQA.net

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

Filed under: application, sql server, management, blogs, security, query, 2008, resource governor

Unattended installation of application on multiple sites by using sa password with a symmetric key, is it possible in SQL Server?

Published 29 January 8 1:36 AM | SSQA.net

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

Filed under: application, sql server, security, best practice, sql authentication, sa password, symmettric keys, store, windows authentication

FIX: The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the IRowsetFastLoad::Commit method in a SQL Server 2005-based application

Published 21 October 7 12:54 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: application, sql server, memory, kba, oledb, sqlnci

FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005

Published 24 September 7 1:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX...

Filed under: application, sql server, performance, replication, kba, 2005, memory leak, terminate, activex, initialize

Web Server: What’s New in IIS 7 for IT Pros

Published 4 September 7 8:34 AM | SSQA.net

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

Filed under: application, sql server, management, webcast, reporting, iis, pool, websites

Performance - check whether it is affecting application or system, don't blame SQL Server alone

Published 3 September 7 9:42 AM | SSQA.net

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

Filed under: application, sql server, performance, blocking, security, query, table, wait, queue, high cpu, oltp

FIX: An application that is included in SQL Server 2005 may stop responding when you specify a network protocol that is not valid in the application

Published 31 August 7 11:41 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: application, sql server, kba, stops, network, protocol

SQL Server Express installation on X64 platform?

Published 28 August 7 6:5 AM | SSQA.net

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

Filed under: application, sql server, performance, x64, service pack, platform

TSQL cursors vs API cursors - poor cursor usage

Published 27 August 7 8:54 AM | SSQA.net

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

Filed under: application, sql server, performance, usage, cursor, tsql, api, heavy

.Net framework 3.5 beta1 - get now for new features

Published 17 July 7 8:15 AM | SSQA.net

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

Filed under: application, sql server, performance, windows, .NET

Using Application roles and security - SQL Server 2005

Published 19 June 7 3:30 PM | SSQA.net

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

Filed under: application, sql server, performance, msdn, security, roles

SQLServer2005 Profiler (profiler90.exe) fails to launch with Application Error (0x0000005)

Published 19 June 7 3:16 PM | SSQA.net

Further details and resolution for this problem can be found from this FAQ entry....( read more ) Read More...

Filed under: application, sql server, profiler, error log

What is the default datetime format in SQL Server?

Published 8 May 7 9:18 AM | SqlServer-QA.net (SSQA)

There might be various questions in the forums asking what is the default datetime format in SQL Server, how to change the date format. Further into the details make a note that there is no international standard for representation of datetime values...

Filed under: dashboard, defragmentation, application, datetime, sql server