Forum Replies Created

Viewing 15 posts - 781 through 795 (of 7,164 total)

  • RE: blocking LCK_M_SCH_S, LCK_M_SCH_M

    mauriciorpp (2/12/2014)

    opc.three (1/10/2013)

    "Mostly Online" feels like ~60%. I'd submit "Near Online", it feels closer to 99% 😀

    until today, all my "online" index rebuilds worked as expected. but just today I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    February 12, 2014 at 11:06 pm

    #1688601

  • RE: Need a way to script out LinkedServers on a SQL 2005\2008 boxes but place the script in seperate files.

    Works on Windows 8 with SQL 2012 or 2008 R2:

    <# SYNOPSIS

    Generates create scripts for all LinkedServers.

    DESCRIPTION

    PowerShell script using SQL Provider to script out all LinkedServers.

    NOTES

    Requires: PowerShell Version 2.0, SMO assembly

    #>

    param...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 17, 2014 at 3:34 am

    #1681006

  • RE: Need a way to script out LinkedServers on a SQL 2005\2008 boxes but place the script in seperate files.

    It could be one of a lot of different reasons. What is the exact error message or behavior you are seeing running on Windows 7?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    January 17, 2014 at 1:26 am

    #1680980

  • RE: Today's Random Word!

    JAZZ Master (12/9/2013)

    Ed Wagner (12/9/2013)

    Revenant (12/9/2013)

    Kurt W. Zimmerman (12/9/2013)

    Ed Wagner (12/9/2013)

    BWFC (12/9/2013)

    whereisSQL? (12/9/2013)

    Ed Wagner (12/9/2013)

    crookj (12/9/2013)Snow (8 inches of it!)

    Driving

    Skid

    Row

    Column

    pillar

    fire

    Migration

    Route

    root

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 9, 2013 at 11:27 am

    #1672077

  • RE: A few reflections on RBAR by a weary application developer

    mtassin (12/9/2013)

    Koen Verbeeck (12/9/2013)

    Nice article.

    One remark though: using SSIS doesn't necessarily mean RBAR.

    You can stream the data into a bulk load just fine (as fast as the join) and still...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 9, 2013 at 9:54 am

    #1672034

  • RE: Today's Random Word!

    Framework

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    December 3, 2013 at 9:03 am

    #1670424

  • RE: Today's Random Word!

    Ed Wagner (11/27/2013)

    SQLRNNR (11/26/2013)

    L' Eomot Inversé (11/26/2013)

    Ed Wagner (11/26/2013)

    opc.three (11/26/2013)

    Ed Wagner (11/26/2013)

    Time

    Table

    Tally

    Stick

    Mud

    Lincoln

    Navigator

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 27, 2013 at 5:54 am

    #1669436

  • RE: Today's Random Word!

    L' Eomot Inversé (11/26/2013)

    Ed Wagner (11/26/2013)

    opc.three (11/26/2013)

    Ed Wagner (11/26/2013)

    Time

    Table

    Tally

    Stick

    Abacus

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 26, 2013 at 7:38 am

    #1669151

  • RE: Today's Random Word!

    Ed Wagner (11/26/2013)

    Time

    Table

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 26, 2013 at 5:32 am

    #1669097

  • RE: Data type validations

    Note that ISDATE() has tons of odd interpretations as well.

    For example, '2013' returns as a valid date:

    SELECT ISDATE('2013')

    Which makes sense if you consider this returns 2013-01-01:

    SELECT CAST('2013'...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 21, 2013 at 8:54 pm

    #1668290

  • RE: SQLCMD

    Jeff Moden (11/21/2013)

    opc.three (11/20/2013)

    And the sysadmin members? ...oh that's right, you argue that you must trust them implicitly.

    Jeez, Orlando. If you can't trust an SQL Server Admin or a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 21, 2013 at 10:38 am

    #1668188

  • RE: SQLCMD

    Jeff Moden (11/20/2013)

    That's just it. There are no security challenges to it. I don't allow users to use xp_CmdShell directly. I don't allow apps to execute it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2013 at 11:00 pm

    #1668027

  • RE: SQLCMD

    Jeff Moden (11/20/2013)

    opc.three (11/20/2013)

    Jeff Moden (11/20/2013)

    opc.three (11/20/2013)

    Chances are I could accomplish this through a SQLCLR. I could definitely setup an Agent job that a low-priv user could run by executing...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2013 at 10:42 pm

    #1668024

  • RE: SQLCMD

    Jeff Moden (11/20/2013)

    opc.three (11/20/2013)

    Chances are I could accomplish this through a SQLCLR. I could definitely setup an Agent job that a low-priv user could run by executing a stored proc....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2013 at 10:33 pm

    #1668022

  • RE: SQLCMD

    Jeff Moden (11/20/2013)

    opc.three (11/20/2013)

    I can think of ways a non-SA could be setup so they could enable xp_cmdshell without the use of a proxy. Your point?

    I can think of ways...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    November 20, 2013 at 10:09 pm

    #1668018

Viewing 15 posts - 781 through 795 (of 7,164 total)