not an "automatic" way that I'm aware of;

you can make it a habit  to recompile objects on a regular basis (exec sp_recompile object name) for all procs, views and functions,...

newid() is the function most people use in order to get random order, and random counts use the rand() function.

I had to build the schema and data in order to...

just pasting some code that might be helpful: my snippets catalog named this "Find and Replace TEXT/NTEXT" this is really for when you cannot display a TEXT/NTEXT because it's more...

losts of good suggestions here...I wanted to mention that you should look at what the jobs are doing as well....maybe they can be replaced outright.

I had a similar issue where...

connection broken is typically a one time kind of error, where you lost your connection to your database, whether a cable was kicked out, an admin killed your spid, or...

you'll want to do the following:

do this on test first, and not production. I'm recommending using Enterprise manager for part of this, because it will handle a lot of the...

I had previously written a script that does exactly that...build sthe commands: try this out:

not 100% sure that this is what you want, but this is pretty close: limiting to top 100 because this can be a whopper of a resultset.

there are several scripts in the scripts section that do this:

i searched "directory exists"

Verify Directory Exists and Create if Necessary

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1463

therre are several others as well:

don't try and find the items that are no longer in the view....create the OPPOSITE of the view, and have a schedule job email you or something for every item...

i typically bulk insert EVERYTHING into a staging table, and then in the staging table i would Select * from the column where column not (like HEDR%') and not like...

On the other hand, if the applications are even slightly related, there's an advantage to having a single, unified schema though...ease of deployment and maintenance, because you need to support...

structure wise, if you were to change it all to inner joins, the execution plans would be the same, so there's no speed difference...

i think this is functionally the same...

here's an example of random letters:

select ' C7116A-'

+ char(65 + convert(int, 25 * Rand() + 1 ))

+ char(65 + convert(int, 25 * Rand() + 1 ))

+ char(65 + convert(int,...

it sounds like you need just a random number of a fixed length, which you are appending to the first 6 fixed characters.

you already identified that a random number does...