Forum Replies Created

Viewing 15 posts - 29,056 through 29,070 (of 49,552 total)

  • RE: Data Protection Manager and Log Shipping?

    I'm currently looking into just that for a client. So far I don't have an answer either way.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 1:46 pm

    #1258643

  • RE: SQL query log

    I don't recall having written an article on Trace. Grant wrote one that was published earlier this week and should still be on the front page. Make sure you've read...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 12:38 pm

    #1258610

  • RE: Separately indexing multiple columns for faster searching

    pdanes2 (12/3/2010)

    Although not always especially sophisticated in computer stuff, these are pretty intelligent people and a bit of explanation goes a long way with them. If the stuff they need...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 12:21 pm

    #1258595

  • RE: Need more info on the sys.* tables

    They're not tables. They're views. Use sp_help on one of them.

    They're stored in the hidden system resource database and any tables they reference are hidden system tables.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 9:32 am

    #1258506

  • RE: Permission to Create Temp Tables

    No permissions are necessary to create temp tables. Any user can, as long as they can connect to the server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 9:21 am

    #1258487

  • RE: Are the posted questions getting worse?

    Alvin Ramard (12/3/2010)

    I have a confession to make.

    While setting up WordPress yesterday, I had to create a MySQL database.

    Look at it this way. If the blog is offline with a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 9:00 am

    #1258465

  • RE: Security affects performance

    Check this, see if it maybe is what you're encountering. Shouldn't be on 2008, but never know

    http://sqlinthewild.co.za/index.php/2008/05/02/token-and-perm-user-store-growth/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 8:50 am

    #1258456

  • RE: sys.dm_db_missing_index_details - equality and inequality columns

    Equality: ColA = @A

    Inequality ColA > @A (or <, or between, or <>, etc)

    These may be of use...

    http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

    http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 6:52 am

    #1258376

  • RE: SQL Server 2005 - Database Mirroring (Change of Recovery Model)

    Please read through this - Managing Transaction Logs[/url]

    To keep the log small you need frequent log backups. Don't shrink, it's just going to grow again. The size of the log...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 6:49 am

    #1258372

  • RE: Separately indexing multiple columns for faster searching

    pdanes2 (12/3/2010)

    My point here was whether, given the constraints of no foreknowledge, will it help query performance to separately index every field that may be used in a search? It...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 6:42 am

    #1258365

  • RE: Separately indexing multiple columns for faster searching

    The point is that SQL won't always chose index intersection, it's expensive, it'll only do it if there's a fairly large row count.

    Are the queries really that random? Are there...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 2:28 am

    #1258252

  • RE: Separately indexing multiple columns for faster searching

    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 3, 2010 at 1:12 am

    #1258233

  • RE: Rollback Problem

    If you did not start an explicit transaction (BEGIN TRANSACTION) before you ran the update, you cannot roll back. If you don't start a transaction, SQL commits each statement as...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2010 at 1:59 pm

    #1258121

  • RE: ORMs and Indexes with Included Columns

    mikesigsworth (12/2/2010)

    Well the find query that I am currently optimizing is paged so it returns at most 20 rows on a 2.5million row table. So I guess by using paging...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2010 at 9:39 am

    #1257976

  • RE: index columns datatype

    Query sys.indexes, sys.index_columns and sys.columns. You'll also need a join to sys.types.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 2, 2010 at 9:35 am

    #1257974

Viewing 15 posts - 29,056 through 29,070 (of 49,552 total)