Recent content by sobeit

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...

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...

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...

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));

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...

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...

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...

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!

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...

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...

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...

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...

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...

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...

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...