You can't drop the user account(s)? [not the actual login]

You can refer to previously defined CTEs in a later CTE, but you must reference it like a table, i.e. JOIN to it, since that is effectively what it is.

Did the TRUNCATE TABLE actually work? There are, of course, certain restrictions to using TRUNCATE.

Did something else in the batch fail and cause a rollback? Unlike Oracle, a...

Yep, you need to verify that the log will actually shrink as much as want before issuing the SHRINK command. That means putting the db in simple mode first.

You...

Get the free SQLIO tool and gather stats from that too. That will give you a best-case baseline for disk io (and, if the numbers aren't good/right, allow you...

You should be able to use DROP USER or sp_dropuser to get rid of users in the db, whether they are linked to a login or not.

INSERT INTO foundTable ( note_#, product_code )

SELECT n.note_#, p.product_code

FROM notesTable n

INNER JOIN productsTable p ON

n.notes LIKE '%' + p.product_code + '%'

...

Any constraints will be verified before your trigger ever gets control. Thus, you cannot handle those types of errors in a trigger.

In general, you use BEGIN TRY ... END...

Please post the valid formatting chars the existing function accepts and the expected output from sample formats.

What specifically does that mean? I'm guessing the # is zero-suppressed...

You don't actually need PATINDEX for that, LIKE will work just as well:

WHERE string LIKE ' [^ ]%' OR string LIKE '%[^ ] [^ ]%'

To paraphrase Clinton, it depends on the definition of "work". If two people have the same total,...

Don't see how you can do this w/o an ORDER BY, but it's trivial with one:

SELECT TOP 1 Name, SUM(Consumption) AS Total_Consumption

FROM tablename

GROUP BY Name

ORDER BY SUM(Consumption) DESC

Interesting code.

But can't use just do either of these:

DECLARE @result TABLE (value decimal(24, 4))

INSERT INTO @result

EXEC('SELECT 3.0 / 4 + 3.2')

SELECT * FROM @result

Or:

DECLARE @value decimal(24, 4)

EXEC sp_executesql N'SELECT @value...

Try something like:

REPLACE(REPLACE(column, CHAR(13), ''), CHAR(10), '')

Of course, CHAR(13) = cr, CHAR(10) = lf

Ah, you mean exactly as I stated in the initial comment to your q? 🙂