You better ask if it is okay with SQL to embrace SQL, otherwise you may be getting a call from HR. I’ve given up trying to be calm. However, I am open to feeling slightly less agitated. I’m begging you for the benefit of everyone, don’t be STUPID.

Nilesh M. Prajapati wrote: creates new database every month...Why database falls in recovery mode. My guess is that it would be due to how you 'create' it. Certainly if you start with a clean install of SQL Server (just the normal install databases) and if you run you app and it impacts that database, then yes it is specifically how you are creating it.

They couldn't run a kids lemonade stand. That was about 30 years ago. The place closed about 20 years ago. Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles. Dave Kreskowiak

It was updated two days ago: Web API - Adding Swagger, SQL Server, Logging, CORS, Export to Excel and Docker[^].

Pfff... where is excel when one needs it? :rolleyes: :laugh: M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

When you right-click on the server node in the object explorer you can go to properties and then the memory tab. There you can set a minimum and a maximum amount of server memory. Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript

Add a "row number"? [ROW_NUMBER (Transact-SQL) - SQL Server | Microsoft Learn](https://learn.microsoft.com/en-us/sql/t-sql/functions/row-number-transact-sql?view=sql-server-ver16#general-remarks) "Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

Especially when they're trying to "buy out" Compu-Global-Hyper-Mega-Net[^]. :-D "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Thanks! Very good points. The question was more about what would a datalake offer in terms of post processingand other benefits, since I am not familiar with the technology. I have no problems implementing an efficient solution with Azure/sql/c# for the foreseeable future. Just needed some insights in a tech I'm not familiar with.

You don't have to - forums here don't have a facility for that as they are discussion based rather than "Question / Answer". We have an area for those that has a "solved" indicator: Quick Answers[^] "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

I am going to guess you have an application. Users (plural) use the application not the database. The application, not the users, use the database. So there is only one user which is only visible to the application. The reason for this is because attempting to manage users both at the database and application level rapidly becomes a problem and provides no benefit. The application itself, should provide a mechanism to validate each user. Then you can do things like log actions, in the application, for each user in the database (a table for that.) The application will use the database to implement this but it does not have anything to do with database users.

Hi, I suppose that when you say target address of a hyperlink, you meant the location you are taking when you click on a hyperlink? Here is what we are trying to accomplish. We have directory on our server where several documents are stored. Then the excel file contains hyperlinks to those documents. For instance, one of the columns, called Director for example, the Director is hyperlinked Director. On the excel file, it is clearly hyperlinked and when clicked, takes you to the Files directory and Director file. There are over 600 of these records on excel. What we are trying to do is import the contents of the excel file to the database then use our .net app to display these records on our site so users can visit the site search for any title info, find it, cick the hyperlink to take him/her to the file on the server. So, after importing the file to the database, all you see now is the text Director. The hyperlink is stripped away.

😲had huge shock, thinking I had been for years thinking I knew what VBA short for, the horror of read Virtual Basic for Applications, wtf, and then checking myself that no, this writer just goofed. yeah, and now I also just realised article about MSSQL, not MySql. Makes so much more sense 🤣🤣

"every time you use sql server for more than crud then you are married to sql serve" And that is still absolutism. Which in practical programming does not work.

I haven't compared different database engines since a long time ago. On my private machine, I still use an old MS SQL Server 2008 R2 Developer edition... At my last workplace, it was mySQL - oh my, I would not like to use it again. The more I had to deal with it, the less functional it proved, even for simple CRUD stuff. More than 10 years ago, I tested huge reporting queries in many different engines - Oracle and MS SQl Server were best, followed by postgres; mysql behaved worse than MS Access... Oh sanctissimi Wilhelmus, Theodorus, et Fredericus!

What you are saying doesn't seem to make much sense - it's probably just that you are using terms like "user created" wrongly, or we are misunderstanding what the dataflow is like. What is sounds like is the user is actually creating columns which need to be added to the database along with the existing columns, rather than adding rows of data which need to be added (which is what usually happens) What I think you are trying to say is that the user adds data which needs to be stored in tables with existing data, but the user code doesn't have any access to the existing tables so you don't know how to add rows of data to it. Is that right? "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

Whoops! I guess that's why nobody else recommended that. I forgot that ORDER BY is not allowed in derived tables. I think the temporary table is probably your best option. The difficult we do right away... ...the impossible takes slightly longer.

I would not consider that to be metadata for a database row value. One of the posts above has an attribute that expands on the name from 'FName' to 'FirstName'. So that is a description and not normally significant nor critical. You can of course represent 'null' with the following idiom just as easily. With a value AColumn xxx With empty value AColumn xxx With null value AColumn If you want/need to make it explicit than the following works AColumn

atverweij wrote: You completely miss the point. Ah...you mean when the only source for learning Fortran was by reading the CDC Manual that was chained to the desk in the Operations center? Of course one could buy it for about $200 or so which was, adjusting for inflation, about $925 now. That was the only source for learning it. And it was not written for learning. Or slightly later...When I learned C++ there were only two books originally available. Stroustrup's book and then the other wasn't even for C++ but rather for Objective C. The Ellis book came out about then also but those were the only books at all. Might note also that I worked in a book store then, so I did in fact have resources that the vast majority of people did not. Yet now when I search for "C++ Programming" in Amazon I see pages of results. So no I don't think that the documentation now is worse than it was then.