Search Results | SQL Server Performance Forums

MSDE Login Problem

Thread by: essamughal, Jun 29, 2005, 3 replies, in forum: General Developer Questions

Hi All; <br /><br />MSDE has so many complication to install and to use. So, I am facing one problem right now. It is very frustrating right now. I...

Linked Server is already exists as a Subscriber

Thread by: essamughal, Jun 2, 2005, 1 replies, in forum: General DBA Questions

Hi All; I have a small problem, I have a DEVSQL SQL Server 2000, I am trying to add another SQL Server 2000 i.e. 'STAGESQL' as a linked server...

Need solution for that situation?

Thread by: essamughal, Apr 27, 2005, 1 replies, in forum: General DBA Questions

I have a situation where I have to take decision: We have different web applications let say 4, running on different web servers and on different...

Order of Index, how it works?

Thread by: essamughal, Mar 29, 2005, 1 replies, in forum: Performance Tuning for DBAs

Hi All; I have a table and it has one primary key i.e. BID , one Foriegn Key LOCID and one EntryDate column which has datetime datatype. It has so...

Effects of using Transaction in SP on Performance?

Thread by: essamughal, Mar 21, 2005, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi All; I have a web application which is being used at large scale and there are upto 10,000 entries per day. Currently, there is no Begin...

IDENTITY Column and Partision View?

Thread by: essamughal, Mar 16, 2005, 2 replies, in forum: Performance Tuning for DBAs

Hi; I have a question, Can we use IDENTITY Column which is Primary Key as well in our Partisioned tables which creates Partisioned View? Here are...

Partisioning a Large table?

Thread by: essamughal, Mar 16, 2005, 9 replies, in forum: Performance Tuning for DBAs

Hi; Version: SQL Server 2000 I have a large table which has about 3 millions records and it is increasing daily by few thousands, so I am trying...

NOT FOR REPLICATION Option for Snapshot only?

Thread by: essamughal, Feb 28, 2005, 0 replies, in forum: Performance Tuning for SQL Server Replication

Hi All; I am working on replication, I just want to do snapshot replication, I have tables which have IDENTITY Columns. Does it require to create...

Replication and Primary Key on a table?

Thread by: essamughal, Feb 17, 2005, 5 replies, in forum: Performance Tuning for SQL Server Replication

Hi; <br /><br />I am working on replication, I am trying snapshot replication but I am having one error i.e. Error No. 207 "Invalid Column Name ''" ,...

How can I catch Error Description?

Thread by: essamughal, Feb 15, 2005, 2 replies, in forum: General Developer Questions

Hi; I want to save Error Description which SQL Server generates when its running any query, for example Foriegn Key error when inserting, SQL...

Catching Error Description?

Thread by: essamughal, Feb 15, 2005, 8 replies, in forum: T-SQL Performance Tuning for Developers

Hi; I want to save Error Description which SQL Server generates when its running any query, for example Foriegn Key error when inserting, SQL...

Nested Transaction in Stored Procedure

Thread by: essamughal, Feb 14, 2005, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi ; I am implementing Transaction to one of the big stored procedure which calls so many other nested stored procedures and so on. There is 4...

Derived Table and TempDB relationship ?

Thread by: essamughal, Feb 10, 2005, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi; I have a query which is accessing around 1.7 millions records and it gives me around 0.4 millions records as a results. I used four five tables...

Replication and Primary Key IDENTITY column?

Thread by: essamughal, Feb 7, 2005, 3 replies, in forum: Performance Tuning for SQL Server Replication

Hi ; I want to know about any kind of relation between Primary Key IDENTITY Column of a table and replication. Is there any requirement for...

Compare Views and User Defined Function

Thread by: essamughal, Feb 2, 2005, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi ; I have a senario in which I have to create three views b/c few joining tables are changed on the basis of one parameter. Now, I am thinking to...

I need tips no reading Query Execution Plan?

Thread by: essamughal, Jan 26, 2005, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi ; I am struggling with my Queries Tuning and optimization but I can't read Query Execution Plan properly. So, I need some tips on how to read...

Compare Table Datatype and Derived Table?

Thread by: essamughal, Jan 26, 2005, 6 replies, in forum: T-SQL Performance Tuning for Developers

Hi; I have a query in which three tables datatype are being used in order to create three small table to join in a final query. I changed them into...