Viewing 15 posts - 20,401 through 20,415 (of 22,202 total)
Speaking as a PASS volunteer who will (hopefully) get comped on admission, I'd be willing to both pay a fee AND forego prizes in favor of those who registered through...
May 14, 2008 at 6:15 am
Are the columns individually overridden? If so and you're planning on storing a sparsely populated table, I sure hope you don't have do searches on the data. Without the filtered...
May 14, 2008 at 5:40 am
It sounds like you may be on the right track. Just remember that Profiler is only going to show you what happened, not what could happen.
May 14, 2008 at 5:34 am
You could use Profiler to capture the actual execution time.
May 13, 2008 at 6:39 am
There's no way to know in advance how long a query will take. You can look at an execution plan for the estimated cost, but because of I/O contention, CPU,...
May 13, 2008 at 6:12 am
Welcome to the forums. Keep your hands and feet inside the vehicle at all times.
Performance wise, you have to reference two tables right now. Plus the fact that you can...
May 13, 2008 at 5:50 am
Yeah, OSQL will work fine. It's still back to what I said. Open a new connection, either by spawning a thread or using another executable, one you built or one...
May 13, 2008 at 5:40 am
I'm not adverse to using it, but I've only seen string parsing or complex math solutions that were clearly more viable with the CLR than with TSQL code. Get me...
May 13, 2008 at 5:38 am
I still think it all comes down to a business verification. I can't tell you how many times I've gotten the word to restore the backup for a certain date....
May 12, 2008 at 7:57 am
You should have Profiler. You can capture that.
You can also run Perfmon to capture the counters over time. Output them to a file and then you can use those with...
May 12, 2008 at 7:54 am
It's called SQL Server Agent and it runs as a seperate service on all server installs (it's not in Express or Compact).
May 12, 2008 at 6:42 am
Do these transactions include lots of data changes? You might be getting recompiles on your procedures. You'll need to follow Gail's advice and get the wait stats.
May 12, 2008 at 6:41 am
And you will need to show execution plans so that bottlenecks can be identified.
May 12, 2008 at 6:39 am
The wizard should work. You can also select all your procedures in the Object Explorer Detail window by first clicking on the Procedures folder in the Object Explorer window. In...
May 12, 2008 at 6:23 am
Viewing 15 posts - 20,401 through 20,415 (of 22,202 total)