Where do you need RegEx? LIKE is supporting it currently, so the only other point could be something like REPLACE (but I never needed it for REPLACE).

They already added some...

Regarding the OPTION RECOMPILE:

It would help only, when you change your WHERE to something as

WHERE (ISNULL(@ForumName, '') <> '' AND tbo.ForumName LIKE @ForumName + '%')

OR (ISNULL(@SurName,...

A drawback of having the Jobs in the database would be, that - when you restore the database as _test, _dev or whatever, those jobs would be started and this...

@steve-2: What would you do regarding the column order, when you are facing a CREATE OR ALTER <table> statement and the column order differs from the real. Recreating could be...

Yes, and doing this you drop...

I doubt, that an ALTER OR CREATE <table> would be used commonly, particularly since a CREATE table will usually need some indexes, FKs, CHECK CONSTRAINTs and some other stuff too.

Furthermore...

Who do you blame for the lack of snow, Obama or Trump :hehe:?

PS: Happy holiday.

But it would be a little...

Indianrock (9/16/2016)

---

I use xp_cmdshell in sql jobs, but turn it on before the action and turn it off after. The one that comes to mind is using DIR to...

I'm missing BULK EXPORT.

Another point: even if you can do some OS-like stuff with SQL Server, the account that runs...

I think the risk is reasonable, as long you are using an xp_cmdshell_proxy_account with minimal privileges.

On the other side it would nice, if SQL Server would provide us with more...

If he would have written a book, than he would have written it on a PC with Word or on a typewriter (if he is conservative).

I don't believe that even...

~95 km; Bonn (Germany); once a year (in June)

You are right, if I declare the year column (and the partition function) with BIGINT instead of SMALLINT the implicit convertation will work and it scans only one partition

when I have to sent passwords per email, I try to include neither the username nor the app / site that uses the password and tell the person what it...