We're using this method and the same idea with whole databases in some of our datamarts. It works well to minimize down time. Best of all, if there is a...

Having sent a few e-bombs in my time, I try hard to look at what I've written before I hit send if emotion is an attachment. Usually, if I'm completely...

Oh, you'd have to drop the connections for the ms that the query takes, but, based on the process you've defined, you're slapping the users around at some point no...

How about sacrificing a little disk space;

Create the new table with a different name

load the new table

rename the old table

rename the new table.

drop the old table

The down time is completely...

Andras Belokosztolszki (11/29/2007)

---

You can download it from Microsoft's Codeplex site http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Do read the instructions (after the install you will need to attach the extracted database files, but this is detailed...

You can get Adventureworks through CodePlex.

The 2005 version is located here.

You've got a slight syntax error. Your code should look like this:

CREATE TABLE BATCHES_LOT_DETAILS

(

[BATCHNO] varchar(15)

,[CALCULATED] char(1)

...

That last error sounds like you either aliased the table and then referred to it by name or that you dropped the table prior to that part of the script...

Or do a search in the little box near the top of the page. You'll find tons of discussions and articles and scripts on the topic, all on this site.

As far as I know, you're going to have to monitor that table. That means setting up some type of service to check the table periodically and respond to the...

Do you mean something like this:

ALTER TABLE dbo.X

ADD CONSTRAINT MyConstraint

FOREIGN KEY (aa,bb)

REFERENCES dbo.Y(aa,bb)

Like that?

BOL should give you most of what you need.

I strongly recommend using the TSQL commands to run the profiler job, not the gui. I also recommend placing the output...

I didn't see it, so I'd add the TextData column as well. Other than that, you've covered the basics.

You don't need the Profiler gui. Actually, better still if you don't have it. There are several ways you can get the scripts, including generating them locally through your own...

Gather statistics on both sides of the equation. Guessing or pointing at various bad signs won't help. You need a reasonably thorough picture of what is occurring. For example, do...