Forum Replies Created

Viewing 15 posts - 4,096 through 4,110 (of 26,490 total)

  • RE: How to query a Denormalised table

    Jeff mentioned checking or swapping dates so that a StartDate is always less than (or equal to) an EndDate. Starting with SQL Server 2008 this is actually easy to...

    February 23, 2016 at 8:13 am

    #1860421

  • RE: Are the posted questions getting worse?

    Jeff Moden (2/22/2016)

    No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows how to get the...

    February 22, 2016 at 5:17 pm

    #1860238

  • RE: Update with two date columns, need converting

    Of course you could also use a computed column where the definition is simply YEAR(column1).

    February 22, 2016 at 1:15 pm

    #1860188

  • RE: Using Parameters in a Query is Killing Performance

    Loner (2/17/2016)

    Ok, I give up, someone please help! We have a query that runs just fine with hard coded values but once we swap them out for parameters the query...

    February 19, 2016 at 10:04 am

    #1859889

  • RE: How to query a Denormalised table

    sushantkatte (2/16/2016)

    I am a newbie in sql. recently i came across a set of questions specific to query a denormalised table. Can someone help me how to answer these questions

    Customer_id...

    February 19, 2016 at 9:46 am

    #1859878

  • RE: The RPO

    TomThomson (2/18/2016)

    Sean Lange (2/12/2016)

    Luis Cazares (2/12/2016)

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

    February 18, 2016 at 3:59 pm

    #1859711

  • RE: Are the posted questions getting worse?

    Work, what's that? :w00t:

    February 18, 2016 at 9:43 am

    #1859623

  • RE: smtp logging into sql server using ODBC connections

    Srl832 (2/17/2016)

    Hi Lynn,

    I have a question that you might know the answer to. I have the ODBC logging set up and working for an smtp server. It seems every...

    February 17, 2016 at 3:47 pm

    #1859400

  • RE: How to "Date" help

    Orlando Colamatteo (2/16/2016)

    select datefromparts(year(getdate())-1,1,1) as beginning_of_last_year,

    datefromparts(year(getdate())-1,12,31) as end_of_last_year;

    I don't like using closed ended ranges for date ranges. Prefer close ended on the lower end...

    February 16, 2016 at 9:44 am

    #1859018

  • RE: Are the posted questions getting worse?

    The real problem is that those that govern have forgotten who are the masters and who are the servants. Government is supposed to the servants of the people not...

    February 16, 2016 at 8:47 am

    #1859001

  • RE: XML PATH QUESTION

    Eirikur Eiriksson (2/15/2016)

    Luis Cazares (2/15/2016)

    Eirikur Eiriksson (2/15/2016)

    Luis Cazares (2/15/2016)

    Eirikur,

    Any reason for using FLOOR on an integer division?

    Old oracle habit

    😎

    :sick:Oracle:sick:

    yup, the difference between \ and / :pinch:

    😎

    We got you terminating your...

    February 15, 2016 at 1:49 pm

    #1858847

  • RE: How do we get the definition of tables via sql

    mw112009 (2/12/2016)

    Reply to Post #1760966 from Lynn

    The answer is "YES" ( I mean I am able to modify the code )

    Why do I need the code ?

    I have to copy...

    February 12, 2016 at 2:05 pm

    #1858513

  • RE: Identify procs referencing user-defined table type

    ScottPletcher (2/12/2016)

    I would think sys.sql_expression_dependencies would contain those references, since a table-type is in sys.objects, type = 'tt'.

    Only way to know for sure is test it out. I may...

    February 12, 2016 at 1:01 pm

    #1858499

  • RE: Adding quotes to dynamic SQL

    TheSQLGuru (2/12/2016)

    Brandie Tarvin (2/12/2016)

    TheSQLGuru (2/11/2016)

    Whenever I am building out dynamic SQL I always use SET QUOTED_IDENFITIER OFF first and then use double quotes in the outer sections of text. Then...

    February 12, 2016 at 12:39 pm

    #1858493

  • RE: SQL Server upgrade from 2008 Enterprise SP3 to SQL 2008 R2 Enterprise SP3

    bobba (2/12/2016)

    We need to upgrade a cluster named instance. SQL Server is currently 2008 SP3 Enterprise 64 bit. We want to upgrade to SQL Server 2008 R2 SP3...

    February 12, 2016 at 12:24 pm

    #1858491

Viewing 15 posts - 4,096 through 4,110 (of 26,490 total)