Forum Replies Created

Viewing 15 posts - 6,031 through 6,045 (of 19,560 total)

  • RE: The DBA Tax

    jfogel (7/9/2012)


    If your employer doesn't know what you do and why they pay you then you have already lost the battle. Get out while the getting is good.

    It's also time...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    Cliff Jones (7/9/2012)


    Ray K (7/9/2012)


    Revenant (7/9/2012)


    rhythmk (7/9/2012)


    Brandie Tarvin (7/9/2012)


    Daniel Bowlin (7/9/2012)


    Heatwave

    Heatstroke

    Engine

    Piston

    V6

    V8

    HEMI

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Rename the existinng File at same location

    Koen Verbeeck (7/9/2012)


    Jeff Moden (7/7/2012)


    Phil Parkin (7/7/2012)


    SQLRNNR (7/7/2012)


    I would use two file system tasks or perform the move via a script component.

    I think you might mean a script task, and...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    gitan

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Union and Union All

    bitbucket-25253 (7/7/2012)


    Nice to be reminded of the basics

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Inapproriate writes observed in PERFMON when a query is issued

    do you have fulltext enabled?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Killed 5 Processes Table Locks Yesterday, Still in Killed/Rollback Status

    Welsh Corgi (7/7/2012)


    I restarted the SQL Server Service for that instance to get rid of those processes

    Unfortunately, as a last resort, that is the only other thing that can be...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Rename the existinng File at same location

    I would use two file system tasks or perform the move via a script component.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: callin SSIS Package in Sql server Agent Job

    Here's a similar thread. I'd start here first and then ask more precise questions

    http://www.sqlservercentral.com/Forums/Topic1054528-391-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Need help with SQL query

    challapal (7/7/2012)


    Can someone guide me how to write these queries below in SQLSERVER

    i am a new developer

    --------------------------------------------------------------------------------------

    string that starts with consecutive digits Example 123g, 567jku

    string that starts with consecutive ...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: SQL Query Tuning help

    Yes there are materialized views in SQL Server. They are most commonly called Indexed Views.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    crookj (7/6/2012)


    SQLRNNR (7/6/2012)


    Cliff Jones (7/6/2012)


    Brandie Tarvin (7/6/2012)


    Doooughnut.

    Bear Claw

    lemon filling

    Mapel Long John :w00t:

    yummy

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Execs and temporary tables

    mtassin (7/6/2012)


    Always nice to have an easy one on Friday....

    Yes it is.:-D

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    Cliff Jones (7/6/2012)


    Brandie Tarvin (7/6/2012)


    Doooughnut.

    Bear Claw

    lemon filling

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Revert Last Delete Statement on in SQL Mgmt Studio

    SQLRNNR (7/5/2012)


    Run this code and replace 'YourDBNameHere' with the name of the database you are working with

    DECLARE @DBName varchar(128)

    SET @DBName = 'YourDBNameHere'

    Select a.database_name,a.backup_start_date

    ,BackupPath = b.physical_device_name

    ,BackupSizeMB = a.backup_size/1024/1024

    ,CompressedBackMB = a.compressed_backup_size/1024/1024

    From...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 6,031 through 6,045 (of 19,560 total)