Forum Replies Created

Viewing 15 posts - 3,361 through 3,375 (of 8,731 total)

  • RE: Help with understanding how SQL behaves with inner joins

    If you're not using any calculations or functions in your join conditions, and you don't have an implicit conversion going on, you're probably reading the whole table or most of...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 15, 2016 at 7:16 am

    #1858775

  • RE: HEX conversions

    Igor Micev (2/15/2016)

    Was this inspired from QotD "Converting hex values" on Feb 9 ?

    "repeating is the mother of knowledge"

    Thanks

    I was thinking the exact same thing.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 15, 2016 at 7:06 am

    #1858770

  • RE: Identify procs referencing user-defined table type

    Having that issue right now, the problem comes not when the type is in the code, but when it's a parameter. An easy way to find problems would be like...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 1:51 pm

    #1858507

  • RE: Window function to expand row into multiple rows?

    Jacob Wilkins (2/12/2016)

    No need to use window functions. A simple CROSS APPLY will do the trick.

    SELECT [OrderNumber]=OrderID,

    [User]=x.[User]

    FROM dbo.Orders CROSS APPLY (SELECT...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 10:00 am

    #1858435

  • RE: Today's Random Word!

    DonlSimpson (2/12/2016)

    crookj (2/12/2016)

    djj (2/12/2016)

    Ed Wagner (2/12/2016)

    Grumpy DBA (2/12/2016)

    Ed Wagner (2/11/2016)

    DonlSimpson (2/11/2016)

    Hugo Kornelis (2/11/2016)

    Anyway, back to out regular scheduled content for this topic....

    Ed Wagner (2/11/2016)

    Skynet

    Terminator

    Resistor

    Resistance

    Futile

    Borg

    android

    synthezoid

    Vision

    blurred

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 9:19 am

    #1858418

  • RE: Are the posted questions getting worse?

    Grumpy DBA (2/12/2016)

    ^ Okay, I can't take it any more, link please...

    (background noise - popcorn is popping)

    http://www.sqlservercentral.com/Forums/Topic1760779-2799-1.aspx

    I was going to comment on that thread, but I got lost with some...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 8:47 am

    #1858397

  • RE: Calculating YOY data assistance

    I would actually remove THEYEAR, THEMONTH & Month-Year columns and leave them as formatted values in SSRS.

    Here's an option:

    CREATE TABLE POSTING(

    POSTING_ID INT IDENTITY(1,1),

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 8:41 am

    #1858392

  • RE: Are the posted questions getting worse?

    Grumpy DBA (2/12/2016)

    Luis Cazares (2/12/2016)

    Wouldn't having the power switch close make Jason its biggest threat?

    Yes, and once the server rack realizes that... goodbye Jason.

    If we're possitive, maybe the server rack...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 7:54 am

    #1858355

  • RE: The RPO

    djj (2/12/2016)

    sestell1 (2/12/2016)

    I was confused by the transaction logs being "from midnight on". What is that relative to? :angry:

    My comment also. I was thinking you stopped transaction...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 7:50 am

    #1858352

  • RE: Are the posted questions getting worse?

    Ed Wagner (2/12/2016)

    Grant Fritchey (2/12/2016)

    jasona.work (2/11/2016)

    Ed Wagner (2/11/2016)

    jasona.work (2/11/2016)

    Grumpy DBA (2/11/2016)

    At least he didn't name it WOPR ("shall we play a game?").

    No, that's one of my domain controllers.

    It's an older...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 7:36 am

    #1858344

  • RE: Calculating YOY data assistance

    Here's some sample data (which you should have posted) and a shorter version of your query.

    What should the results look like for this data?

    CREATE TABLE POSTING(

    POSTING_ID...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 12, 2016 at 7:34 am

    #1858343

  • RE: Select from tables dynamically (table is variable)

    There's actually a good method to validate table names.

    This is a generic example that you need to adapt to your needs. An invalid table name won't do anything.

    DECLARE @table_name sysname...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 10, 2016 at 12:01 pm

    #1857832

  • RE: Creating Snippets

    Steve Jones - SSC Editor (2/9/2016)

    bump

    Does this means that an article on this could be interesting?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 10, 2016 at 11:51 am

    #1857828

  • RE: need help to write a query

    Did you try something like this?

    SELECT o.*,

    COALESCE( NULLIF( o.t_wght, 0), x.t_wght, 0)

    FROM [TBRTEK002] o

    OUTER APPLY (

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 10, 2016 at 11:43 am

    #1857824

  • RE: TVF suddenly slow

    I'd encourage Scott's suggestion. You might be missing something in the code that can be improved.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    February 10, 2016 at 11:40 am

    #1857822

Viewing 15 posts - 3,361 through 3,375 (of 8,731 total)