Forum Replies Created

Viewing 15 posts - 571 through 585 (of 761 total)

  • RE: Unable to connect to SQL Server 2008 r2 named instance

    No Problem. I haven't personally had these problems yet. Just wanted to know. 🙂

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 10:56 pm

    #1480789

  • RE: Replacement for Cursors

    Jeff Moden (4/27/2012)

    vinu512 (4/26/2012)

    But the requirement is that I do not need the Names as a "Set". I need them separately(one by one), so that I can use them further.

    By...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 6:42 am

    #1480351

  • RE: Which is give best perf

    Gail is right....Scan count != number of time a table is scanned.

    As per Books Online, Scan Count is: Number of index or table scans performed.

    Scan count is 0 if...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 6:26 am

    #1480342

  • RE: Which is give best perf

    GilaMonster (4/27/2012)

    vinu512 (4/27/2012)

    ESAT ERKEC (4/27/2012)

    Which query performance is better perf1 or perf2 ?

    perf1: Scan count 0, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 6:20 am

    #1480340

  • RE: Which is give best perf

    Sorry...didnt see your second post carefully.

    In your first post you wrote:

    perf1: Scan count 0, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 6:19 am

    #1480338

  • RE: Which is give best perf

    Is the result set returned by both the queries the same???...There must be conditions in the Where Clause....are they same in both the queries???

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 6:14 am

    #1480336

  • RE: Which is give best perf

    ESAT ERKEC (4/27/2012)

    Which query performance is better perf1 or perf2 ?

    perf1: Scan count 0, logical reads 23, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 5:39 am

    #1480309

  • RE: in built function quer

    You sure are welcome....:-)

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 5:34 am

    #1480307

  • RE: SQL Server 2008 R2 Download Issue

    Yes, Sql Server Express Edition comes without the tools...thats why I was asking which Edition.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 5:31 am

    #1480306

  • RE: in built function quer

    +1

    The Error is:

    'average' is not a recognized built-in function name.

    But I can't see 'average' anywhere in your query.

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 5:21 am

    #1480297

  • RE: can i use replication ? what is your idea?

    1.

    Suppose you have an application which connects to database DB1 on Server S1.

    Now, your application needs some data occasionally (no huge number of transactions) from another database DB2 that is...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 5:16 am

    #1480294

  • RE: querying xml

    This will help you :

    Loading XML Data into SQL Server (SQL Spackle)[/url]

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 3:40 am

    #1480253

  • RE: DTS--issue

    The package cannot be loaded from a 64-bit SQL Server.

    This is a mismatch between the SQL Server and the Integration Services Module.

    I think that your SQL Server is 64bit but...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 3:35 am

    #1480252

  • RE: How to handle name with 's

    +1 imex

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 12:44 am

    #1480209

  • RE: Stuff 0's between 2 int values

    imex (4/27/2012)

    Hi,

    I do not know if I understand correctly but try this:

    Set @c = @a * 1000 + @b;

    Hope this helps.

    Yes. If you want "@c" to be calculated then you...

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉

    April 27, 2012 at 12:39 am

    #1480207

Viewing 15 posts - 571 through 585 (of 761 total)