Search Results | SQL Server Performance Forums

T-SQL Query

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

Thanks. I got the answer asSELECT * FROM MYTABLE T INNER JOIN ( SELECT MAX(MYDATE) AS MYDATE,DATEPART(MM,MYDATE) AS MYMONTH FROM MYTABLE GROUP BY...

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

Post by: SQL2000DBA, Jul 10, 2009 in forum: SQL Server 2005 General DBA Questions

Hemant, Thanks for reply. I have already referred above blogs. My issue is something different. I am facing issue of connecting Upgrade Advisor to...

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

Post by: SQL2000DBA, Jun 30, 2009 in forum: SQL Server 2005 Clustering

Hi, Thanks for your reply. H: drive is moving to other node2. On node 2, I can browse H: drive but I can't see SQL Server folders.it's empty. Look...

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

Using OEM Grid Control to monitor sql servers

Post by: SQL2000DBA, Jun 17, 2009 in forum: SQL Server 2005 General DBA Questions

Hi, i have used OEM grid control for monitoring Oracle Server. This is Oracle Product not SQL Server. Please verify the tool name.

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

Post by: SQL2000DBA, Mar 16, 2009 in forum: SQL Server 2005 General DBA Questions

Hi, i am sorry for not making it clear. I need to assess existing SQL Server 2005 environment which is running in Production environment, yes with...

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 2005 database migration

Post by: SQL2000DBA, Jan 29, 2009 in forum: SQL Server 2005 General Developer Questions

Hi Ashish, Welcome to the forum. On a high level, whenever you are doing any migration you should go through following migration phase 1). Analysis...

SQL 2005 Cluster 64-Bit & Memory

Post by: SQL2000DBA, Jan 28, 2009 in forum: SQL Server 2005 Clustering

Welcome to the forum. I would suggest you to first go with one instance and monitor the performance of your server(You can see below performance...

Problems having a user run a job! - FRUSTRATING....

Post by: SQL2000DBA, Jan 28, 2009 in forum: SQL Server 2005 General DBA Questions

Please do not select all SQLAgent database fixed role in MSDB. Just select SQLAgentUserRole database fixed role, which has least privileged. In case...

# network ports needed for a two-node active passive cluster

Post by: SQL2000DBA, Jan 15, 2009 in forum: SQL Server 2008 Questions [Archive Only - Closed]

I would go for option 3.1 . This is because I dont want to mix replication and heartbeart network traffic together. If i do, we may come occur an...

Bulk insert - need urgent help

Post by: SQL2000DBA, Oct 10, 2008 in forum: SQL Server 2005 General DBA Questions

Ok. Please try this. 1). Login to vsdap232 server and Share "D:POC" folder "POC" 2). Right click on POC folder and go to Sharing and Security...

How to determine when index statistics need updating?

Post by: SQL2000DBA, Oct 9, 2008 in forum: SQL Server 2005 Performance Tuning for DBAs

But I believe AUTO_UPDATE_STATISTICS and AUTO_CREATE_STATISTICS enabling comes with some extra overhead. Sometime if statistics are outdated,Database...

Remove partitioning from a table

Post by: SQL2000DBA, Oct 9, 2008 in forum: SQL Server 2005 General DBA Questions

Welcome to the forum. If I understand your question correctly, I believe you have to explicitly DROP the function and Scheme using DROP PARTITION...

Bulk insert - need urgent help

Post by: SQL2000DBA, Oct 9, 2008 in forum: SQL Server 2005 General DBA Questions

Please ensure that user you are connected with management has access to '\vsdap232d$POCbySKU.csv' folder. Please refer BOL Security Account...

Technet - no download for Enterprise SP2 ?

Post by: SQL2000DBA, Sep 24, 2008 in forum: SQL Server 2005 General DBA Questions

Please download SP2 from http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en