I seem to remember that the first time a query is run is typically the longest... SQL server builds an execution plan and saves it on the first time; subsequent...

If it were me, I think i'd add all the product details to the actual order detail table at the time of order creation. I'd add all the relevant product...

the usual story around my shop...we have tons of desktop-type machines, with a gig of ram and a P2.0 or above processor; I can have a dozen of em if...

Pretty sure you just set it's size in Enterprise manager:

right click on tempdb in EM and choose properties....

Click the Data File tab; my db was defaulted to 8meg; changed it...

SELECT ID FROM tblProjects WHERE

 NOT (ID IN (SELECT ProjectID FROM tblLinks))

the above would return no rows if there is a ProjectId that is NULL.

change to this:

SELECT...

you will have to update the base tables;

a view is really just a saved SELECT statement. this article might help a little bit:

http://www.sql-server-performance.com/nn_views.asp

you'd most likely want to create a...

this works for me, assuming the files and the folder structure exists: I'm moving a local file to a server named DAISY. The server has a share named C_DRIVE, and...

yeah a powerful procedure like that....falling into the wrong hands...i usually keep that one locked up using the WITH ENCRYPTION statment...it's just too much for some people....

this is just another...

the built in tools work best in my opinion.

Start>>Run>>Profiler

connect to the database, and run a trace for a few hours.

stop teh trace, and save to a trace file.

open Enterprise manager,...

Remi is right; further you can create temporary stored procedures as well....so that everything is maintained in an individuals session; the combination of temp tables and temp procs would be...

default constraints are part of a column definition...so you could see them by running sp_help tablename on a table, and any/all constraints on the table would appear on the list....

if there's not much more than uppercasing and trimming the entered values, i think i'd use 10 separate statements; it depends on what kind of processing you are doing after...

gotcha; if the file is open, then Word has an exclusive file lock on the document.

The fix is to always use a COPY of the file every time...

so you might...

hard for me to grasp what we are trying to do....can you give examples of the parameters and also the expected output/results?

what does @Address contain?

why can't you just jump straight...

ahh was this web based? i didn't see that.

I can tell you the error 70 is coming from vb or asp, because there is no error 70 fro SQL server...