Viewing 15 posts - 20,776 through 20,790 (of 22,202 total)
Nice job Scott. I'm looking forward to seeing the code coming out of this effort.
March 24, 2008 at 4:05 am
I'm just unsure at this point. I tried with a larger query, 178 lines, not insane or stupid, but surely not trivial. The first time I ran it, I got...
March 21, 2008 at 12:46 pm
We're using DB Pro for all our new development and quite a few of our older systems. This is in SQL Server 2005 and 2000. We use the tool to...
March 21, 2008 at 7:05 am
The only way I know to do something like this is with a table that contains key values. You can then use IDENTITY. But, short some pretty intense triggers or...
March 21, 2008 at 6:52 am
I'm sure it has been mentioned before, but be sure you're qualifying the procedure name and using proper case on the schema, proc, and all parameters.
That said. I'm running tests...
March 21, 2008 at 6:16 am
The added value of having the perfmon files is that you can then link them up with Profiler files for some serious troubleshooting & tuning fun.
March 20, 2008 at 1:43 pm
I just got an email, we're getting our kit next week. I'll look for the sample code then. That is unless someone else posts it for you.
March 20, 2008 at 1:42 pm
Is this a plant? Are you looking to start a fight?
Well, I'll answer anyway.
My .00001 cents on this issue is, yes, use stored procedures as a standard method of development....
March 20, 2008 at 12:56 pm
I wasn't, but our local user group (SNESSUG) is hosting one of those in a couple of weeks. If no one else hooks you up, I'll get the script from...
March 20, 2008 at 12:42 pm
Adam Bean (3/20/2008)
Grant Fritchey (3/20/2008)
Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter...
March 20, 2008 at 12:19 pm
Terry (3/20/2008)
I have a PRODUCTS table which contains 2 fields: old product code and new product code.
I also have a clients table, where the old code is stored.
I would...
March 20, 2008 at 12:17 pm
Sorry, left out a bit of detail.
Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter Logs using the "New...
March 20, 2008 at 12:11 pm
I would not recommend it, but you can log directly into a SQL Server database.
Instead, I've logged out the CSV's and imported them directly to a table inside the database...
March 20, 2008 at 12:08 pm
I'm guessing something else in the code because I took your example, added a statement, and it's running just fine.
CREATE PROCEDURE [dbo].[Sp_Update_Fact] AS
BEGIN
...
March 20, 2008 at 10:56 am
DBA (3/20/2008)
the execution plan shows a couple of parallelism cost 1% and a couple of hash match cost 2%. No index scans.
That's 3% of the cost. The other 97%?
March 20, 2008 at 10:42 am
Viewing 15 posts - 20,776 through 20,790 (of 22,202 total)