Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 7,164 total)

  • RE: Help with a Deadlock Issue

    ft55 (4/29/2013)

    Hi,

    Thanks for the response I was looking for a solution that could be used just at the transaction level rather than at the a database level. I'm slightly...

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

    May 1, 2013 at 8:26 pm

    #1611766

  • RE: Today's Random Word!

    Status

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

    May 1, 2013 at 1:36 pm

    #1611705

  • RE: Rebuild or DBREINDEX

    ScottPletcher (4/30/2013)

    According to BOL, SQL scans the table:

    "Rebuilding the index offline, by contrast, will force a scan of the clustered index (or heap) and so remove the inconsistency."

    I reported the...

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

    May 1, 2013 at 1:04 pm

    #1611695

  • RE: SQL SERVER 2005 Updates

    ganci.mark (4/30/2013)

    I see there is a build 9.00.5324 which I believe should have the security update but I cannot find a downloadable update. This only brings me to a 'description'.

    See...

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

    April 30, 2013 at 9:53 pm

    #1611455

  • RE: trigger security

    You can DENY ALTER on the table but in addition to preventing changes to the triggers on that table it also prevent them from adding columns to the table, modifying...

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

    April 30, 2013 at 1:56 pm

    #1611395

  • RE: Generate two columns from single column with alternating data

    Another option:

    WITH MyInputdata(ID, Val)

    AS (

    ...

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

    April 29, 2013 at 2:44 pm

    #1611015

  • RE: Suppressing output from a stored procedure.

    Just for fun, how would you rewrite the SSIS package using only T-SQL to "generate a couple of excel spreadsheets, and email them."?

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

    April 29, 2013 at 1:48 pm

    #1610991

  • RE: Table size swell after altering a column

    Is there a weekend "index rebuild" job? That could cause a reduction in space if fragmentation was causing the bloat.

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

    April 29, 2013 at 1:47 pm

    #1610990

  • RE: Suppressing output from a stored procedure.

    Jeff Moden (4/29/2013)

    opc.three (4/26/2013)

    A proper solution would be to get rid of the use of xp_cmdshell all together.

    The recommended way using either a SQL Agent job or a web...

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

    April 29, 2013 at 1:43 pm

    #1610988

  • RE: Script Task C# Code(The name 'Dts' does not exist in the current context)

    SSIS 2005 Script Tasks only support VB.net.

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

    April 29, 2013 at 1:25 pm

    #1610980

  • RE: How to add database source name and database destination name dynamically on a SSIS?

    Open the package in BIDS, change the Connection Managers to point to the new server and database and then save it back to the original location where it is referred...

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

    April 29, 2013 at 11:34 am

    #1610930

  • RE: Configuring MAX memory

    Start logging the "available MBs" counter, "page life expectancy" and the "page file % used" counter and see how they do over time. If you have memory pressure drops or...

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

    April 29, 2013 at 11:31 am

    #1610929

  • RE: What is 'available physical memory' in DBCC MEMORYUSAGE

    This is most of what I use except I dropped the columns that use SQL 2008+ features. Hopefully some of it will help you:

    -- memory overview

    SELECT CAST((

    ...

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

    April 29, 2013 at 11:29 am

    #1610927

  • RE: PCI Compliance

    vikingDBA (4/29/2013)

    "You may as well keep the SP in cleartext"

    While some people know how to decrypt encrypted stored procedures, I personally subscribe to bad guys the same way I subscribe...

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

    April 29, 2013 at 10:15 am

    #1610898

  • RE: Suppressing output from a stored procedure.

    Ok, sounds like Agent is not an option. There are others shown in the article I linked to.

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

    April 29, 2013 at 9:04 am

    #1610854

Viewing 15 posts - 1,186 through 1,200 (of 7,164 total)