Forum Replies Created

Viewing 15 posts - 46 through 60 (of 454 total)

  • RE: Nuance of datetime data type in SQL Server

    louie1487 78804 - Thursday, April 13, 2017 5:22 AM

    I don't agree at thinking that when a time value is inserted and the...

    April 13, 2017 at 6:38 am

    #1938023

  • RE: Stored procedure parameters

    George Vobr - Sunday, April 2, 2017 6:00 PM

    The syntax CREATE PROCEDURE statement allows you to create output_only procedure. The following stored...

    April 5, 2017 at 6:46 pm

    #1936946

  • RE: Stored procedure parameters

    RonKyle - Thursday, March 30, 2017 7:30 AM

    Will have to think about this more, but my first hunch is that this is...

    March 30, 2017 at 6:41 pm

    #1935892

  • RE: SSMS Tips - Text Results

    timwell - Tuesday, March 28, 2017 7:25 AM

    I knew about ctrl-T but looked up ctrl-shift-T in case that was a modification to switch...

    March 28, 2017 at 9:32 am

    #1935303

  • RE: SSMS Tricks - Results

    Yeah, if you're ever writing queries longer than 50 lines, you have to know this one..

    March 15, 2017 at 7:13 am

    #1933238

  • RE: Fun with Time

    palotaiarpad - Tuesday, February 28, 2017 2:08 AM

    Should i drink a second coffee? :crazy:

    @t is TIME, not DATETIME. That's what got me.

    The...

    February 28, 2017 at 5:52 am

    #1930665

  • RE: Vertical Blocks of Code

    Bobby Russell - Wednesday, February 15, 2017 9:20 AM

    The only way using alt alone works is with the mouse which you shouldn't be...

    February 15, 2017 at 3:52 pm

    #1928743

  • RE: The differential PoSh backup

    This is exactly why I can't get behind PowerShell (and many other Microsoft things, for that matter.) It's an excellent tool which I use to automate many things, but it's...

    February 7, 2017 at 6:19 am

    #1927063

  • RE: AG Commit Modes

    I'm so very glad there isn't a Commit Mode labeled "Best_Effort"!

    January 30, 2017 at 6:28 am

    #1925584

  • RE: EXECUTE as SELF

    bmg002 - Wednesday, January 18, 2017 8:38 AM

    I liked that question.  It was a fun one.
    The only reason I can think to do...

    January 19, 2017 at 10:29 am

    #1923787

  • RE: U-SQL data types

    martin.whitton - Friday, January 13, 2017 3:57 AM

    Will ARRAY ever be added to T-SQL?
    Who would like to see it added?

    Why? I don't see...

    January 13, 2017 at 7:34 am

    #1922554

  • RE: Killing Statistics Jobs

    Both sysadmin and processadmin roles have VIEW SERVER STATE rights anyway, so that option is redundant. (see https://msdn.microsoft.com/en-us/library/ms188659(v=sql.130).aspx#Permissions of Fixed Server Roles for a nice graphic.)

    The question was unclear in...

    January 10, 2017 at 6:37 am

    #1921596

  • RE: HASHBYTES limits

    James Lean (12/21/2016)

    I think the documentation is slightly misleading on this. I've tried the below on SQL 2014 and 2016, and they both give the same result, namely the...

    December 21, 2016 at 6:42 am

    #1919132

  • RE: The autogenerated view

    Grant Fritchey (12/20/2016)

    sknox (12/20/2016)

    paul s-306273 (12/20/2016)

    Grant - you have no sense of humour and I have no point for QOTD today.

    I don't know -- "Multiple Partitioned Statistics" was a pretty...

    December 20, 2016 at 5:06 pm

    #1919062

  • RE: The autogenerated view

    paul s-306273 (12/20/2016)

    Grant - you have no sense of humour and I have no point for QOTD today.

    I don't know -- "Multiple Partitioned Statistics" was a pretty funny (and sadly...

    December 20, 2016 at 7:27 am

    #1918908

Viewing 15 posts - 46 through 60 (of 454 total)