Forum Replies Created

Viewing 15 posts - 826 through 840 (of 7,164 total)

  • RE: make VARCHAR field longer on a large table

    Sergei Zarembo (9/3/2013)


    in other words, the modiication should execute fast, correct?

    Thanks, Gail.

    Yes. Provided it is not being blocked it will complete practically instantaneously.

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

  • RE: Stunned

    This type of comment is not surprising at all. Yes prejudice still exists and no it is not going to go away anytime soon. Thanks for shedding some light on...

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

  • RE: Today's Random Word!

    Ed Wagner (8/28/2013)


    SQLRNNR (8/26/2013)


    JAZZ Master (8/26/2013)


    SQLRNNR (8/23/2013)


    Daniel Bowlin (8/23/2013)


    Ray K (8/23/2013)


    SQLRNNR (8/22/2013)


    opc.three (8/22/2013)


    Gantt

    Hostess

    Freihofers

    Bakery

    Donut run

    Cinnamon Roll

    flaming tire

    Hot doughnuts

    Krispy Kreme

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

  • RE: Today's Random Word!

    Gantt

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

  • RE: xp_logininfo not finding user

    pdanes (8/22/2013)


    opc.three (8/21/2013)


    ... consider a Linked Server configured to connect to and issue queries against AD. Getting a user's group memberships, or a group's members list, is trivial using a...

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

  • RE: Application user group security

    Do you control the connection string the application uses? If yes, are the users in the group prevented from seeing the connection string either due to the architecture or the...

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

  • RE: Today's Random Word!

    bcsims 90437 (8/21/2013)


    Ray K (8/21/2013)


    L' Eomot Inversé (8/21/2013)


    Jason.Reeves (8/21/2013)


    Server

    Waitress

    Hostess

    TWINKIE!

    you knew that was coming, lol

    Expiration Date

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

  • RE: Map SQL server Spid to PID in Task Manager

    Matthew.Peters 13064 (8/21/2013)


    No, We have 3rd party backup software which has made a backup call to SQL server, this process has been stuck in a rollback state for over a...

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

  • RE: How to display two mail Id using database mail to recipient

    Have you seen the @from_address and @reply_to parameters of msdb.dbo.sp_send_dbmail?

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

  • RE: xp_logininfo not finding user

    Sorry pdanes, but using SQL Server as a conduit to AD, especially via xp_logininfo, to control what a user can see or do within an application seems like a bad...

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

  • RE: Map SQL server Spid to PID in Task Manager

    You can't. Are trying to track down which OS process was spawned by a call to xp_cmdshell by any chance?

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

  • RE: Add PK CLUSTERED to existing table with dependencies

    taigovinda (8/20/2013)


    In trying to understand this a bit better, I googled for 'primary key clustered' vs 'unique key clustered' ... if I understand correctly the unique key will NOT prevent...

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

  • RE: sql server 2008R2 - Memory is not releasing after big job run

    SQL Server will use and hold onto as much memory as you allow per the max memory setting. It is expensive to retrieve data from disk and load it into...

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

  • RE: Send email in a tabular format using SQL Server database mail depending upon output row count

    SQListic (8/20/2013)


    Hi Experts..

    Requirement:

    --If the following query resulted greater than zero rows, send the results in email in a tabular format using SQL Server database mail

    --if is is equal to zero...

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

  • RE: SQL Server import export wizard vs bulk insert

    Oracle765 (8/20/2013)


    Hi Professionals.

    I have a question regarding importing data from spreadsheets.

    I manually use SQL Servers Import and Export wizard to import a .xls spreadsheet and it is intelligent enough to...

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

Viewing 15 posts - 826 through 840 (of 7,164 total)