Forum Replies Created

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

  • RE: Best way to store photos

    I would recommend the file system and store the path in the SQL Server. Ultimate flexibility and easiest to code.

    December 4, 2012 at 7:58 am

    #1565339

  • RE: Tip: Resetting Identity Fields

    Brandon Forest (12/3/2012)

    @ those who question why to do this. It's very simple, if you don't see the need to do it, don't do it. Questioning why...

    December 4, 2012 at 7:46 am

    #1565333

  • RE: Tip: Resetting Identity Fields

    Sigh... ID's like this should NOT be intelligent, by their very nature they should tell NOTHING of the data. It serves to uniquely identify a row. Thats...

    December 3, 2012 at 9:01 am

    #1564935

  • RE: Performance issue

    ranganathleo (11/29/2012)

    We have got a critical case where their is a performance degrade for many users on an application. Have been asked to check which tables are been utilized to...

    November 29, 2012 at 7:30 am

    #1563771

  • RE: LIKE with and without wildcards in WHERE clause

    But wouldn't this always compare all variables, though? In the syntax with OR, the query engine can see that a variable is empty, thereby satisfying one side of the OR...

    November 26, 2012 at 5:57 am

    #1562178

  • RE: rebuild index worsens query performance

    Does this run from a stored proc with parameters? Is parameter sniffing a problem here? Perhaps add an OPTION(OPTIMIZE FOR if params are used and see what shakes...

    November 20, 2012 at 1:26 pm

    #1561002

  • RE: Using Full-Text Search

    SpringTownDBA (11/20/2012)

    DiverKas (11/20/2012)

    SpringTownDBA (11/19/2012)

    Full text querying only does prefix matching, not postfix

    'erin*' matches 'erinblah'

    '*erin' doesn't match 'blaherin'

    There is no way to match the last half of a word.

    Actually, the way...

    November 20, 2012 at 10:05 am

    #1560906

  • RE: Using Full-Text Search

    SpringTownDBA (11/19/2012)

    Full text querying only does prefix matching, not postfix

    'erin*' matches 'erinblah'

    '*erin' doesn't match 'blaherin'

    There is no way to match the last half of a word.

    Actually, the way around this...

    November 20, 2012 at 9:38 am

    #1560889

  • RE: From YYYY-MM-DD HH:MM:SS format to MM/DD/YYYY?

    SQL server rokee (11/20/2012)

    Hello fellow developers I have the following code which translates MY_COLUMN from decimal to varchar ,then from varchar to Datetime.

    The only glitch is that the output...

    November 20, 2012 at 9:28 am

    #1560883

  • RE: Can't Grant Delete

    Bob McClellan-320407 (11/19/2012)

    Thanks B.

    The user would be myself. I created the Job.

    The job fires a stored proc that has other SP's..

    one of the SPs does the purgepop.

    If I execute...

    November 19, 2012 at 10:52 am

    #1560463

  • RE: Query Optimization

    Jeff Moden (11/16/2012)

    DiverKas (11/15/2012)

    I am curious though Jeff, what is this storing of the datatype magic you speak of? :w00t:

    What's the one datatype that most people have never used...

    November 19, 2012 at 10:46 am

    #1560457

  • RE: Query Optimization

    Jeff Moden (11/15/2012)

    aaron.reese (11/15/2012)

    And that us why MI Developers hate 'lazy' programmers that use EAV tables.

    By lazy, i really mean misguided or uneducated. Entity Attribute Variables make ut easy to...

    November 15, 2012 at 11:44 am

    #1559469

  • RE: Multiple Instances vs. Multiple DBs on one instance

    dan-572483 (11/7/2012)

    If you have two beefy 64-bit servers in 2-node cluster, and several applications that need a database server, is it generally better to install multiple instances, or deploy databases...

    November 7, 2012 at 10:54 am

    #1556871

  • RE: how to insert image in sql server 2005

    sanjay.dakolia (11/5/2012)

    hi,

    i want to insert image into sql server using sql query. please help.

    thanks in advance

    sanjay

    It is generally considered bad practice to store images in the...

    November 5, 2012 at 8:30 am

    #1556082

  • RE: Query performance change

    Lee Crain (10/25/2012)

    This observation may or may not be helpful.

    I couldn't help but notice your WHERE clause:

    "WHERE

    a.P_STATUS <> 'R'

    and b.TICKET_NUM is not null

    and b.TXN_DT is not null"

    All NOT comparisons...

    October 26, 2012 at 1:13 pm

    #1553362

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