Search Results | SQL Server Performance Forums

Help with insert into select

Thread by: dneupane, Mar 1, 2007, 1 replies, in forum: General DBA Questions

Hi all With the below SP I want to output "@tfunction_call_log_id" when executing the line "SELECT ISNULL(MAX(function_call_log_id) + 1,...

Insert fail

Thread by: dneupane, Apr 3, 2005, 3 replies, in forum: General DBA Questions

Hi there I use the following stored procedure to increment a call ID. Here is my problem, the calling application is throwing an exception with the...

Backup Size

Thread by: dneupane, Dec 22, 2004, 3 replies, in forum: General DBA Questions

Hi There Below are my scripts for full backup and differential backup. Full backup runs once a week and usually it is around 5 GB. Differential...

Return Value

Thread by: dneupane, Sep 19, 2004, 4 replies, in forum: General DBA Questions

Hi, I have an application that used to run on SQL 7.0. I upgraded my development SQL server to 2000 but my applications started treating...

Recompile stored procedures

Thread by: dneupane, Sep 15, 2004, 9 replies, in forum: General DBA Questions

Hi I need to re-compile several stored procedures in a database. Is it possible to re-compile all at once. If so how do I do it? Thank you in...

Deleting rows

Thread by: dneupane, May 6, 2004, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi all I need to delete 23million rows from a live database. I cannot use truncate table command because the table has a FOREIGN KEY constraint....

Drop table

Thread by: dneupane, Mar 29, 2004, 1 replies, in forum: General DBA Questions

Hi there, I need to drop a table on the production server. The table has 15,000,000 records. Will it impact on the performance of the database while...

Cluster Image

Thread by: dneupane, Nov 26, 2003, 5 replies, in forum: SQL Server Clustering

I am very new to SQL cluster. I am upgrading SQL 7.0 Cluster ruining on win2k Adv server. Is it possible to Ghost the image of the cluster nodes and...