Forum Replies Created

Viewing 15 posts - 586 through 600 (of 1,518 total)

  • RE: Linked Servers vs. Integration Services - Pros and Cons

    Elliott W (8/12/2009)

    I like both but each has its own purpose..

    Many (most) environments end up with a mix. With Linked servers being used less.

    For data that you need 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]

    August 12, 2009 at 1:43 pm

    #1038258

  • RE: Opinions needed on a SQL-CLR Book - any good?

    Elliott W (7/28/2009)

    I think I have that one at home, I liked it. I thought it was pretty good..

    CEWII

    Thanks, I checked amazon and there are no reviews, but from...

    __________________________________________________________________________________
    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]

    July 28, 2009 at 1:29 pm

    #1031284

  • RE: Setting named instance to listen on static port - what about the loopback adapter?

    Luke L (7/28/2009)

    The dedicated admin connection or DAC is a special connection setup by SQL Server. There is one per instance and it is usually 1 port higher than...

    __________________________________________________________________________________
    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]

    July 28, 2009 at 11:05 am

    #1031187

  • RE: Backing up info of sys.certificates, sys.symmetric_keys

    Paul White (6/25/2009)

    Yeah I know what you mean - went through something similar with PCI-DSS (or whatever it was called).

    Heh. You could always upgrade to 2008 Enterprise and use...

    __________________________________________________________________________________
    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]

    July 20, 2009 at 10:23 am

    #1027127

  • RE: Backing up info of sys.certificates, sys.symmetric_keys

    Paul White (6/24/2009)

    I've never seen anything to suggest that is necessary, no.

    My favourite article for this stuff on here is http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/

    There are plenty though - search the tags if 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]

    June 25, 2009 at 7:58 am

    #1015319

  • RE: Interpreting File I/O Stats from polling sys.dm_io_virtual_file_stats

    Paul White (6/19/2009)

    You have an indication that at some points in time, your disk sub-system is unable to keep up with I/O requests from SQL Server. Whether this is...

    __________________________________________________________________________________
    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]

    June 20, 2009 at 6:52 pm

    #1012916

  • RE: CXPacket waits when creating an indexed view

    DCPeterson (6/17/2009)

    We have a few indexed views in our reporting database and have had no problems creating them...until now. I've created a new view and am attempting to create...

    __________________________________________________________________________________
    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]

    June 19, 2009 at 1:57 pm

    #1012655

  • RE: Dead LINQ - Database Weekly (Nov 3, 2008)

    I originally posted this here (http://www.sqlservercentral.com/Forums/Topic734068-361-1.aspx), but this seems like a better place for it...

    Developers at my workplace are pondering use of LINQ for their upcoming projects.

    How much should I,...

    __________________________________________________________________________________
    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]

    June 12, 2009 at 2:31 pm

    #1008897

  • RE: LINQ - How much should a DBA worry?

    Oops, I just saw these 2 links, perhaps I will carry on in the discussion on Steve's editorial instead of here...

    http://www.sqlservercentral.com/articles/Editorial/64842/

    http://www.sqlservercentral.com/blogs/andy_warren/archive/tags/LINQ/default.aspx

    __________________________________________________________________________________
    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]

    June 12, 2009 at 2:29 pm

    #1008896

  • RE: Getting info on startup parameter programmatically: "-g" flag

    andrewkane17 (6/9/2009)

    This is how management studio gets the startup params, I use this to poll our server in ssis and save the data in case of DR

    CREATE TABLE #TEMPTOAD (...

    __________________________________________________________________________________
    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]

    June 9, 2009 at 10:21 am

    #1006846

  • RE: Need system query for retrieving list of encrypted columns in a database

    Here is something I just came up with:

    --Return list of encrypted columns in current db

    select

    OBJECT_NAME(c.[object_id])

    ,c.[name] as columnName

    from

    sys.columns c

    join

    sys.types t

    on

    c.system_type_id = t.system_type_id

    where

    t.name = 'varbinary';

    How does it...

    __________________________________________________________________________________
    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]

    June 3, 2009 at 12:40 pm

    #1004231

  • RE: PowerGui Script Editor

    Wobble Chops (5/30/2009)

    I use PowerGUI Script Editor too and have the same concern. The way I get around it is to put "return 0" as the first line of...

    __________________________________________________________________________________
    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]

    May 31, 2009 at 8:07 am

    #1002489

  • RE: How current is the data contained in a full database backup?

    GilaMonster (5/30/2009)

    You could always take the DBs offline as you finish the backups. That way no one would be able to make any transactions. It may make the downtime more,...

    __________________________________________________________________________________
    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]

    May 31, 2009 at 3:02 am

    #1002465

  • RE: How current is the data contained in a full database backup?

    Carl Federl (5/30/2009)

    If all of the user databases are in full recovery mode, then full backups could be made earlier (starting at 6PM?), and then at 7 PM, only transaction...

    __________________________________________________________________________________
    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]

    May 31, 2009 at 3:01 am

    #1002464

  • RE: How current is the data contained in a full database backup?

    We are doing a critical outage tonight, and I have a 20-minute window to backup a large number of databases before our storage admin does the tape backups.

    My schedule...

    __________________________________________________________________________________
    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]

    May 30, 2009 at 4:52 am

    #1002384

Viewing 15 posts - 586 through 600 (of 1,518 total)