Forum Replies Created

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

  • RE: Many-to-Many Sanity Check

    TomThomson (9/28/2015)

    Calling something by different names in different places, as you have done here, leads to crazy things like holding the same thing twice with two column names in one...

    September 28, 2015 at 3:09 pm

    #1830016

  • RE: SQL Job Timeline (Graphical)

    Very Nice with some useful tweaks in the thread.

    Thanks

    September 17, 2015 at 5:33 am

    #1827363

  • RE: Legal/illegal characters in table name

    MyDoggieJessie (4/7/2015)

    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1

    Guessed correctly that that important piece was omitted...

    April 13, 2015 at 8:23 am

    #1790528

  • RE: Remove data from tables

    Hany Helmy (3/5/2015)

    Jostein Saethern (3/4/2015)

    The "delete table BBB;" statement in d) will fail.

    Its just a typo.

    I hate having to guess what was a typo and what is intentionally incorrect

    March 5, 2015 at 5:00 am

    #1781886

  • RE: Duplicates

    matthew.flower (2/4/2015)

    ... I would argue that none of the queries will help you because they only return the Editor Names, and deleting by LName alone will delete all the records...

    February 4, 2015 at 5:32 am

    #1775256

  • RE: Lists

    DrKiller (12/23/2014)

    wow what a complex way of doing it.

    I'm usually just doing this 🙂

    DECLARE @tmpString VARCHAR(MAX)

    SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header

    SELECT @tmpString

    +1 -- Very...

    December 23, 2014 at 5:36 am

    #1766170

  • RE: Trace Flags

    SQLRNNR (11/18/2014)

    Sadly the question posed can lead to confusion and a low correct answer rate due to the availability of four correct answers.

    The correct answers listed are only for trace...

    November 18, 2014 at 10:08 am

    #1759347

  • RE: BCP results

    Sean Pearce (7/28/2014)

    Your question is version specific. From SQL Server 2012 the file will be created.

    Thanks Sean for providing a much better explanation

    Using 2012, I had empty file

    +1

    July 28, 2014 at 5:16 am

    #1732762

  • RE: Restore

    HanShi (6/6/2014)

    I was in doubt, because I found it difficult to get the intention of the question (perhaps because I'm not native English speaking). Did I need to take the...

    June 6, 2014 at 6:51 am

    #1719639

  • RE: Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables

    As to explicitly dropping Temp Tables as soon as they are no longer needed goes, "It Depends". Dropping Temp Tables in a batch oriented stored procedure will probably be...

    May 23, 2014 at 5:51 am

    #1716022

  • RE: Getting the grid back

    happycat59 (5/15/2014)

    Yes, the documentation does say CTRL + Shift + D however, as far as I can tell, this does nothing when using SSMS 2012. CTRL + D does...

    May 16, 2014 at 5:51 am

    #1714148

  • RE: Upgrading cardinality

    Eirikur Eiriksson (5/14/2014)

    Good question, thanks!

    I got it wrong:ermm: or did I:w00t:

    Note, on Microsoft Support there is an article; Enable plan-affecting SQL Server query optimizer behavior that can be controlled by...

    May 15, 2014 at 5:30 am

    #1713796

  • RE: Find database where table is located

    By inserting into the table variable and querying it you effectively do that...

    One more change to only search user created tables (if you happen to search for a word in...

    May 6, 2014 at 4:56 am

    #1710999

  • RE: Find database where table is located

    Try something like

    sp_msforeachdb 'select "?" AS db, schema_name(schema_id) as [schema_name], name as table_name from [?].sys.tables where name like "%SOME_TABLE_NAME%"'

    Cheers

    May 5, 2014 at 12:27 pm

    #1710839

  • RE: Divide and Conquer - Performance Tuning

    A little off topic...However....

    How does one get SQLPrep or is it even available for public consumption?

    I do not see a link at http://www.csqls.com/

    Thanks

    April 8, 2014 at 8:49 am

    #1704163

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