Forum Replies Created

Viewing 15 posts - 196 through 210 (of 824 total)

  • RE: The Pitfalls of Foreign Keys

    Now I'd love to see that!  Especially since the highest TPC benchmark ever achieved by SQL Server is 1.2 Million per minute and that was using a 64 CPU Itanium...

  • RE: The Pitfalls of Foreign Keys

    I have built systems in SQL Server that processed more than 2.5 million transactions per hour with DRI.  That was on 32 bit hardware and SQL 2000, and the system...

  • RE: How to upgrade from June CTP to release?

    You've basically got it.  I had to remove every last trace of the CTP before I could get the install to work properly.

  • RE: The Pitfalls of Foreign Keys

    My thoughts exactly.  It isn't a fair comparison. 

    I have a major problem with even the premise of the question though.  If you are just concerned with throughput, then don't...

  • RE: SQL Server 2000 Clustering for load balancing

    Yes, and No...  Microsoft Clustering provides ZERO load balancing capabilities for SQL Server, however, you could create an "active/active" cluster with some sort of partitioning or replication between them and...

  • RE: SQL Server 2005 Review

    The things that you are used to doing in earlier versions are generally not a big problem in 2005, since MS did a pretty good job of keeping it backward compatible. ...

  • RE: SQL 2005 system tables

    No, MS finally gave us a usable set of system views in 2005 and removed the ability to directly query or change the system tables.  As I understand it, even...

  • RE: Database Size?

    You need to do some serious reading...  There are tons of posts here and Books Online has complete information on that subject.

    However, the short answer is that if you don't...

  • RE: Database Backup?

    You can restore a database from a full backup (what you are creating) but if you aren't backing up the transaction log you will not be able to restore to...

  • RE: Execution Plan In SQL Server 2005

    See the article entitled "How to: Save an Execution Plan in XML Format" in BOL

  • RE: Rights in Sql Server 2005

    About the only way to control row level rights is through views.  If you create a view that returns only rows that meet certain criteria, then grant a user permission...

  • RE: SQL 2005 system tables

    You can't manually update statistics on the system tables.  Frankly I can't think of a reason you'd need to.

  • RE: SQL Server 2005 Review

    Based on our testing, we are moving all new project development to 2005.  Our current products will migrate individially as new releases come out. 

    We are well into development of...

  • RE: sql 2005 (x64) --> sql 2005 (x86) environment

    Databases can be transfered back and forth between 64bit and 32bit servers the same way that they are between two 32bit servers... 

  • RE: Advanced Protecting DataBase

    While virtualization is fine for development and testing environments (as long as you aren't trying to run benchmarks) I would never run a producton SQL Server on a virtual machine. ...

Viewing 15 posts - 196 through 210 (of 824 total)