i think it's this WHERE statement:

WHERE indid >= 2 and indid = 1 would include the clustered index of each table, and certainly makes a huge difference when i ran...

to add to what Greg said, SQL server keeps a pointer for each TEXT field;

SQL server will try to store each fields data stuffed into a TEXT datatype in a...

passwords or logins?

pretty much no matter what you do, you will not be able to see passwords...it's a huge security hole if you could create a trace or trigger and...

without seeing your script, here is a common issue:

if you ALTER a table by adding a column, and then try to INSERTfeaturing that new column , an error is raised...

it's the nature of the beast; the Just-In-Time Compiler, after a restart, has to recompile any pages and put them into memory.

First time the web page is accessed, it compiles...

not sure if this is what you are after, but I often use fiddler to test web pages and see what data is being passed back and forth when...

preventing relaying to outside emails is a very common mailserver setting; my mail server will not allow relaying unless you AUTH with username and password;

the server can also allow relaying...

i think seeing a function called multiple times is normal.

wouldn't this WHERE statement:

WHERE master.sys.fn_varbintohexstr(job_id) = substring(program_name, 30, 34))

be needed to be called one time for each row in sysjobs because...

glad the example got you pointed in the right direction; did you run a trace to see exactly what the ERP is doing?

triggers are rarely affected by anything outside of...

As usual, we'd need more info..your current trigger you tried, the CREATE TABLE definition of the table, the Actual "rule" you want to use to calculate the correct price.

here's a...

I'm fiddling with this, and if we have consistent delimiters, it's REALLY easy to pull out with a tally table.

my dilemma is that it looks like multiple passes of updates...

if you are limiting to a single Id, it should be fast...you could convert the textfield to varchar(max) for the query: if it's going to scan all rows for a...

first get everything into a temp table, and make sure you convert to varchar(max)...it's a lot of trouble fiddling with TEXT datatypes.

something simply like SELECT convert(varchar(max),YourTextField) as BetterTextField,* into #tmp...

here's my guess;

as a general rule, an index which uniquely identifies a row is more valueable than an index which shows a value releated accross millions of rows.

assuming your status...

can you provide the CREATE TABLE definition for the table accservcategory ?