Looks like a lot of work to build an 8-digit string that means 'yesterday', one date part at a time.

First, it determines what year was yesterday.

The part that sets the...

• This reply was modified 4 years, 8 months ago by  Eddie Wuerch. Reason: formatting

Embed your search argument in a variable, and use that in the function:

-- sample data 
CREATE TABLE #Testr(id int not null primary key, MyField varchar(128))
GO
INSERT #Testr(id, MyField)
SELECT...

• This reply was modified 4 years, 9 months ago by  Eddie Wuerch. Reason: added more comments to the code

TL;DR: just get the encryption Certificate loaded on every AG instance before encrypting, and it will just work.

TDE encryption is performed as normal transactions against a database. When you perform...

In order to protect against DST settings, just run the job 5 minutes past every hour. At the start of the job, check to see if it's the 'correct' time...

To format the SQL on-the-fly, search for 'syntax highlighter'. One I've used is the open-source GeSHi tool (https://en.wikipedia.org/wiki/GeSHi), although its T-SQL coloring was last publicly updated a while ago....

See SET LANGUAGE for setting the language SQL Server uses for the connection for system messages and month/day names:

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-language-transact-sql?view=sql-server-ver15

Instructions for installing an English-language SSMS on a non-English OS...

• This reply was modified 4 years, 11 months ago by  Eddie Wuerch. Reason: Original sample I posted was in Japanese, but the code editor barfs on Unicode :P

Also, be very protective of that Certificate. You will need it to restore backups of databases encrypted with it. The database backup will not have the Certificate; you must separately...

• This reply was modified 4 years, 11 months ago by  Eddie Wuerch. Reason: fixed a typo

"What happens if the DB is already part of AG and I enable TDE on the DB on primary? How does TDE work in that situation?"

SQL Server encrypts the database...

Define the column names of the derived table when specifying the derived table's alias:

SELECT * INTO #TEMP_Entry 
  FROM (SELECT DISTINCT 
    ...

Synology NAS devices support creating and exposing iSCSI LUNs, allowing you to map a local drive or mount a folder to the storage on the device. I have a little...

Open transactions at the time of an AG failover experience the same thing as they would when you force the database offline or the server crashes: those transactions will be...

You can only encrypt a database that exists and is fully recovered. Restore only re-paints the disk pages as it copied them from the source database.

Either encrypt the database before...

You can't reference Action values in the predicate. Here are the values on which you can filter:

-- What Predicates (fields on which we can filter) are available?
SELECT...

• This reply was modified 5 years ago by  Eddie Wuerch. Reason: Changed all JOINs in the final query to LEFT JOIN due to ALTER DATABASE commands being captured by the trace

You can solve this problem in the JOIN clause, by JOINing the tables #minmaxvals and tablea on a range:

/* matches original query, rows that match MinVal and...

String manipulation (such as concatenating lots of small strings into a big one) is messy under the covers; avoid when possible.

SQL Server treats carriage returns and line feeds as text...