Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 9,720 total)

  • RE: Display Duplicates

    Chris Wooding (7/24/2014)

    Why are duplicate companies a problem? I would expect at least a few cases where you have more than one contact at a particular company.

    Or a situation where...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 29, 2014 at 5:06 am

    #1733140

  • RE: DB transaction log file on a shared hosting service

    matt6749 (7/23/2014)

    I think it's ok because the data is not mission critical and I back it up myself also with a console app I wrote. ?

    Matt,

    How is your console app...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 29, 2014 at 5:03 am

    #1733138

  • RE: DB transaction log file on a shared hosting service

    So far as I know, explicit transactions vs implicit transactions will not affect how the transaction log grows. Here are a few links to read up on.

    Transaction log basics

    Managing the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 29, 2014 at 5:00 am

    #1733137

  • RE: 1 Quick question for all the DBA's

    My advice is get to know what the business currently has set up (databases, data -- the why and wherefore of it, and business rules). Then see if you can...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 9:19 am

    #1731796

  • RE: Need help with basic spatial query

    Mark Harley (7/23/2014)

    Sorry, we're using a table variable and not a temp table. You can't add an index to a table variable, can you? We are pulling additional...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 8:01 am

    #1731763

  • RE: Non-Clustered, Composite Primary Key

    Not to provoke debate (but I'm gonna anyway @=), I generally use surrogate Identity columns as singular, non-composite PKs because if I used natural composite keys, I'd be including half...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 7:56 am

    #1731760

  • RE: Display Duplicates

    ChrisM@Work (7/23/2014)

    At a guess, you have 741 duplicated rows, 73 triplicated, and 1 quadruplicated.

    Give the man a cookie for doing the actual math work! 😀

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 7:50 am

    #1731757

  • RE: Need help with basic spatial query

    Mark Harley (7/23/2014)

    My event data actually comes from oracle and is stored in a temp table, which I believe means that we can't add an index to it. And...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 6:42 am

    #1731740

  • RE: Need help with basic spatial query

    BTW...

    mickyT (7/17/2014)

    This query will not perform the best in 2008 as it will not use spatial indexes, however in 2012 it should use them. You will need to make...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 6:20 am

    #1731730

  • RE: Need help with basic spatial query

    What do the indexes on your tables look like?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 6:19 am

    #1731729

  • RE: Non-Clustered, Composite Primary Key

    sqlvogel (7/23/2014)

    Brandie Tarvin (7/23/2014)

    There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 6:10 am

    #1731723

  • RE: Non-Clustered, Composite Primary Key

    Grant Fritchey (7/23/2014)

    Brandie Tarvin (7/23/2014)

    There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 5:40 am

    #1731712

  • RE: Display Duplicates

    Try this:

    SELECT c1.*

    FROM [CPACONTACTS].[dbo].[CPACONTACTS2] c1

    INNER JOIN (SELECT COMPANY

    FROM [CPACONTACTS].[dbo].[CPACONTACTS2]

    ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 5:38 am

    #1731710

  • RE: DB transaction log file on a shared hosting service

    Grant forgot to mention that you can't take transaction backups in Simple recovery mode. So verify your recovery mode first. If it's already in Simple (EDIT: given your original post...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 5:34 am

    #1731706

  • RE: Non-Clustered, Composite Primary Key

    There are people who will disagree with me on this, but I have found adding an IDENTITY (1,1) column to the table and adding that to the natural composite PK...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    July 23, 2014 at 5:31 am

    #1731705

Viewing 15 posts - 3,166 through 3,180 (of 9,720 total)