Forum Replies Created

Viewing 15 posts - 46 through 60 (of 248 total)

  • RE: SQL Server and UNIX

    Thanks Lowell,

    Can you shed some more light on accessing SQL Server DB Engine from an UNIX platform.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    June 14, 2010 at 11:39 pm

    #1180197

  • RE: Changing Recovery Model from FULL to SIMPLE

    Change it to the SIMPLE recovery Model.

    Also, you might want to check for the active trancation before you do anything. run this to check the active transaction:

    DBCC OPENTRAN

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    June 10, 2010 at 6:33 am

    #1178559

  • RE: Error-40 could not open a SQL server

    jai verma (6/9/2010)

    Hi, we recently migrate our SQL2005 server on a upgraded server,after installtion we chnaged the ip of server.

    we publish a application on citrix layer based on this dbserver

    but...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    June 10, 2010 at 4:02 am

    #1178520

  • RE: SSIS Import from Excel source

    Gopi Muluka (6/9/2010)

    Try using IIF construct, Please remember you have to Microsoft Jet Database syntax while querying excel

    SELECT CVV_CODE, CVV_OMSCHR

    ,IIF((STARTD_CVV='-'),NULL,STARTD_CVV) AS S

    FROM [sheet1$]

    Did...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    June 10, 2010 at 3:55 am

    #1178517

  • RE: SSIS Import from Excel source

    da-zero (6/9/2010)

    You can write a SQL query to read from the Excel source, but it doesn't support all the language syntax.

    So, I would just read the contents of the file...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    June 9, 2010 at 1:43 am

    #1177828

  • RE: want a way..

    Below query is giving me desired output, but can we merge both these query to have just one single query:

    SELECT cdi.xidxrecid,CFA.ORGID,

    ...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    June 1, 2010 at 11:45 pm

    #1175105

  • RE: want a way..

    sorry I mean I am not getting the desired output.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    May 27, 2010 at 7:14 am

    #1173298

  • RE: want a way..

    Lowell (5/27/2010)

    V in your first query of the UNION ALL you have this as part of the WHERE arguments:

    CFA.ORGID IN ('*','SERVICE','4C0C6A2U7P','4X9A8F2U5A')

    but in the second part of the union...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    May 27, 2010 at 7:08 am

    #1173294

  • RE: Most Efficient Approach

    Finally I was able to import the file. Though I had to change that file manually but now its over. Thanks.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    May 25, 2010 at 11:59 pm

    #1172477

  • RE: Most Efficient Approach

    yup did it after changing to Raw data and then directly importing it through import/export wizard. so far running so good.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    May 25, 2010 at 7:45 am

    #1172076

  • RE: Most Efficient Approach

    Lowell (5/25/2010)

    ugg; one-time imports are sometimes the most time consuming...can we see a row or two of sample data? enough to make a format file so you could test a...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    May 25, 2010 at 7:11 am

    #1172035

  • RE: Most Efficient Approach

    Lowell (5/25/2010)

    Vishal in my experience, a text filefilled with INSERT INTO....commands is much much slower than using BULK INSERT or bcp to bring in a text doucment filled with raw...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    May 25, 2010 at 6:54 am

    #1172027

  • RE: Merging Resultsets

    Chris Morris-439714 (5/24/2010)

    DROP table #t1

    DROP table #t2

    create table #t1 (catid int, orgid varchar(10))

    create table #t2 (catid int)

    insert into #t1 values (1,'PETER')

    insert into #t1 values (2,'a01')

    insert into #t1 values (3,'*')

    insert into...

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    May 24, 2010 at 11:04 pm

    #1171844

  • RE: Preventing usage of "SELECT *..."

    Indeed a good article but practically difficult to use.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    November 5, 2009 at 4:25 am

    #1075241

  • RE: Can Somebody Suggest?

    I raised it in connect. Lets see if they support it there.

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

    October 12, 2009 at 4:22 am

    #1064643

Viewing 15 posts - 46 through 60 (of 248 total)