Viewing 15 posts - 21,736 through 21,750 (of 39,911 total)
The hard part about profile is scaling it up. If you double or triple up the trace, you need other clients. I'd think that a tool like this would be...
November 16, 2009 at 8:34 am
Nice job, Jeff. Learned a few things myself.
November 16, 2009 at 7:33 am
Itanium is a 64 bit processor. The question did not specify x64, it merely said 64 bit windows and the software supports 64 processors. It may be nitpicking, but...
November 15, 2009 at 8:46 pm
i'd agree with George on his advice. If you want to create similar values from your old server, run a sample workload from Profiler/Trace against the new server to get...
November 15, 2009 at 2:49 pm
I would use the code that David has given you, but I'd be careful because of performance issues.
November 15, 2009 at 2:48 pm
The RAQ Report guys are getting on my nerves. I'm tempted to make an announcement that I would not recommend doing business with them as they are disruptive and not...
November 15, 2009 at 2:41 pm
Sent George a note. We'll sort him out.
November 13, 2009 at 5:22 pm
Bru is correct. You cannot share the data files for load balancing. There is a shared READ system using a SAN for Enterprise edition, but it will not work for...
November 13, 2009 at 5:16 pm
Views and stored procedures are used for two different things. A view encapsulates a single query and presents it as a table. A stored procedure is a code block.
What I'd...
November 13, 2009 at 5:14 pm
Are you returning results to users or are they doing some processing?
If not results, why not a batch file? Or very simple VB Script that gets parameters?
If they need results,...
November 13, 2009 at 11:43 am
I'm mostly with Elliot here. I've heard the issues with GUIDs and they can be a problem. The upside is that the client can generate them, which can reduce contention....
November 13, 2009 at 11:37 am
Are you calling the 2nd script from the same program? We used to add the SPID to a table, and then each call from a program could insert rows and...
November 13, 2009 at 11:32 am
I think you'll need to install a v6.5 server, attach those files, and then upgrade. If I remember right, you need to create a database in 6.5 using the correct...
November 13, 2009 at 11:28 am
It does depend, but you could take a reasonable server, say an x86 or x64 with 4GB of RAM, 2 cores, and try some common things. Maybe querying some order/order...
November 13, 2009 at 11:24 am
Viewing 15 posts - 21,736 through 21,750 (of 39,911 total)