Nice, but it would be nicer, if I could also search for

• functions as CONCAT_WS(), STRING_AGG(), APPROX_COUNT_DISTINCT(), TRIM(), TRANSLATE()
• OPTIMIZE_FOR_SEQUENTIAL_KEY (Index option for faster inserting MANY rows with increasing key)

...

• This reply was modified 4 years, 6 months ago by Thomas Franz.

@jeff - but both it is linked together 🙂

@Jeffrey: of course I'd cluster your table by PatientID, DocID too. But when you are not a very new hospital 99.x% of...

• This reply was modified 4 years, 7 months ago by Thomas Franz.

Stupid question, but why are some people use a low fill factor as 70 or 80%, I'm usually fine with something as 95-98 (or even 100 if it is on...

Nice article, but I think it could need a second follow up article

• In your example you created the certificate by yourself (you = SA).
• The reason for Always Encrypted...

I manage a big DWH database (about 12 TB). Of course (for this size) the database is partitioned. The biggest tables have their own set of annual filegroups (e.g. FG_ORDERS_2019,...

we are saying, that #1 and #3 are correct, not #3 and #4.

LEAD with descending order is the same as LAG with ascending order (except that the returned rows are...

@scott: The question, if they should cluster for it or not depends, how else this table is used. Yes, 2,400 deletes per day may be a lot, but when they...

regarding the clustered index recommentation:

you do not necessary have to cluster your table by MyTime. When MyTime is ascending too (e.g. the creation timestamp) you may e.g. simply selecting the...

• This reply was modified 4 years, 12 months ago by Thomas Franz.

The link is broken, but I guess, that VS Raavi refers to

https://dataginger.com/2013/05/14/does-sql-server-agent-service-startup-account-must-be-sysadmin/

Even when it's title says, that is about SQL Agent service account, the article refers to both, the SQL...

Before they are going to add new features, they need to do some very basic stuff to the agent (don't know, if they had only an underpaid junior developer to...

Regarding to your script:

• instead of the bloating CASE statment for the latest_access, you could simply use a short subselect that you "call" via CROSS APPLY after the latest INNER...

It does not help you in any way to add an identity column to your heaps, it will just add a useless information / memory + disk space (beside the...

• This reply was modified 5 years, 1 months ago by Thomas Franz.

at https://www.microsoft.com/en-us/download/details.aspx?id=39046 you can download the Kerberos Configuration Manager for SQL Server. It helped me a lot with all this SPN stuff, since it finds out by itself, which entries...

• This reply was modified 5 years, 4 months ago by Thomas Franz.
• This reply was modified 5 years, 4 months ago by Thomas Franz.

Regarding SQL Versions and restore to older versions: the "assuming no new keywords are used" would be a bad sign for a new version.

I don't care about all the fancy...

I think triggers can be agood. On the database of my previous employer we had tons of triggers to ensure business logic. Of course you could argue, that it should...