Forum Replies Created

Viewing 15 posts - 30,346 through 30,360 (of 49,552 total)

  • RE: collation change impact

    Drikus Roux (9/26/2010)

    It would seem that your collation clash is between the SQL database collation and that of a field stored by the Windows operating system.

    Or more likely...

    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

    September 27, 2010 at 12:18 am

    #1227528

  • RE: Best SQL query

    abcim (9/27/2010)

    (Note: The third one will use Top 1 so that it will not fail(only fails if no rows are present))

    In which case it will perform absolutely terribly as you'll...

    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

    September 27, 2010 at 12:13 am

    #1227525

  • RE: Best SQL query

    Best for what?

    Performance? The first two will be the same, dunno about the third, should be very close.

    Readability? I'd say the second.

    Validity? The third will fail if there's more...

    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

    September 27, 2010 at 12:03 am

    #1227521

  • RE: I need some help with a test, please.

    Urrrr... R2 did not get installed this weekend. Don't know when I'm going to get to 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

    September 26, 2010 at 11:52 pm

    #1227516

  • RE: Are the posted questions getting worse?

    WayneS (9/25/2010)

    (Been relaxing all week - sorry this is belated.)

    CONGRATULATIONS Gail! SSC is a much better place with you!

    Thanks.

    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

    September 26, 2010 at 11:51 pm

    #1227515

  • RE: alter database is not happening in sqlserver 2000

    Nope.

    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

    September 25, 2010 at 5:32 am

    #1227370

  • RE: alter database is not happening in sqlserver 2000

    The ALTER DATABASE ... MOVE was not an option for any database other than TempDB on SQL 2000.

    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

    September 25, 2010 at 2:57 am

    #1227353

  • RE: ReIndexing without Log File Growth

    No issues.

    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

    September 25, 2010 at 2:54 am

    #1227352

  • RE: Database

    I'm guessing that you have little to no experience writing windows or web applications?

    Maybe work through the tutorials here: http://www.asp.net/get-started

    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

    September 25, 2010 at 2:52 am

    #1227351

  • RE: SQl Query performace

    abcim (9/25/2010)

    Whether here i use single composite index or single index for A,B and C or something else?

    Something else. You want the minimum number of indexes that will satisfy all...

    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

    September 25, 2010 at 2:47 am

    #1227348

  • RE: Transaction Log file size grows exponentially after maintenance Job ?

    YeePee (9/24/2010)

    May be that is my problem. I have large table called transactions with 6 million records in it. So how can I run the maintenance plan...

    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

    September 24, 2010 at 11:59 am

    #1227157

  • RE: "Continuous" backup via VSS? Performance Issues?

    Brandie Tarvin (9/24/2010)

    That's why I think this tech is the basis of database snapshoting and mirroring.

    Snapshot, yes (copy-on-write). Mirroring, 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

    September 24, 2010 at 11:14 am

    #1227140

  • RE: SQL Server 2005 32 Bit Version on Windows Server 2008 R2 x64

    Roger Abram (9/24/2010)

    Thanks... we don't own the SQL Server 2005 64 bit version. Just the 32 bit version.

    You don't buy a licence for SQL 2005 x86 or SQL...

    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

    September 24, 2010 at 11:13 am

    #1227138

  • RE: How to troubleshoot performance issues?

    Firstly, don't reply on autogrow. If you know the DB is growing, manually increase the size of the files to a sensible value.

    These may help in finding the problems.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    September 24, 2010 at 11:09 am

    #1227134

  • RE: SQL 2005 SP3 crashes :(

    anish_ns (9/24/2010)

    I have also set the max server memory for SQL server to be 64GB. SQL is also x64 and we are also running Analytical Services on the same server.

    You're...

    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

    September 24, 2010 at 11:09 am

    #1227132

Viewing 15 posts - 30,346 through 30,360 (of 49,552 total)