In this situation I would write 10000 records of data to a file from the client and then bulk insert the file into a temp table via a sproc. Then...
Programmatically take a backup of the database and restore the database under the new name DEV_2 "How do you expect to beat me when I am forever?"
I do not recommend the file approach. I think you will have disk issues that you will have to contend with, maybe not right away, but eventually....
Are these databases on the same machine, or on different machines? If they are on different machines, then I would guess that linked servers would...
It depends on how you use Access as a front-end. If you use Access as a front-end similar to VB, meaning that use use VBA code to use ADO to...
Be careful with DBCC PINTABLE, it can be useful, but it can also hurt you as well. "How do you expect to beat me when I am forever?"
I have found the SHRINKFILE functions to be very frustrating at times. This is what I do and I hope one of the other forum members can verify if...
Sorry about that gaurav_bindlish, I misread. "How do you expect to beat me when I am forever?"
http://www.sqlteam.com/item.asp?ItemID=8318 "How do you expect to beat me when I am forever?"
If you are referring to the time allowed for the query to run, this is not the connection timeout property. You need to look into the CommandTimeout...
Look at System.Diagnostics.Process class for .NET "How do you expect to beat me when I am forever?"
I am interested in dumping data out of a database real-time. I know triggers are one way of doing this, but I was interested in another. I know of...
What I have come to realize is that when an article or person says that ORDER BY is bad, or any SQL statement is bad for performance, they are saying...
It is better to do your transaction processing in SQL Server, as you have noted you have had some problems with ADO transactions, and so have I. I...
Windows 2000 without any service packs comes with MDAC 2.5 "How do you expect to beat me when I am forever?"
This doesn't sound like it would model well in a relational database. If you know C++, you might want to consider building an in-memory database...
The ASP page uses OLEDB+ADO. I will look at the execution plans an capture it via the Profiler for the ASP page. Only one stored procedure, I...
I have a web application that uses ASP, VB COM and SQL Server 2000. When I run a specific stored procedure with the ASP calling application, the...
If you want to randomly pick rows, then you can use the TOP statement select TOP 10 * from table1 where cod = 10 "How do you expect to beat me...
I agree with satya on the cleanup of the registry, since it is known that SQL Server can sometimes leave the registry in an unclean state. "How do...
Separate names with a comma.
