Search Results | SQL Server Performance Forums

Pivot Query

Thread by: ajitgadge, Sep 29, 2009, 4 replies, in forum: SQL Server 2005 General Developer Questions

I wanted to write one query. Below is source table look likeuserid column0 column11 username john@yahoo.com1 firstname John1...

DB Partition with Sliding window

Thread by: ajitgadge, Jul 12, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi Expert, I am doing SQL 2005 table partition on our large tables. Basicaly , our goal is to reduce the space by slicing out the old data and...

SOS_Scheduler_Yield

Thread by: ajitgadge, May 11, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi , We are facing performance issue on one of our DB server from last few days. When i look at locking ;maximum waittype are taken by...

Performance Issue on SQL 2005 aftre migration from SQL 2000,

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

Hi Expert,I have some major performance issue after migration from SQL 2000 to SQL 2005. Before 1 month Back my application databases on SQL 2000 (...

Target Server memory

Thread by: ajitgadge, Nov 18, 2008, 2 replies, in forum: Performance Tuning for DBAs

Hello Experts,I have issue with Memory use in SQL server. Below are my databse server configurationsSQL Server version. SQL 2000 8.00.2050 (Intel...

Replication without PK

Thread by: ajitgadge, Nov 1, 2007, 7 replies, in forum: SQL Server 2005 Replication

Hello, I have to create DB Server for Reporting purpose ( Update statement also included on Reporting server). So i thought the best way to do it by...

Rebuild Index Job takes time and space.

Thread by: ajitgadge, Aug 15, 2007, 5 replies, in forum: Performance Tuning for DBAs

Hello All, I have Rebuild Index job on my server.We are running this on every weekend.It was running on server from last 4 month and taking 1 hrs...

Replicate those table witout Primary Key

Thread by: ajitgadge, Aug 7, 2007, 2 replies, in forum: Performance Tuning for SQL Server Replication

Hello Friends, I have setup Transactional replication in our Env. to replicate live server to report server. We have total 404 tables (Articales)...

Dual Core CPU

Thread by: ajitgadge, Aug 2, 2007, 6 replies, in forum: Performance Tuning for Hardware Configurations

Hello All, We are setting up 4 number of 64x2 dual core CPU (AMD ) on our SQL Server 2000 (Physical Count).So my SQL Server is detecting 8 No. of...

Waitetype-Writelog

Thread by: ajitgadge, Jul 30, 2007, 8 replies, in forum: Performance Tuning for DBAs

Hello, I am facing slowness issue on my SQL 2000 Server with Std edition. Actually, there is lot's of processes is running on server but which goes...

Memory Allocation for SQL Server

Thread by: ajitgadge, Jul 30, 2007, 11 replies, in forum: General DBA Questions

Hello, We have following server configuration. Windows 2003 Enterprise SQL Server 2000 Ent. CPU No: 8 Physical Memory 8 GB Only SQL Server is...

Secure ODBC

Thread by: ajitgadge, Jul 25, 2007, 1 replies, in forum: General DBA Questions

Hello, I am trying to setup Secure ODBC connection between our Hosting DB server and client server. Both are running on SQL 2000. I want to setup...