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.

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....

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...

Adam Bean (3/20/2008)

---

Grant Fritchey (3/20/2008)

---

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...

Terry (3/20/2008)

---

Hello

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...

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...

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...

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

...

That's 3% of the cost. The other 97%?

The first query will show you all tables and all columns with uniqueidentifiers. You'll then...

Since there are likely to be more wars (unfortunately) why not set up a table of wars with the appropriate date ranges and then join against it? That way you...

Worth mentioning, did you look at the execution plan?

First off, if these are primary keys and you have referential integrity, you have a MAJOR task in front of you. Why would you want to do something like this?

Otherwise,...

I would add to the Administrative costs a very high cost to implement changes. Tune one procedure, deploy it 200 times. Modify one column, rebuild 200 tables in 200 databases...[shudder]

I...

I wouldn't have expected all those cache misses (miss's?) either. What did the test procedure do? Take a look at the link posted above to see if the test proc...