Forum Replies Created

Viewing 15 posts - 3,361 through 3,375 (of 6,041 total)

  • 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.

  • RE: How to hide stored procedures from user?

    Ideally, each application or user account should be a member of a role, and the only additional permissions for each role should be execution on only the procedures that role...

  • RE: Left join vs Exists

    It seems to me that, if InformationOverride is meant for exclusion, then you're missing a "WHERE vcf.MeetID IS NULL" clause, or if InformationOverride is meant for inclusion, then it should...

  • RE: Spam Spam Bacon and Spam

    Perhaps we could have a spam reporting policy that works something like this:

    If a trusted user (meaning perhaps a user with a certain level of points of higher) reports...

  • RE: What Can You Do?

    From what I've seen, few data breaches are the result of exploiting holes in the database engine itself. The major RDMS are solid in terms of security; and SQL Server...

  • RE: Configuring sql alert for low memory

    Like Gail said, SQL Server rarely throws "out of memory" type exception. If low on memory, it will typically spool to tempdb, or if there are simlultaneous requests, will start...

  • RE: Commercial Software with All Tables as Heaps and Terrible Performance

    898 million page reads? Each page is 8'000 bytes... :w00t:

  • RE: The Work of the Ancients

    A database originally designed with a de-normalized data model and crappy SQL back in the 90's could easily be lumbering along today as is after having been ported to v2000,...

  • RE: New to SQL Server 2014

    alorenzini 26244 (10/2/2015)


    Thank you. I have a feeling you will get sick of me before too long.

    Believe or not, there are a lot of folks here who actually enjoy answering...

  • RE: Configuring sql alert for low memory

    Run this to get a breakdown of how much memory is allocated to each memory cache, compare page buffer cache (CACHESTORE_OBJCP) to query plan cache (CACHESTORE_SQLCP).

    Select [type],SUM([single_pages_kb]) As [single_pages_kb]

    ,SUM([multi_pages_kb])...

Viewing 15 posts - 3,361 through 3,375 (of 6,041 total)