Forum Replies Created

Viewing 15 posts - 706 through 720 (of 1,838 total)

  • RE: Don’t Underestimate the Importance of Good Co-workers

    mig28mx - Tuesday, October 17, 2017 8:42 AM

    ...my golden rule is: let them work. And with that rule, I allways prefeer a...

  • RE: Timing is Everything

    Too many joins can make a query perform poorly and it can help to break down an extremely large query, especially if some of them are filtering logic joins and...

  • RE: Selecting data related to an aggregated column

    It's difficult to tell from this small a sample of data, but here's a couple of options, depending on how many rows per GROUPID you have in your history table...

  • RE: Writelog wait type

    The 2 are not necessarily correlated.  You can get a quick summary of file latency and a view of how much log space is used like this:
    SELECT...

  • RE: What Pizzas do DBA's prefer?

    I'd say my favorite would have banana peppers, sausage, and black olives on it.  I'm not much a fan of Pizza Hut's crust though, there's some local chains I prefer...

  • RE: Order of Indexed columns - does it matter

    GBeezy - Wednesday, October 11, 2017 11:08 AM

    SELECT *
    FROM dbo.blah
    WHERE GID = 1

    SELECT *
    FROM dbo.blah
    WHERE PID = 1

    They both perform...

  • RE: Help in analyzing deadlock and index recommendation - all definitions included

    Have you looked at the execution plan of the stored proc to see if the index is actually used?
    Also, what other queries are executed against this table UO_MList?  If...

  • RE: Update Statistics

    It's actually a 20% threshold for autoupdate of stats, although there's a trace flag that can somewhat improve that behavior.  Here's an article that has many subtopics about database statistics:

  • RE: Alter LDF File Max Size

    Lynn Pettis - Tuesday, October 10, 2017 10:48 AM

    Chris, decided to play with your code a bit:

    cool, I didn't know IntegerData...

  • RE: Alter LDF File Max Size

    jstites - Monday, October 9, 2017 4:54 PM

    Can you tell me what it means that the majority of my data is coming...

  • RE: Alter LDF File Max Size

    you can get some information about growths by looking at the default trace:
    --history
    DECLARE @path NVARCHAR(260);
    SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])), 260)) + N'log.trc'
    ...

  • RE: Options to run BCP in SQL Server

    the other easy option that comes to mind then is a SQL Server Agent job that has a step of type:
    Operating System (CmdExec)

  • RE: No More Service Packs

    Eric M Russell - Tuesday, October 3, 2017 10:45 AM

    I guess this an effort on the part of Microsoft product teams to...

  • RE: Move From Developer Edition To Express?

    Beatrix Kiddo - Tuesday, October 3, 2017 7:36 AM

    Are you aware that there's no SQL Agent on the Express version, so...

  • RE: Database maintenance

    zulkefli - Tuesday, October 3, 2017 2:07 AM

    Hi John,
       Thank you for your reply. So by looking at the execution plans, they...

Viewing 15 posts - 706 through 720 (of 1,838 total)