Search Results | SQL Server Performance Forums

left join and is null sub query is too slow, plz help

Thread by: i.netdeveloper, Mar 15, 2013, 2 replies, in forum: Contribute Your Performance and Clustering Tips

i am trying got data from table a and table b in a sub query. I have to do a left outer join and in where clause I have to check if the column1 is...

@@version year

Thread by: i.netdeveloper, Jul 15, 2010, 2 replies, in forum: SQL Server 2008 General Developer Questions

Hi, I want to a script based on sql server version year, because some objects are not supported in 2000. We have two enviorments. something like if...

@@version year

Thread by: i.netdeveloper, Jul 15, 2010, 4 replies, in forum: General Developer Questions

Hi, I want to a script based on sql server version year, because some objects are not supported in 2000. We have two enviorments. something like if...

Get as Comma seperated values

Thread by: i.netdeveloper, Nov 5, 2009, 1 replies, in forum: SQL Server 2008 General Developer Questions

I have few tables from which I have to extract the data in such a way that it comes out as comma seperated values. For example I extracted the data...

join and in with select

Thread by: i.netdeveloper, Sep 10, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I am writing a query some thing like this select * from ems e inner join roles r on r.roleid in (select value from...

Compare last two rows in a query

Thread by: i.netdeveloper, May 14, 2009, 2 replies, in forum: SQL Server 2005 General Developer Questions

we have a log table where we are storing a program status in one of the columns and datetime stamp. A new row is appended when ever a change in the...

Left outer join on condition...

Thread by: i.netdeveloper, Aug 8, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have few tables which I am joining to get some data. I want to join a table only on certain condition. For example I have to get data if the...

Max value of multiple rows...

Thread by: i.netdeveloper, Jul 1, 2008, 5 replies, in forum: SQL Server 2005 General Developer Questions

I have two tables A and B while joining them its resulting multiple row set as follows... Answer MaxAnswer 3 1 3...

max of a group....

Thread by: i.netdeveloper, Jun 27, 2008, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I am writing a stored procedure where I want to select max of the value, let me explain select answer, allanswers from table abc join.... will...

Traversing thru the table

Thread by: i.netdeveloper, Jun 16, 2008, 4 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have a table which stores the data as follows ID Name ParentID value 1 Parent NULL I am the parent 2...

find value form comma seperated values column

Thread by: i.netdeveloper, Jun 3, 2008, 8 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have a table as follows Users UserName Role ABC 1,2,3 MNX 1,2 So, if i want to query weather the user ABC has...

Schedule a job...

Thread by: i.netdeveloper, May 20, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have a stored procedure which I want to execute it daily at 5.00 pm. I am using SQL Server 2005, I read that I can use Sql Server Agent and...

How to convert the entire column

Thread by: i.netdeveloper, May 19, 2008, 8 replies, in forum: SQL Server 2005 General Developer Questions

Hi I want to convert the entire column in a table from one format to other right now the date is stored as 'Dec 6 2007 12:00AM' I want to convert it...

use update in conjunction with where in

Thread by: i.netdeveloper, May 15, 2008, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I want to update a table with dates for all users... so here is the script that i have written...Update employessSET DateOfTraining =...

Open Query...

Thread by: i.netdeveloper, May 2, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

I have this stored procedure...set ANSI_NULLS ON set QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[Map_GetPointsFromLegacyDB](@SourceID int, @Zoom...

case statement with or

Thread by: i.netdeveloper, Apr 16, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have a table tblStatu with columns ID Name Status 1 Yellow Active 2 Red Active 3 Green Inactive 4 Blue REmoved Now i wrote...

Jobs...

Thread by: i.netdeveloper, Mar 27, 2007, 2 replies, in forum: General Developer Questions

Hi, I have a stored procedure in sql server 2000, which we want to run it everyday automatically at a particular time, basically schedule the job to...

Calling stored procedure from another stored proc

Thread by: i.netdeveloper, Mar 8, 2007, 6 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I want to know how to call a stored proc inside a stored proc. I am working with Sql Server 2005. Here is the situation i have a table accounts...

Indexes in a stored proc???

Thread by: i.netdeveloper, Feb 21, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions

1,How can we check existing indexes on the tables involved in a stored proc?<br />2,If there are none, then how can we create one?<br /><br...

Execution plan & optimize the performance

Thread by: i.netdeveloper, Feb 21, 2007, 5 replies, in forum: SQL Server 2005 General Developer Questions

I want to know how look at the execution plan of a stored procedure and see if there is anything I can do to optimize the performance in SQL Server...