Forum Replies Created

Viewing 15 posts - 16 through 30 (of 140 total)

  • RE: view with 125 columns

    Hi Lowell,

    Indexing probably not solve our problem as all the fields are well indexed. What initially I have thought is:

    Splitting the view with 4-5 views, containing 40 columns each and...

    May 11, 2011 at 1:08 am

    #1322772

  • RE: Query is not working in VB.net

    Hi, This is solved (not sure how).

    I am now using 32 bit odbc on 64 bit OS. It is working fine.

    Thanks a ton to all.

    March 22, 2011 at 6:49 am

    #1301838

  • RE: Query is not working in VB.net

    Hi,

    I am eagerly waiting for the solution. Please help.

    Alternately, can you provide a query/method through which I can get the view definitons? That will also work for me.

    Regards,

    Arup

    March 21, 2011 at 11:58 pm

    #1301687

  • RE: Query is not working in VB.net

    Lowell (3/16/2011)

    well lets start with the basics; are you sure you are connecting at all? can you select @@version from vb?

    could you be connecting to MASTER, adn thinking you'll see...

    March 17, 2011 at 10:43 am

    #1300067

  • RE: Change user by variable

    Hi John,

    Thanks for your reply. Yes, we have a special reason for this. And for product requirement, we cant use all views under sa.

    🙂 The scenario I have mentioned, I...

    March 1, 2011 at 10:33 pm

    #1293327

  • RE: True or False

    igsri (11/26/2010)

    Good Question !!..

    We can see the Execution Plan of Encrypted Procedure.

    I have tested it..

    Hi,

    Could u tell us how?

    November 27, 2010 at 3:11 am

    #1255951

  • RE: Where clause with nested loop join

    HI All, Got it.

    It should be

    select * from A inner join B on

    (A.col1= B.col1)

    where a.col2=0 OPTION (LOOP JOIN)

    Thanks.

    Now...

    September 1, 2010 at 4:48 am

    #1214849

  • RE: Insertion slow

    Bhuvnesh (4/20/2010)

    Gianluca Sartori (4/20/2010)

    (2) Too many indexes

    HOw indexes put sudden effect on indexes. i am confused with it

    I beleave while you are inserting some rows to the table, the...

    April 20, 2010 at 4:38 am

    #1154446

  • RE: Insertion slow

    Gianluca Sartori (4/20/2010)

    Some things that come to my mind:

    1) Badly coded triggers

    2) Too many indexes

    3) ... any possible reason. The question is too generic to give a good answer.

    Hi, thnx...

    April 20, 2010 at 3:54 am

    #1154428

  • RE: Multi-statement execution

    Tricky question, but not good for learning...good for dry run

    February 3, 2010 at 2:29 am

    #1112712

  • RE: Introduction to Indexes

    Thanks Gail..really useful one...

    October 28, 2009 at 3:01 am

    #1071592

  • RE: Query Performance Issue

    Hi Slick84,

    can u replace the IN with some inner join? I hope this will give a better performance.

    October 16, 2009 at 1:20 am

    #1066711

  • RE: replicate

    munirdahya (10/8/2009)

    Cut and paste the code in QA and you get:

    Server: Msg 170, Level 15, State 1, Line 1

    Line 1: Incorrect syntax near 'max'.

    Server: Msg 170, Level 15, State 1,...

    October 15, 2009 at 4:32 am

    #1066163

  • RE: date format

    Thanks Fausto

    September 23, 2009 at 11:23 pm

    #1057867

  • RE: date format

    Lynn Pettis (9/23/2009)

    This is another way and doesn't use the convert statement:

    dateadd(dd, datediff(dd, 0, getdate()), 0)

    Thanks Lynn,

    Got it.

    September 23, 2009 at 11:22 pm

    #1057866

Viewing 15 posts - 16 through 30 (of 140 total)