Search Results | SQL Server Performance Forums

T-SQL Query

Thread by: SQL2000DBA, Oct 15, 2009, 1 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I need small help in writing T-SQL statement in SQL Server 2000. I have table with following records S_No MYNAME...

Running Upgrade Advisor in Active/Active

Thread by: SQL2000DBA, Jul 9, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I am running upgrade advisor 2008 in Active/Active Clustering of SQL Server 2005. I have first node1 with Database Engine as Default and Node 2...

Clustering Error

Thread by: SQL2000DBA, Jun 29, 2009, 2 replies, in forum: SQL Server 2005 Clustering

Hi, Need your help.I am trying to move resources from node1 to node2 in active/passive clustering. I am getting below Event Type: Error Event...

Upgrade SQL Server 2005 Clustering -Active/Active

Thread by: SQL2000DBA, Jun 17, 2009, 2 replies, in forum: SQL Server 2005 Clustering

Hi, Please let me know your inputs, experience or documents (excluding SQL2008UpgradeTechnicalReferenceGuide.docx) on upgrading active/active...

Centralise Database Management Tool

Thread by: SQL2000DBA, Mar 31, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Does anyone used any central database management tools for monitoring approx. 50 instances of SQL Server in Production envrionment. If yes, then...

Assessement of SQL Server Environment

Thread by: SQL2000DBA, Mar 16, 2009, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Please let me know any good article or your view on assessement of SQL Server 2005 environment. I need to perform the task wherein I have to...

SQL SERVER 2000 CLUSTERING

Thread by: SQL2000DBA, Aug 24, 2008, 3 replies, in forum: SQL Server Clustering

Hi, Please let me know whether 32 bit SQL Server 2000 Enterprise Edition(SP3A or SP4) supports on Windows 2003 Enterprise Edition R2. Please let me...

SQL Profiler

Thread by: SQL2000DBA, Aug 24, 2008, 2 replies, in forum: General DBA Questions

Hi All, Please let me know any third party tools which can be use in place of SQL profiler and also new tool should have better features compared to...

CPU Utilization

Thread by: SQL2000DBA, Aug 21, 2008, 1 replies, in forum: Performance Tuning for DBAs

Hello everyone, I need your inputs on SQL Server CPU utilization. My server details is as below. Manufacturer DELL System Type X86-based PC Model...

AWE ENABLE ON SQL SERVER CLUSTERING

Thread by: SQL2000DBA, Aug 19, 2008, 4 replies, in forum: General DBA Questions

hi, I need your inputs whether below configuration is right or some issue. I have nodes with SQL Server 2000 Clustering and Windows Enterprise...

Output File Size Restriction

Thread by: SQL2000DBA, Aug 12, 2008, 1 replies, in forum: SQL Server 2005 Integration Services

Hi, I need your help to understand, how i can restrict output file size in SSIS ?. I am trying to export data from table into a flat file and I have...

RAID implementation for SQL Server 2005

Thread by: SQL2000DBA, Jul 29, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Please let know the best practices or microsoft guildeline for implementing the RAID for tempdb and Application Database that is which RAID to...

Data Processing Approach

Thread by: SQL2000DBA, Jun 21, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hello Everyone, This new post is related to get your suggestion/advice/best practice related to Data Processing. I am involve in designing/developing...

Rough estimation on database hardward requirement

Thread by: SQL2000DBA, Jun 6, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, This question is to just get an idea of database hardware requirement based on following criteria 1). Processing 1000 thousand records in 3 to 4...

Test Proper Installation of SQL Server 2005

Thread by: SQL2000DBA, Dec 19, 2007, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi, Please guide me how we can test whether SQL server 2005 Enterprise Edition on Itanium server is succesfully installed or not. Please brief me...

Exception thrown from CATCH Block

Thread by: SQL2000DBA, Nov 13, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

Can anyone please explain me why I am getting different exception thrown when I use transaction and when I comment out the transaction? I have two...

Export Report data into Text Format with export file extension as .txt

Thread by: SQL2000DBA, Sep 10, 2007, 2 replies, in forum: SQL Server 2005 Reporting Services

Hi, I am using SQL Server 2005 Reporting Services. I need small help on how to export report data into text format with file extension as TXT. I can...

IDENTITY VALUE RESET

Thread by: SQL2000DBA, Aug 9, 2007, 14 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I am facing typical problem where in i am not able to rollback the identity key value. In my opinion anything i do inside the transaction and...

Run Queries in Parallel

Thread by: SQL2000DBA, Jun 13, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I need small help in reducing the time taken by stored procedure to send output as resultset to client application. I have stored procedure...

Varchar data type is good candidate for PK

Thread by: SQL2000DBA, Apr 24, 2007, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi, i need small inputs from your end to conclude whether to use varchar as primary key or not.To find out the performance difference between...