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 4 years, 9 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 ago by Thomas Franz.
• This reply was modified 5 years 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...

why should I do this or how would this work? If I take a single file from a filegroup offline, the data in the file will no longer accessible. And...

I'd assume that the NoSQL data model fits better for very specific approaches, where you can encapsulate a bigger part of data and assign it to a specific user etc..

Imaging...

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

I had a coworker once (luckily sitting in other room) who was a ~40 years old single and lived in a guesthouse/motel. I don't know, what he did wrong, but...

oh, I did already - about 20 questions 🙂

I hope, this will be not the next Question of the Day, but sometimes you have the value not in a binary column but in a VARCHAR (e.g. because you...

I used this behavior

• while setting a column to the MIN/MAX() result of a subquery, where I needed this value for further use in a variable too
• setting a column...

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

We can't use it either. We have an generic file loader, that searchs in the directories for new files and calls the fitting package to load the file. The (sub)package...

Counterquestion: why should it be forbitten? It does not write anything to the log, changes no data ...

I don't know how it is realized internal, but theoretical an USE [db]...

For the sake of completeness, CHOOSE() ignores errors too, until you access this value:

-- works well
DECLARE @i INT = 4;
SELECT CHOOSE(@i, 10,20,30,3.14,50,'Test', 1/0)
GO
-- returns division by zero...