Search Results | SQL Server Performance Forums

Help with returning string value from SP

Thread by: picses, Nov 10, 2004, 8 replies, in forum: General Developer Questions

Hello, I have the following SP which takes in a date input parameter and exports a string which is made up of a returndate, Action, Total and...

Double installation?

Thread by: picses, Oct 12, 2004, 2 replies, in forum: General DBA Questions

Hi Group, During installation of SQL 2000, one of the options was to use an existing server or create a new Server. I chose new Server (with the...

DTS Error - What does this mean?

Thread by: picses, Aug 25, 2004, 7 replies, in forum: SQL Server DTS-Related Questions

Hi Group,I get the following error when I run my DTS Package. The number of failing rows exceeds the maximum specified. TransformCopy...

Append Excel data to existing table

Thread by: picses, Aug 23, 2004, 14 replies, in forum: SQL Server DTS-Related Questions

Hi Group, I have an existing Excel spreadsheet and I need to APPEND this information to a table in SQL. I would like to do some formatting around...

SQL Server does not exist access denied error

Thread by: picses, Aug 6, 2004, 1 replies, in forum: General DBA Questions

Hi Group, I've just installed SQL 2000 on top of a SQL 7.0 installation(beta)!!. I got the SQL Server does not exist access denied error so I...

Porting to version 2000

Thread by: picses, Aug 5, 2004, 7 replies, in forum: General DBA Questions

Hi Group, I've installed SQL 2000 on my machine, however the existing SQL is version 7.0. I can connect to the version 7 database. My questions...

Like does not work with *

Thread by: picses, May 12, 2004, 3 replies, in forum: General DBA Questions

Hi Group, I have a field (definition varchar length 4 chars). I have the following sample data in this field D6, d3, d5. Note the UPPERCASE D for the...

Could a patch to the Server create this?

Thread by: picses, May 7, 2004, 9 replies, in forum: T-SQL Performance Tuning for Developers

Hi Group, I am trying to get to the bottom of this.... I have several SP's which have been running for a number of years then 'suddenly', I get the...

Error Invalid Column Name in SP

Thread by: picses, Apr 23, 2004, 2 replies, in forum: General Developer Questions

Hi Group, I have an SP where the value of one of the incoming fields used to be of int type but because that field can now contain alphanumeric...

Multiple step OLE DB Operation error

Thread by: picses, Apr 10, 2004, 1 replies, in forum: General Developer Questions

Hi group, I get the following error, when I am returning records in my ASP application. Microsoft OLE DB Provider for SQL Server: Multiple-step OLE...

Summing Values across different databases

Thread by: picses, Apr 8, 2004, 4 replies, in forum: T-SQL Performance Tuning for Developers

Hi Group, I need to be able to sum the values of 2 different fields which are in 2 different databases on the SAME Server. My original query summed...

Summing Vaules across 2 databases

Thread by: picses, Apr 8, 2004, 1 replies, in forum: General DBA Questions

Hi Group, I need to be able to sum the values of 2 different fields which are in 2 different databases on the SAME Server. My original query summed...

SHOWCONTIG Results looks OK BUT..

Thread by: picses, Apr 2, 2004, 8 replies, in forum: T-SQL Performance Tuning for Developers

I have an ASP application with a SQL Server back-end. When the users' query returns a large amount of data - say 3000 plus - I get a timeout error....

Copy Database - different locations

Thread by: picses, Apr 2, 2004, 10 replies, in forum: General Developer Questions

Hi Group, I need to copy a SQL 7.0 database to another computer (for testing purposes). The computers cannot 'see' each other. The size of the .MDF...

Resoure Hungry Database

Thread by: picses, Apr 1, 2004, 10 replies, in forum: T-SQL Performance Tuning for Developers

Hi Group, I ran a query via my ASP page first thing in the morning and it worked. A couple of hours later, I ran the SAME query and I got a timeout...

Redindex automatic

Thread by: picses, Apr 1, 2004, 3 replies, in forum: T-SQL Performance Tuning for Developers

Hi Group, I've applied indexes to fields in my table. Are these indexes applied automatically or do I have to run another process? Also if ALL the...

Query Optimize - timeout issue

Thread by: picses, Apr 1, 2004, 6 replies, in forum: T-SQL Performance Tuning for Developers

Hi Group,<br />I have the following query which takes 3 seconds to run in the Query Analyser. It returns 437 records. However, when running this...