Forum Replies Created

Viewing 15 posts - 10,441 through 10,455 (of 49,552 total)

  • RE: Splitting DBs into multiple files for IO spread

    Please note: 4 year old thread (bumped by a spam post)

    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

    January 12, 2014 at 11:11 am

    #1679451

  • RE: how to differentiate between two tables sharing the same name but belonging to different databases

    Use three-part naming for your queries

    SELECT <column list> FROM Sims.dbo.Students

    SELECT <column list> FROM SimsCopy.dbo.Students

    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

    January 12, 2014 at 8:35 am

    #1679426

  • RE: Database was Unavailable

    01/10/2014 19:27:42,spid121,Unknown,A read of the file 'F:\Database\MyDB1\MyDB1MyDB1.mdf' at offset 0x000003b0670000 succeeded after failing 1 time(s) with error: 1117(The request could not be performed because of an I/O device error.). Additional...

    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

    January 12, 2014 at 8:32 am

    #1679425

  • RE: system databases moving

    When you move databases from one place to another (any database), you have to move the files, SQL doesn't automatically move files around for you.

    Looks like you may want to...

    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

    January 12, 2014 at 4:10 am

    #1679412

  • RE: Database was Unavailable

    Nothing to do with the deadlock, unlikely to be permissions.

    What does the SQL error log say? Post all messages from those 20 minutes.

    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

    January 11, 2014 at 8:14 am

    #1679371

  • RE: View with WHERE vs. WHERE referencing the view

    homebrew01 (1/10/2014)

    I am wondering if there is a performance difference if the WHERE MemberType = 'SPECIAL' is in the view, or outside in the code that uses the view:

    No.

    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

    January 10, 2014 at 2:45 pm

    #1679328

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    homebrew01 (1/10/2014)

    GilaMonster (1/10/2014)

    No, it's an unnecessary use. If the data is static during the day then there aren't going to be any X locks around to block the reports and...

    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

    January 10, 2014 at 2:44 pm

    #1679327

  • RE: Prohibit UNION queries?

    Meltdown (1/10/2014)

    I was just curious if there was a ON/OFF switch for UNION queries.

    No.

    But again, the problem is not union. The problem is SQL injection. If the code is not...

    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

    January 10, 2014 at 1:04 pm

    #1679300

  • RE: Snapshot Isolation Level - Too good to be true?

    You'll see heavier usage on TempDB, but it may not be significant depending on your workload.

    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

    January 10, 2014 at 12:49 pm

    #1679296

  • RE: Prohibit UNION queries?

    Meltdown (1/10/2014)

    Here's a few sql-injection examples being fired at the database - first three using UNION ALL.

    The vulnerability there is not the union, it's the SQL injection. Prohibit union and...

    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

    January 10, 2014 at 12:36 pm

    #1679290

  • RE: Prohibit UNION queries?

    Lynn Pettis (1/10/2014)

    Trying to figure out how a UNION (or UNION ALL) could be used to append malicious code to a SQL query. Can you provide a couple of...

    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

    January 10, 2014 at 12:25 pm

    #1679283

  • RE: DIFFERENCE BETWEEN NOLOCK VS WITH(NOLOCK) IN SQL SERVER 2008

    No, it's an unnecessary use. If the data is static during the day then there aren't going to be any X locks around to block the reports and so adding...

    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

    January 10, 2014 at 10:19 am

    #1679247

  • RE: Change data capture on log ship replica

    No, because they're not executed.

    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

    January 10, 2014 at 8:06 am

    #1679183

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/10/2014)

    I believe Gail refers to such "best practices" as "howlers". 🙂

    Not me. 'Howlers' was the title for a series of Simple-Talk articles.

    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

    January 10, 2014 at 7:32 am

    #1679167

  • RE: Change data capture on log ship replica

    sqlredcedar (1/10/2014)

    We were brainstorming with a solution to apply Transaction Log Backups to create CDC entries on a secondary database.

    That won't work. CDC uses the transaction log, reading the...

    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

    January 10, 2014 at 7:21 am

    #1679160

Viewing 15 posts - 10,441 through 10,455 (of 49,552 total)