Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 8,416 total)

  • RE: Simple query....Worst plan

    Bhuvnesh (4/30/2010)

    HI i need better approach for the below one.i know this is very straight forward query but if somebody can help me here . greatly appreciated.

    1. When deleting a...

    May 3, 2010 at 2:51 am

    #1161144

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (5/3/2010)

    I think Paul wants to join the "world's worst procedure" competition... :-P.

    I would have put some more BREAK / CONTINUE in it and maybe nested another cursor,...

    May 3, 2010 at 2:11 am

    #1161138

  • RE: how to improve qurey perpormace

    pradeepmsbi (5/2/2010)

    how to improve the query performance in sql server 2005

    Configure the server correctly, improve the hardware, tune the queries, and refine the database design.

    May 3, 2010 at 2:06 am

    #1161136

  • RE: Index on Date Time Column Not Getting Used

    uppal.kunal (5/3/2010)

    Thanks Jeff for detailed description to how to make it work but frankly I am looking for "Why Index didn't work here?" rather than "how to make it work?"

    Frankly,...

    May 3, 2010 at 2:03 am

    #1161135

  • RE: Why rebuild statistics on large, older tables?

    kwiggans (4/30/2010)

    This question may be purely academic...

    No, you raise a number of important points. Rather than try to summarise an entire White Paper here, forgive me for just providing...

    May 3, 2010 at 1:44 am

    #1161126

  • RE: My first Query

    Sorry for the duplication - I didn't see the reply from sharath.chalamgari because I had the reply window open for a while before submitting it :pinch:

    May 3, 2010 at 1:34 am

    #1161125

  • RE: Table function - list of parameters

    sharath.chalamgari (5/3/2010)

    Can we pass all the columns to the procedure as a table parameter

    Only in SQL Server 2008.

    or as XML?

    Yes.

    which one will be better for performance - string, XML or...

    May 3, 2010 at 1:32 am

    #1161124

  • RE: My first Query

    mukherjee.subhro (5/3/2010)

    My question is what stands for 'U' here , and what if I don't want to mention the 'U' here?

    I haven't experimented that really.

    IF OBJECT_ID(N'dbo.Nums', N'U') IS NOT...

    May 3, 2010 at 1:23 am

    #1161119

  • RE: Column type conflict in Unpivot list

    sharonrao123 (5/2/2010)

    Thanks for your reply, But I keep getting the same error message is there any other reason you can think of why its happening.

    The (nicely correctly by Dohsan) posted...

    May 3, 2010 at 12:39 am

    #1161096

  • RE: Dynamic Cursor Within a Cursor

    Compare your code to this simple example:

    SET NOCOUNT ON;

    CREATE TABLE

    #Example

    ...

    May 3, 2010 at 12:27 am

    #1161094

  • RE: Join if Exists

    nguyennd (5/2/2010)

    Yes, I think so.

    You think so...what? I didn't ask a question.

    I rewrite your query:

    WHEN EXISTS (SELECT * FROM B JOIN A ON A.CusNo_A = B.CustNo_B WHERE B.Second_CustNo...

    May 2, 2010 at 11:23 pm

    #1161087

  • RE: Data display issue

    DECLARE @test-2

    TABLE (

    Country VARCHAR(50),

    City VARCHAR(50)

    ...

    May 2, 2010 at 11:01 pm

    #1161083

  • RE: Query Performance with multiple joins

    csillag.yitzik (4/29/2010)

    I have a query with multiple inner joins and left joins (about 40). When I run the query it takes about 20 seconds to return 3000 records.

    Can you give...

    May 2, 2010 at 10:47 pm

    #1161079

  • RE: Function call on Insert Query

    a.black (4/30/2010)

    The function GetNextID() creates a unique id based on the last id stored in the 'destination_table' table. However when calling the insert for multiple rows the query fails due...

    May 2, 2010 at 10:41 pm

    #1161078

  • RE: Join if Exists

    nguyennd (5/2/2010)

    @paul-2 White NZ : Thanks you for help.

    But about require of business:

    WHEN EXISTS (SELECT * FROM B WHERE B.Second_CustNo = C.CustNo_C) THEN 1

    If not extist (A.CustNo_A = B.CustNo_B) is...

    May 2, 2010 at 10:24 pm

    #1161075

Viewing 15 posts - 3,556 through 3,570 (of 8,416 total)