Forum Replies Created

Viewing 15 posts - 121 through 135 (of 1,518 total)

  • RE: Table-valued UDF on one database selects data from another database on the same SQL instance - how to make this work without assigning explicit user permissions on db_2?

    SQLKnowItAll (1/23/2012)

    Is EXECUTE AS not an option?

    http://msdn.microsoft.com/en-us/library/ms188354.aspx

    The thought has crossed my mind, but I am a bit short on the specifics.

    In fact, I was reading that very page today.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 23, 2012 at 6:46 pm

    #1437444

  • RE: DBAs and the Career-Life Balance

    I have been following this discussion and get the feeling some of you are on call "all the time"?!

    How is that possible without ending up in a burnout? I am...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 18, 2012 at 5:15 pm

    #1435608

  • RE: DBAs and the Career-Life Balance

    Tracy McKibben (1/17/2012)

    Rather than scramble to keep up with all of the new, sometimes obscure, features that new versions of SQL Server bring, I've worked to position my self as...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 18, 2012 at 5:31 am

    #1435168

  • RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

    GSquared (1/17/2012)

    Jeff Moden (1/16/2012)

    rlevine (1/16/2012)

    Perfect!!

    I was able to install my CLR functions into a db called Library and then use these scripts to enable having all users call the functions...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 17, 2012 at 6:38 am

    #1434569

  • RE: DBAs and the Career-Life Balance

    In many IT environments it is a taboo to allow the employees a portion of time during working hours to advance their knowledge and skill sets, unless this is directly...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 15, 2012 at 6:30 am

    #1433815

  • RE: Running Full and Transaction-Log Backups Concurrently - Any Implications for Database Recovery?

    GilaMonster (1/14/2012)

    Marios Philippopoulos (1/12/2012)

    What happens if a previous log backup, lb0, had started at 9:45 pm (ie. prior to start of the full backup) and completed at 10:05 pm (ie....

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 15, 2012 at 5:31 am

    #1433806

  • RE: Need to grant execute permissions on all sprocs of a specific database to all server logins of a SQL instance without explicitly granting exec permissions on each individual object

    azdzn (1/13/2012)

    One of the way to do it is to enable the guest user :

    Use Your_db

    go

    grant connect to guest

    grant execute to guest

    go

    Thank you all for the input, it is appreciated.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 13, 2012 at 2:00 pm

    #1433515

  • RE: Running Full and Transaction-Log Backups Concurrently - Any Implications for Database Recovery?

    azdzn (1/12/2012)

    Marios Philippopoulos (1/12/2012)

    (1) Restore database from fb with norecovery

    (2) Restore log from lb2 with recovery

    Does it matter that lb2 had started while the full backup was still running?

    You have...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 12, 2012 at 6:04 pm

    #1432971

  • RE: Would like to start my own blog but don't know how

    Thank you both, that's what I was looking for. 🙂

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 9, 2012 at 1:59 pm

    #1430794

  • RE: The Stubborn DBA

    I'm glad to see there are so many others with the "stubbornness" bug! 🙂

    For me the worst feeling is when I get stuck in one of these weird, frustrating problems...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    January 9, 2012 at 10:45 am

    #1430681

  • RE: Optimal Disaster/Recovery Strategy for Data Warehouse (BI) application

    Michael Lysons (12/21/2011)

    Marios Philippopoulos (12/20/2011)

    We use DNS aliases with our prod servers. In a DR situation we will simply switch the aliases from prod to DR.

    That's the approach we've been...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 21, 2011 at 6:31 am

    #1424184

  • RE: Optimal Disaster/Recovery Strategy for Data Warehouse (BI) application

    We use DNS aliases with our prod servers. In a DR situation we will simply switch the aliases from prod to DR.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 20, 2011 at 10:35 am

    #1423815

  • RE: Advice needed to ensure least impact on db mirroring during lengthy planned primary-server outage

    Thank you both for your answers.

    Actually, I wasn't accurate in my original description of the scenario.

    There will actually be 2 outages.

    (1) At 4 pm we are taking down our DR...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 15, 2011 at 12:17 pm

    #1422171

  • RE: Optimal Disaster/Recovery Strategy for Data Warehouse (BI) application

    Martin Thatcher (12/14/2011)

    Hi Marios,

    Can you tell me how you set up your SSIS packages to work on both your principal and DR servers without creating 2 versions? Did you...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 15, 2011 at 3:26 am

    #1421807

  • RE: ReportServer-db query to find which reports are largest contributors to CPU usage in a SQL-2008 SSRS server

    JeremyE (12/13/2011)

    If you know when the CPU spikes occurred, you can use the view ReportServer.dbo.ExecutionLog2 to go back and see which reports were running during that time. I use the...

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

    December 14, 2011 at 4:48 pm

    #1421689

Viewing 15 posts - 121 through 135 (of 1,518 total)