Forum Replies Created

Viewing 15 posts - 3,346 through 3,360 (of 6,035 total)

  • RE: 1 Table has been refreshed since the 29th of October.

    Ed Wagner (10/6/2015)


    Eric M Russell (10/6/2015)


    Welsh Corgi (10/6/2015)


    ok, it was September 29th.

    I have been working around the clock for two weeks 7 days week.

    Sorry about that.

    It sounds like you...

  • RE: 1 Table has been refreshed since the 29th of October.

    Welsh Corgi (10/6/2015)


    ok, it was September 29th.

    I have been working around the clock for two weeks 7 days week.

    Sorry about that.

    It sounds like you need to take yourself offline...

  • RE: DB development standards question

    Yes, I believe it's a good idea to explicitly name primary and foreign keys. Not only does it provide clarity in error messages, it also makes writing deployment scripts more...

  • RE: Shorten Audits, Tighten Security with Minion Enterprise

    When attempting to click on the url for MinionWare, does anyone else get it blocked by their firewall or anti-virus?

    http://www.minionware.com

    Symantec Endpoint Protection

    Web Attack: Malicious Website Script

    Redirect 16 detected

  • RE: Querying Yesterday

    Given a case-use where the requirement is auditing, we can use triggers to capture only specific DML operations (ex: only updates and deletes but not initial inserts), and we can...

  • RE: Can you add an index to a view

    Can you add an index to a view?

    Yes. Indexed views are useful for materializing aggregate queries and / or joins. But it can negatively impact table insert and update performance....

  • RE: Blocking query with nolock in it

    Markus (10/6/2015)


    That just might be it.... when I look at her SPID SQL it shows the select... hum....

    That would explain why I see her as a blocking thread to another...

  • RE: Blocking query with nolock in it

    Does DBCC OPENTRAN show any open transactions belonging to that user?

  • RE: Querying Yesterday

    This sounds similar in concept to Oracle's Flashback related features, which leverages the transaction log and are primarily intended for point-in-time recovery, but it allows for Flashback queries as well...

  • RE: 1 Table has been refreshed since the 29th of October.

    Welsh Corgi (10/5/2015)


    I have 1 Table has been refreshed since the 29th of October.

    ...

    Thanks.

    OK, we now know you're talking about replication. However, I'd like to point out that today is...

  • RE: Parsing unstructured CSV file

    N_Muller (10/1/2015)


    I have a CSV file with roughly 6 million rows. The file is unstructured; that is, some rows have 5 fields, others have 15, and there are as many...

  • RE: 1 Table has been refreshed since the 29th of October.

    Welsh Corgi (10/5/2015)


    I have 1 Table has been refreshed since the 29th of October.

    I checked other tables and they are being refreshed.

    How can I identify and correct the problem?

    Thanks.

    So, what...

  • RE: SQL Server DBA salary surveys way too low?

    What is the source for the surveys, and what experience level are job postings looking for when they offer $120k? I would expect the average salary offered by prospecting employers...

  • RE: Spam Spam Bacon and Spam

    Some of these spam posts are so poorly translated, it's not obvious if they're actually trying sell or promote something, if it's randomly generated gibberish, or if the poster is...

  • RE: What's a Code Smell?

    I guess "code smells" and "technical debt" are somewhat related.

Viewing 15 posts - 3,346 through 3,360 (of 6,035 total)