"Good point. At first, it indeed looks confusing. we have documented this and hopefully expert DBAs like yourself, who may need to look at this level of details, will know how to interpret"
On the V1 thing, I think people need to understand the importance of feedback on the first releases. If they see little interest, it's unlikely to get future dev.
The sad thing about the mat.view stuff is that the theory is all there, and they've even built in into SQL Server builds, just never saw the light of day for whatever reason
I am trying CorruptionChallenge3. Where the given solution recommends to delete all the file by switching database to offline mode. I have to change the state to ONLINE with ldf file. I am unable to alter state to online.
Is it possible to alter state of database to online without .mdf file?
There's a tiny little arrow at the start of the message even on mobile. Aiming for it with fat fingers is some of the most fun you can have on the Internet.
This is my SQL Server Stored Procedure which is below:
CREATE PROCEDURE passenger_details
AS
BEGIN
SELECT Full_Name, Age, Nationality, Category, Airline_Name, Class_Type
FROM Passenger, Ticket, Airline, Class
WHERE Passenger.Passenger_No=Ticket.Passenger_No AND Airline.Airline_No=Ticket.Airline_...
That moment when you've checked in loads of code, merged it with a couple of other branches, then destroyed and recreated the dev VM.... then realise you forgot to git add a couple of new files ;(
@ypercubeᵀᴹ answering the short one first: yes, but they're two tools that cause great pain every time i use them (and, well, you can run git commands in powershell)
the problem that i have with git is similar to the problem i have with powershell though. it's not terribly intuitive, documentation is fudgey, and the learning curve for jr/infrequent users is incredibly steep
I am trying CorruptionChallenge3. Where the given solution recommends to delete all the file by switching database to offline mode. I have to change the state to ONLINE with ldf file. I am unable to alter state to online.
Is it possible to alter state of database to online without .mdf file?
