Search Results | SQL Server Performance Forums

issue with Ordering rows in a table while retrieving data

Post by: arijitnist, Jan 18, 2013 in forum: ALL SQL SERVER QUESTIONS

HI Shehap, Thank you for your response This is not giving me desired result . Please check the output below from your query . Also I am using SQL...

issue with Ordering rows in a table while retrieving data

Post by: arijitnist, Jan 18, 2013 in forum: ALL SQL SERVER QUESTIONS

Hi Frank, NO this won't give me the desired result as I want the data ordered by Time and also 1 record with EventType 2 should be followed by a...

issue with Ordering rows in a table while retrieving data

Thread by: arijitnist, Jan 17, 2013, 5 replies, in forum: ALL SQL SERVER QUESTIONS

Hi, I have a table A which has 4 columns UserID int, Time varchar(20), EventType int. Sample data given below UserID Time EventType 1234...

Transaction Replication issue

Post by: arijitnist, May 22, 2009 in forum: SQL Server 2005 General DBA Questions

Thanks Satya for the prompt reply, there was problem with the generation of snapshots , which i manged to fix. I have a question for you , we are...

Transaction Replication issue

Thread by: arijitnist, May 21, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I have set up transaction replication on my production server . I have a remote distributer . The problem i am facing is some of the...

Import a flat file to sql server 2005

Thread by: arijitnist, May 17, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I have to create a SSIS package to import a flat file to a sql server 2005 db. But the problem is the content of the flat file is a...

SQL Server to Oracle Migraion

Post by: arijitnist, May 17, 2009 in forum: SQL Server 2005 General DBA Questions

Thnaks a lot Mohammed , I am using this tool now

SQL Server to Oracle Migraion

Thread by: arijitnist, May 12, 2009, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, We have to migrate our sql server database to oracle . Please give some suggestion as to how we should proceed. We have a set of...

SQL Server Migration

Thread by: arijitnist, Apr 16, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I want to migrate from TSX operating sytem to sql server . Please provide me some reference material for this , how do I start. Thanks,...

RAM Upgrade for SQL SERVER 2005

Thread by: arijitnist, Jan 5, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, We have upgraded the RAM for one of our 32 bit Windows 2003 Ent SP2 servers from 6 GB to 16 GB.We have two nodes in cluster , we are just...

SP timing out

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

Hi All, I have a stored procedure which seems to timeout for a particular parameter value , but works fine for a paramteer which returns a large...

SP problem

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

Hi All, I have a stored procedure to generate a real time report.The report is very complicated and the sp contains several queries in union all...

Job for DTS package in SQL Server 2005

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

Hi All, I want to create a job in SQL Server 2005 to execute a particular DTS Package created in sql server 2000. Please help in this regard. Thanks,...

schema comparison in sql server 2005

Thread by: arijitnist, Jun 24, 2008, 5 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, Is there any free tool for schema comparison of two databases in a server. Thanks, Arijit

Data Comparison

Thread by: arijitnist, Jun 20, 2008, 2 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, We have two sql databases present at two different locations with the same db objects. There will be a set of inserts made to the dbs...

sp_executesql Vs Exec

Thread by: arijitnist, May 15, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I am using dynamic sql inside a stored procedure and executing the TSQL using Exec (@query) . My question is will there be any major...

Spacing issues

Thread by: arijitnist, May 7, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, I am having spacing issues when i export a mhtml report in sql server reporting services 2005(SP 2) to a pdf file. There are wide spaces in...

Reporting Services spacing issues

Thread by: arijitnist, Mar 31, 2008, 1 replies, in forum: SQL Server 2005 Reporting Services

Hi All, We are having lot of spacing issues in the pdf doc when we are exporting the mhtml report as a pdf document . We have applied the latest...

Memory Leak in sql server 2005

Thread by: arijitnist, Mar 28, 2008, 8 replies, in forum: SQL Server 2005 General DBA Questions

Hi All, We are having performance problems with one of the servers on which sql server enterprise edition is installed. This is a windows 2003...

Database Size

Post by: arijitnist, Mar 28, 2008 in forum: SQL Server 2005 General DBA Questions

no we didn't restore the db , we just upgraded the server from sql express to sql standard 2005 by installing standard.