Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sobeit

  1. sobeit

    Actual SQL Stmt's character type size submitted to SQL is CHAR(8000)?

    First of all, forget for this simple question but I have no idea why the data type size of the SQL Statement being passed from the Microsoft JDBC Driver to SQL Server is different than what it should be. I have the following java codes: PreparedStatement updateTemplate = con.prepareStatement...
  2. sobeit

    Actual SQL Stmt's character type size submitted to SQL is 8000?

    First of all, forget for this simple question but I have no idea why the data type size of the SQL Statement being passed from the Microsoft JDBC Driver to SQL Server is different than what it should be. I have the following java codes: PreparedStatement updateTemplate = con.prepareStatement...
  3. sobeit

    update to database takes longer after db size has increased 10 times?

    Terry, to answer your question, the "file uploader" process in this system is set to run every 5 minutes. Basically, all it does is read in a flat file, apply business rule, and insert/update the result data into the transactional tables in the database. The goal of my test is to...
  4. sobeit

    Access ---> SQL conversion can't get update to work.

    It's obvious that T-SQL does not support the syntax. have you tried this instead? UPDATE repo SET SET repo.InvoiceNum=1064, repo.Rsoldto ='Town Business Center', repo.Rsolddate =4/30/2003, repo.Active = 'Apr 03' FROM repo R2, Quotes Where ON R2.ID = Quotes.RepoID WHERE (((Quotes.QuoteNum)=1064));
  5. sobeit

    update to database takes longer after db size has increased 10 times?

    Thanks for replying. This particular system (still in development)has an upload data utility, which takes the data from disk file and populated data into the transactional tables (i.e., Person, address, and so on). What I am testing is to see how long it will take this app to load the data...
  6. sobeit

    update to database takes longer after db size has increased 10 times?

    I have retested the application, with the same data getting updated but with database size increased (using alter database cmd, dbreindexes, and update statistics) so no db growing takes place during the transactions. The result is still the same. I even made the db 170% bigger with dummy...
  7. sobeit

    Considering DB2, but have questions?

    The questions that I have for the DB2 USB (Windows) are: 1)Security - can i use Windows Authentication but still limit certain group of users (i.e., developers) to certain databases? 2) Backup - can a complete backup be done on a database while users are using it? 3)Can the data files (database...
  8. sobeit

    HOW TO identify whether or not an index file has ever been used?

    We're using SQL Server 7.0. I like to remove any index that is not being used by any applications, but I don't want to do a profile on the database and run every possible functions in all applications. Is there a better way? Thanks!
  9. sobeit

    Advantage DB2 has over MS SQL Server?

    I agree that SQL Server is easy to use both for developers and DBAs. If there's a much better performance in DB2, then it may be worth switching. I am sure that DB2 will come up with a more friendlier user-interfaces and features for all users in future releases. Can I ask what version of DB2...
  10. sobeit

    Advantage DB2 has over MS SQL Server?

    Marc, I have worked with SQL Server for the past 28 months, both as a developer and as a DBA. Since the release of the 7.0 version, life has been much easier as a DBA. The 7.0 and the 2000 versions have some type of self-configuration features, which has given me more time to focus on other...
  11. sobeit

    DB2 Versus SQL Server

    Thanks for taking the time to read this by the way. We're a small company (less than 220 employees), and we are currently using SQL Server 6.5 - 2000 in our databases. The biggest database has a just over 5 GIGS of data, but it's growing. We are an NT shop, and main systems are written in VB...
  12. sobeit

    DB2 Versus SQL Server

    Thanks for taking the time to read this by the way. We're a small company (less than 220 employees), and we are currently using SQL Server 6.5 - 2000 in our databases. The biggest database has a just over 5 GIGS of data, but it's growing. We are an NT shop, and main systems are written in VB...
  13. sobeit

    Advantage DB2 has over MS SQL Server?

    Thanks for taking the time to read this by the way. We're a small company (less than 220 employees), and we are currently using SQL Server 6.5 - 2000 in our databases. The biggest database has a just over 5 GIGS of data, but it's growing. We are an NT shop, and main systems are written in VB...
  14. sobeit

    can anyone suggest a database performance analysis software?

    I have been using Window's Performance Monitor and the SQL Server's Profiler to examine performance problem or to evaluate execution plans. Both tools can be helpful on a very simple querries (or SP). I need tools that can point out indexes to add, most costly SPs, and I want something...
  15. sobeit

    can you query against results set from a stored procedure?

    Denormalize?...I just try not to do that, especially with some of the developers we have. They'll decide on denormalize a table without examining the bigger picture. index view would be great if we were using SQL 2000 Enterprise Edition. so what I am trying to do now is to use one more temp...
See more

Part and Inventory Search

Back
Top