Search Results | SQL Server Performance Forums

Handling KB Articles (Doc or PDF) with SQL Server 2005

Thread by: sqlderby, Sep 14, 2012, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi All I need to search relevant product KB articles and articles could be in word doc, PDF or HTML format with images. I want to know best way to...

Performance Tuning - SP

Thread by: sqlderby, Jul 16, 2012, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs

Hi All I need help on following SP code to tune up mainly where "CREATE TABLE #TblRawQueue" creating and DROPING in side While loop. DECLARE @rFlag...

Insert Data in Linked Server Table Using Insert Trigger and Instaed of Trigger

Thread by: sqlderby, Oct 18, 2011, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi All We have situation where we need to insert data into Linked Server Table using For Insert Trigger on source table. On the same time we have...

Select 20 records Only

Thread by: sqlderby, Oct 11, 2011, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I am trying to select only 20 records of each agent from a table. There could be any number of records for each agent in the table. These...

T-SQL - Calculate Login Duration

Thread by: sqlderby, Jan 29, 2011, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I need to calculate lgin hours of agents. The login and logout state code insert into table with date and time and agent info. I have tried...

Date Calculation Issue

Thread by: sqlderby, Dec 4, 2010, 8 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I am calculating date range using getdate () for current date and time. And that is from 10:00 pm previous day to 10:00 pm of current day and...

Help need for Link Server Query

Thread by: sqlderby, Sep 18, 2010, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I need help with following query as giving error "Incorrect syntax near '2010'." INSERT INTO DEL_SALE SELECT * FROM OPENQUERY(AV41,'SELECT...

T-SQL Tuning Issue

Thread by: sqlderby, Sep 2, 2010, 3 replies, in forum: SQL Server 2005 General Developer Questions

I have following T-SQL that I have been tuned up and come up with 20 seconds from 2 minutes. Made couple of indexes and change joins and columns...

Delete Data of all Tables with No. of Records left in Tables

Thread by: sqlderby, Aug 2, 2010, 6 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I have situation where only 10 records need to left in the production database for testing purpose. Data of 10 records should be relevant as...

T-SQL - Need Help

Thread by: sqlderby, Jul 10, 2010, 8 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I have following data and require result set but facing problem...as my query showing 28 rows... Table 1: DT FirstName LastName...

Case Statement in DateAdd and Where Clause

Thread by: sqlderby, Jul 7, 2010, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi All I need to add case condition in DateAdd and where clause as follows... Pls help me in this... Current One... Select...

Update Column Value with Function - How?

Thread by: sqlderby, Apr 7, 2010, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi All In a table we need to update data value in a column. To encrypt the data of this column. We have a function that encrypt the data. SELECT...

Max Date of Max QTime

Thread by: sqlderby, Apr 2, 2010, 13 replies, in forum: SQL Server 2005 General Developer Questions

Hi I need to know can I find the time of maximum queue time from a table data. This data group by half hour time period. HalfHourDateTime...