Forum Replies Created

Viewing 15 posts - 6,046 through 6,060 (of 19,560 total)

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

    Jeffrey Williams 3188 (7/5/2012)

    GSquared (7/5/2012)

    Whenever I have to modify data in production, I start with "begin transaction" and end with "rollback", run the script, use OUTPUT to check the results,...

    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

    July 5, 2012 at 1:32 pm

    #1509330

  • RE: Removing Unused Indexes - Did it cause my performance problem?

    Jeff Moden (7/5/2012)

    Not all "unused" indexes are actually unused. Some may be UNIQUE indexes or enforce other constraints and the optimizer can make certain optimizations just knowing that there...

    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

    July 5, 2012 at 11:03 am

    #1509242

  • RE: I want to move a database server to server without using Backup and restore?

    Sean Lange (7/5/2012)

    SQLRNNR (7/5/2012)

    You can detach and attach. I would not proceed down that path without having a good backup though. I like to proceed cautiously and make...

    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

    July 5, 2012 at 10:48 am

    #1509234

  • RE: Finding Unused Database Roles

    Brandie Tarvin (7/5/2012)

    SQLRNNR (7/5/2012)

    Thanks Brandie. I even like that you posted the script using dbcc timewarp. Notice the publish date is July 24, 2012.:-D

    Shhhhh. You're not supposed to...

    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

    July 5, 2012 at 10:20 am

    #1509214

  • RE: Removing Unused Indexes - Did it cause my performance problem?

    It is possible that the removal of those indexes caused your slowdown.

    Do you have the indexes scripted so you can re-create them just in case?

    Here is another script that I...

    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

    July 5, 2012 at 10:19 am

    #1509213

  • RE: Finding Unused Database Roles

    Thanks Brandie. I even like that you posted the script using dbcc timewarp. Notice the publish date is July 24, 2012.:-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

    July 5, 2012 at 10:06 am

    #1509207

  • RE: I want to move a database server to server without using Backup and restore?

    You can detach and attach. I would not proceed down that path without having a good backup though. I like to proceed cautiously and make sure I have...

    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

    July 5, 2012 at 10:03 am

    #1509206

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

    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 msdb.dbo.backupset...

    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

    July 5, 2012 at 10:00 am

    #1509204

  • RE: Create Script of all indexes in a Database

    AAKR (7/5/2012)

    Hi thanks for quick reply. this script working on sysdatabases only

    I want create user database indexes please provide the script:-)

    Thanks in Adavance:-)

    Both scripts provided should do what you are...

    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

    July 5, 2012 at 9:54 am

    #1509200

  • RE: Independence Day 2012

    SQL Kiwi (7/3/2012)

    Ok own up - who chose Pepsi? :laugh:

    I should have. That would be the better choice imho.:cool:

    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

    July 5, 2012 at 9:40 am

    #1509192

  • RE: Index Types

    Correct answers:3%(7)

    Incorrect answers:97%(262)

    Total attempts: 269

    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

    July 5, 2012 at 9:38 am

    #1509190

  • RE: Index Types

    Steve Cullen (7/5/2012)

    Correct answers = 1 ???

    This must be one of those Monty Python type questions:

    Q: What is your name?

    A: Steve Cullen

    Q: What is your quest?

    A: I seek knowledge 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

    July 5, 2012 at 9:37 am

    #1509189

  • RE: Today's Random Word!

    crookj (7/5/2012)

    Ray K (7/5/2012)

    Monday (at least it feels like it -- I hate when holidays fall on Wednesdays!)

    (For the benefit of those outside the USA, that was our Fourth of...

    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

    July 5, 2012 at 9:09 am

    #1509169

  • RE: Granting datareader access to a user for objects in a schema

    I would log in as that user from a different location such as your machine. I suspect the user may have a filter being applied in SSMS.

    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

    July 5, 2012 at 9:06 am

    #1509167

  • RE: Are the posted questions getting worse?

    GilaMonster (7/3/2012)

    For anyone not on/not paying attention to twitter.....

    It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.

    https://twitter.com/SQLintheWild/statuses/220252281847808001

    Congrats

    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

    July 3, 2012 at 3:29 pm

    #1508514

Viewing 15 posts - 6,046 through 6,060 (of 19,560 total)