Viewing 15 posts - 1 through 15 (of 1,456 total)
Same, I'd love a lightning fast, small, query editor only.
The SQL Server extension in VS Code is not too bad for quick queries.
March 28, 2025 at 5:11 pm
It was strange that he was so adamantly opposed to at least upgrading the frameworks involved
Not really. If most people are happy with the way a system is working...
March 24, 2025 at 10:21 am
We all must work with technologies that are at best 15 years old.
Would upper management actually realize if you used .Net 8 instead of .Net 2? Would...
March 23, 2025 at 5:54 pm
You could also look at asking your network team to create a load balancer and then use the load balancer in the connection strings.
Once all the connection strings are pointing...
March 20, 2025 at 9:55 am
"this is not enough of an annoyance for most people to seriously start looking at something like PostgreSQL"
Most? Probably still true. But they might want to re-evaluate their over-confidence...
March 18, 2025 at 9:48 pm
We all must work with technologies that are at best 15 years old.
Would upper management actually realize if you used .Net 8 instead of .Net 2? Would they realize...
March 17, 2025 at 6:38 pm
An interesting article:
What the Decline of Sql Server Quality means for Developers and DBAs
March 17, 2025 at 8:13 am
I just want them to fix the serious performance problems that started in 2019 and they've done (apparently) nothing to fix even up 'til today for SQL Server 2022....
March 1, 2025 at 3:52 pm
You are going to have to provide a lot more detail for anyone to give you a sensible answer but, from what you are saying, this sounds more like an...
March 1, 2025 at 3:37 pm
Before you delete that data, as a minimum I would BCP it out and save it securely somewhere. Long term you might want to look at partitioning the table so...
February 27, 2025 at 8:23 am
Strong suggestion, don't store the images in the database. Can you? Yes. VARBINARY(MAX) would be the way to go. However, it really negatively impacts a whole slew of things...
February 20, 2025 at 7:51 pm
Thing is it will be in file format. I mean converted table data in to file and then moved data...but i f there is need to see the data...
February 18, 2025 at 10:49 am
dbo.clan.spouses is a 3 part name where dbo is the database, clan is the schema and spouses is the table.
Looking at your screen shot you probably want dbo.[clan.spouses], where dbo...
February 18, 2025 at 8:27 am
The error message would help but I strongly suspect it is objecting to converting 'this is a string' to numeric. Search for TRY_CONVERT().
February 16, 2025 at 10:03 pm
when I choose the Design option for the table, the new column does not appear in the design window.
I cannot help you with this as I do not use...
February 16, 2025 at 9:50 pm
Viewing 15 posts - 1 through 15 (of 1,456 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy