Viewing 15 posts - 1 through 15 (of 36 total)
Cool. Thanks for the help everyone. Much appreciated.
March 18, 2004 at 2:05 pm
Do you have an example of this? That is really cool!
March 17, 2004 at 4:25 pm
Yeah I have been thinking about that.
I do not think this code would end up on any of the actual servers. I was thinking on my local machine only....
March 17, 2004 at 1:36 pm
"An obvious issue here that needs to be addressed would be how to check (and respond to) %ERRORLEVEL% after each osql call"
I am hoping this is where the OutputTable will...
March 15, 2004 at 3:33 pm
Well we go our issue taken care of. It was not pretty. Here is the lowdown. Essentially we overloaded replication with an update that affected 7 million rows, along with...
March 15, 2004 at 9:52 am
The update did work. The problem now is that we have so many transactions that the log reader agents are timing out trying to read them. We have been on...
March 12, 2004 at 9:04 am
This is great advice.
I would be curious to know however how many environments allow people to create objects with other than DBO as the owner. In both environments where I...
March 10, 2004 at 7:19 am
What really convinced me of the speed issue was to open Profiler and watch was is going on. Get the Manager to your desk run a query 100 times that...
February 26, 2004 at 4:54 pm
On the whole every table should have a clustered index. You will want to use somewhat basic index design in deciding which fields to use for the clustered index. Here is...
February 18, 2004 at 7:45 am
The only issue I have with this approach is it makes one assumption. Each user in the organization has a network sign on. Where I currently work (today is my...
January 16, 2004 at 6:31 am
Well done. Very informative.
January 7, 2004 at 7:49 am
The first section of code does not have the commit transaction. The second one does.
Excellent article! My problem is I am the lone developer and DBA so if there is...
October 15, 2003 at 7:46 am
At work a coworker has these:
They seem pretty good. He noticed that items were not covered in the detail that tests go into sometimes, though.
Maybe a good starting...
October 6, 2003 at 9:51 am
Excellent article. If it is a group of people I really like the whiteboard approach for the very reason you stated it gets people involved. The more ideas you have...
October 2, 2003 at 5:44 am
I have to agree on this one the answer should be 8gb. From BOL
"To enable Windows 2000 Advanced Server or Windows 2000 Datacenter Server to support more than 4 GB...
September 16, 2003 at 5:59 am