Forum Replies Created

Viewing 15 posts - 166 through 180 (of 626 total)

  • RE: Query to compare values between multiple columns

    I believe this gets you what you are looking for...

    SELECT

    s1.LocID,

    s1.Name1 as s1Name1,

    s1.Name2 as s1Name2,

    s2.Name1 as s2Name1,

    s2.Name2 as s2Name2

    FROM #Server1 s1

    JOIN #Server2 s2 ON s2.LocID = s1.LocID

    WHERE...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 13, 2016 at 12:07 pm

    #1906429

  • RE: Today's Random Word!

    Ed Wagner (10/12/2016)

    Manic Star (10/12/2016)

    Y.B. (10/12/2016)

    Ed Wagner (10/12/2016)

    whereisSQL? (10/12/2016)

    Base

    Operations

    Surgeon

    Plastic

    Metal

    Heavy

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 12, 2016 at 1:57 pm

    #1906200

  • RE: What do you do or think about on the way to work?

    45 minute commute depending on traffic. Podcasts has become a lifesaver as I can only listen to music so long. NPR Planet Money is one of my favorites...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 12, 2016 at 1:22 pm

    #1906193

  • RE: Today's Random Word!

    Ed Wagner (10/12/2016)

    whereisSQL? (10/12/2016)

    Base

    Operations

    Surgeon

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 12, 2016 at 11:37 am

    #1906177

  • RE: Are the posted questions getting worse?

    Grant, you mentioned Mens Rea in another thread (which is not a term you often hear) and it reminded me of a funny scene from "See No Evil, Hear No...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 12, 2016 at 9:07 am

    #1906149

  • RE: What is the right way to design a data flow between development and production dbs?

    Grant Fritchey (10/12/2016)

    Especially true because of a clause in the US law known as Mens Rea, meaning with knowledge. If you knowingly share healthcare information with unqualified people in the...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 12, 2016 at 9:00 am

    #1906147

  • RE: Are the posted questions getting worse?

    Luis Cazares (10/11/2016)

    Y.B. (10/11/2016)

    Ok, I think I might be going crazy but I've never seem to have any issues with html encoding when posting code before. However, for some...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 11, 2016 at 11:19 am

    #1905950

  • RE: Inner Join

    As an aside, avoid using a leading wildcard in your LIKE (i.e. '%sup%) if possible. You won't be able to make use of any indexes on that column...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 11, 2016 at 9:46 am

    #1905926

  • RE: Are the posted questions getting worse?

    Ok, I think I might be going crazy but I've never seem to have any issues with html encoding when posting code before. However, for some reason I'm now...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 11, 2016 at 8:50 am

    #1905915

  • RE: search date in stored procedure

    SQL will do an implicit conversion to a DATETIME data type.

    For Example:

    DECLARE @myDateTime DATETIME = '2016-10-11'

    SELECT @myDateTime

    Will get you:

    2016-10-11 00:00:00.000

    What does you data look like?

    You might want to do something...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 11, 2016 at 8:02 am

    #1905902

  • RE: Today's Random Word!

    crookj (10/7/2016)

    Grumpy DBA (10/7/2016)

    Luis Cazares (10/7/2016)

    Grumpy DBA (10/7/2016)

    Stuart Davies (10/7/2016)

    Ed Wagner (10/5/2016)Spawn

    Frog

    Polliwog

    Poliwag

    Poliwhirl

    Pollywannacracker

    Parrot

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 7, 2016 at 1:54 pm

    #1905459

  • RE: Which of the 2 queries is better in terms of performance

    Phil Parkin (10/7/2016)

    Run them both in the same batch and check the relative costs.

    ^THIS

    As an example I ran similar queries against AdventrureWorks2012.

    SELECT

    *

    FROM

    Sales.Customer c

    LEFT JOIN Sales.SalesOrderHeader soh ON...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 7, 2016 at 1:51 pm

    #1905458

  • RE: Index guidance needed

    CferMN (10/4/2016)

    GilaMonster (9/15/2016)

    What's the table frequently filtered by?

    GilaMonster (9/16/2016)

    Good start

    What's the most common predicate used against that table?

    I'm new to index/performance tuning. Could you please explain how to tell what...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 7, 2016 at 1:18 pm

    #1905448

  • RE: count timespans without overlaps

    drew.allen (10/7/2016)

    Here is an updated version that only requires a single scan of the table. There is a complete description of the logic at New Solution to the Packing...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 7, 2016 at 11:42 am

    #1905435

  • RE: Finally got my SQL Server database into Azure!

    Doctor Who 2 (8/7/2016)

    Eirikur Eiriksson (7/24/2016)

    Doctor Who 2 (7/24/2016)

    I finally got my SQL Server database uploaded into Azure SQL! I posted a blog post about it. Rather than repeat what...

    SELECT quote FROM brain WHERE original = 1
    0 rows returned

    October 3, 2016 at 2:16 pm

    #1904555

Viewing 15 posts - 166 through 180 (of 626 total)