Forum Replies Created

Viewing 15 posts - 106 through 120 (of 584 total)

  • RE: SQL Server Health and History Tool

    Never heard of it. Thanks for a question that made me look it up.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 29, 2014 at 7:43 am

    #1684326

  • RE: value() Method (xml Data Type)

    Ed Wagner (1/28/2014)

    Nice questions, thanks. I don't use XML often, but when I do, I use it slowly. 😉

    +1 I really liked this question. I don't use XML in...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 28, 2014 at 7:20 am

    #1683909

  • RE: Leveraging Constraint Evaluation Sequence in SQL Server

    Nakul,

    Nice article. One small problem I noticed was that the constraint for being 18 years old was given as:

    (DATEDIFF(YEAR,BirthDate,GETDATE()) >= 18);

    That won't give the correct answer when the birthdate is...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 27, 2014 at 6:57 am

    #1683530

  • RE: SSAS: Tabular vs Multi Dimensional

    Koen Verbeeck (1/26/2014)

    2 points for such an easy question. W00t! 😎 :w00t:

    If I would have noticed it was worth two points, the pressure would have got to me, and I'd...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 27, 2014 at 6:35 am

    #1683520

  • RE: IDENTITY RESEED

    I was surprised, and pleased, at the level of detail in the explanation provided. Nice job with that, and the question, Lokesh.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 24, 2014 at 6:34 am

    #1683114

  • RE: I No Longer Have Access to My DB and I'm a DBCreator!

    Stewart "Arturius" Campbell (1/23/2014)

    ALTER SERVER ROLE is new functionality added with SQL2012

    Thanks Stewart for the info.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 23, 2014 at 8:00 am

    #1682800

  • RE: I No Longer Have Access to My DB and I'm a DBCreator!

    Got it wrong, but also got this when I ran the script in SQLCMD mode:

    Msg 102, Level 15, State 1, Line 1

    Incorrect syntax near 'ROLE'.

    Running on 2008. Is it just...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 23, 2014 at 7:20 am

    #1682768

  • RE: Replication

    Raghavendra Mudugal (1/22/2014)

    Thank you for post, Good one Steve.

    (actually, couple of days ago tried it on SIMPLE model, and was sure (to my knowledge) that it will work on this...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 22, 2014 at 7:00 am

    #1682380

  • RE: HASHBYTES

    Excellent question on an interesting topic. Thanks much to the Devil.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 21, 2014 at 9:19 am

    #1682038

  • RE: Uncontrolled Code

    My complaint about Excel is not the product, but the people that use it, er misuse it.

    I can't count the number of times I've been asked/forced to make an "application"...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 21, 2014 at 9:09 am

    #1682022

  • RE: Tempdb

    Knew the first two were wrong, but had to make a guess (wrong) about which of the remaining five was wrong. Thanks for the question.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 20, 2014 at 6:36 am

    #1681513

  • RE: Database Collation Is Null

    raulggonzalez (1/17/2014)

    Thanks for the question, but I have to disagree with one of the answers.

    I have a number of offline databases in one of my servers and the following query...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 17, 2014 at 6:58 am

    #1681052

  • RE: Export Query result to Excel Sheet

    bitbucket-25253 (8/13/2009)

    If you are NOT using Excel 2007 read the following ariticle which also has sample code.

    http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

    10:09 - spelling correction

    Bless you Ron! This has solved an issue I was having...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 16, 2014 at 3:05 pm

    #1680891

  • RE: We're not craftsmen and craftswomen

    Personally, I'd like to thank everyone for the craftperson-like way they discussed this issue. :hehe: (I hope that's the last time I use "craftsperson-like".)

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 16, 2014 at 3:01 pm

    #1680890

  • RE: Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

    Dennis Wagner-347763 (1/16/2014)

    The solution seems to be to calculate the days for comparison purposes. Then, add the days to a standard reference date, such as 1900-01-01. THEN do your DATEDIFF...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 16, 2014 at 2:55 pm

    #1680886

Viewing 15 posts - 106 through 120 (of 584 total)