Viewing 15 posts - 38,896 through 38,910 (of 39,466 total)
There are load testing tools from Rational and Quest software, but they can be expensive. Some vendors also "rent" the tool for a test.
Steve Jones
November 19, 2001 at 7:47 pm
You have to manually format it. You can use a table to do this or a complex select statement. If you post what you want, we can try to help...
November 19, 2001 at 7:45 pm
November 19, 2001 at 7:43 pm
There are a few things that can happen. Check the stored procedure in QA. Does it still take 40min?
If so, try sp_recompile on the stored procedure and re-run it....
November 19, 2001 at 3:53 pm
I am not sure what you mean. Can you provide more informaiton, maybe some sample data?
Why not use a CASE statement for the warehouse? I am confused as to why...
November 19, 2001 at 3:37 pm
What about checking syscolumns, information_schema.columns, or even sysobjects.
Steve Jones
November 19, 2001 at 3:36 pm
I am not sure of what else would cause a failure on the SQL side. Networking of course, must be up. If security changes, then that could cause an issue....
November 19, 2001 at 3:33 pm
Keep reading on this site. We are all a collection of DBAs and try to provide guidance and advice.
Please also feel free to email any of the authors and let...
November 19, 2001 at 3:32 pm
November 19, 2001 at 3:30 pm
November 19, 2001 at 1:28 pm
Don't know if this is a problem as I don't use replication that much. I'll ask around.
Steve Jones
November 19, 2001 at 1:28 pm
On this page:
http://www.microsoft.com/sql/howtobuy/pricing/default.asp (check out the CE section before licensing)
Looks like you can download it, but licensing is similar to the MSDE.
Steve Jones
November 19, 2001 at 10:36 am
Checked through BOL. Only shows EM and DMO as auto solutions.
For DMO: Here is the section from BOL.
Script Method
The Script method generates a Transact-SQL command batch that can be used...
November 19, 2001 at 10:33 am
Interesting debate. Haven't ever admin'd Oracle, though I did develop against v7.
Personally, it has almost always come down to cost for my companies. Oracle has been substantially more expensive. The...
November 19, 2001 at 10:26 am
It has been problematic for me. In VI 6, there were bugs with managing stored procedures. I heard these were ironed out, but haven't checked it since SP3.
Also, it only...
November 19, 2001 at 10:20 am
Viewing 15 posts - 38,896 through 38,910 (of 39,466 total)