Search Results | SQL Server Performance Forums

Convert into one Select Query

Thread by: sonnysingh, Dec 23, 2012, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I have a query that need to Rewrite it without cursor, function or loop to produce same result and should be included in ONE SELECT (no...

SQL Server 2005 Linked Server Issue

Thread by: sonnysingh, Oct 17, 2011, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I am importing data every 5 minutes from production server using linked server. This service (job) running on 2 server e.g. fetching data...

Hardware Planning for DWH

Thread by: sonnysingh, Aug 1, 2010, 13 replies, in forum: SQL Server 2005 General DBA Questions

I need to do sizing the DWH DB server. The current scenarios are... Serversthat will last min 5 years (or want to retain 5 years data) Averagetotal...

Overflow Error with Performance DashBoard

Thread by: sonnysingh, Jul 7, 2010, 6 replies, in forum: SQL Server 2005 General DBA Questions

Hi I have following error came up when I click on any blue region in the chart for the SQL CPU utilization on the performance dashboard where you...

Capture Queries Run on SQL DB

Thread by: sonnysingh, Jun 25, 2010, 13 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I need to capture T-SQLs and transactions that run on SQL Server DB. How do I capture this information into table? Thanks in Advance...

Build DBA Dashboard

Thread by: sonnysingh, May 9, 2010, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi All We have SQL Server Dashboard that we can integrate with server. It is only accessible for DBA and within Mnagement studio. Is any one build...

Mirroring - Login failed for user 'username'. (Microsoft SQL Server, Error: 4064)

Thread by: sonnysingh, Apr 22, 2010, 10 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I am having this error while try connect automatically to the failover database by to application (failover). This is the user uses in the...

Setup Windows Authentication to Run ASP web Application

Thread by: sonnysingh, Feb 24, 2010, 8 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I need help to setup windows authentication account to run ASP application using this account. I am confuse on the steps to setup it. Pls let...

Linked Server Error using ODBC

Thread by: sonnysingh, Aug 18, 2009, 2 replies, in forum: General DBA Questions

I have the following linked server error. I have tried to create linked server using OLE DB ODBC connection. I have checked the following things and...

Critical !!! SQL Server Access Denied Due to Logon Trigger

Thread by: sonnysingh, Jan 9, 2009, 8 replies, in forum: SQL Server 2005 General DBA Questions

Hi All We can't able to access to the SQL Server due to the LOGON Trigger ON ALL SERVER. Somehow, rights has been degrade of this trigger under...

Recommendation for Hardware Requirements for SQL Server 2005

Thread by: sonnysingh, Dec 3, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi We have SQL Server 2005 Box requirements to consolidate good number of small databases on this one Server. DBs are around 25 and applications...

Login Related Events on SQL Server

Thread by: sonnysingh, Dec 1, 2008, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi Folks We need to create login and user related reports that contain information on each logins and users that access to the databases on a SQL...

Solving the 8000 Characters limit in Code

Thread by: sonnysingh, Dec 1, 2008, 12 replies, in forum: SQL Server 2005 General Developer Questions

Hi All Try to join up 2 variables that have 8000 max values as need take values more than 8000 characters but giving error (see below). Try to find...

Connect to a Hidden Instances

Thread by: sonnysingh, Dec 1, 2008, 6 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I want to find out all the hidden SQL Server Instances... How can i find them? Thanks in Advance sonny

The database is not accessible. (Object Explorer)

Thread by: sonnysingh, Dec 1, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi FolksWe have restored a database and create user with db_owner rights. But when we login for the database error message came up. "The database is...

Linked Server 2005 with SQL Server 7.0

Thread by: sonnysingh, Sep 27, 2008, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I have a linked server setup using SQL Server 2005 for Sql Server 7.0 version on PowerEdge 2950 with 8 CPUs and 4GB memory. It was on normal...

Performance issue with SQL Server with 8 CPUs

Thread by: sonnysingh, Aug 24, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I have migrated the production DB on newly boughted SQL Server (PowerEdge 2950) with 8 CPUs. The DSS application get slow (Reports) as CPU...

Doubt to Clear on Max Degree of Parallelism

Thread by: sonnysingh, Aug 22, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi ALL Please some one explain us se per following setting we have for our database.... name minimum maximum config_value run_value max...

SSIS Package Execution Error

Thread by: sonnysingh, Aug 7, 2008, 4 replies, in forum: SQL Server 2005 Integration Services

Hi All I am getting this following Error when scheduled package run.. Source: SalesDataLoad Connection manager "Excel Connection Manager"...

List out SP result columns into a Table

Thread by: sonnysingh, Jul 31, 2008, 17 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I need to list out the SP results columns in a table and for this using following SQL with Linked server.. select * into TEMP_Table from...