Viewing 15 posts - 136 through 150 (of 8,760 total)
Hi All,
I have table which has data with lot of CR LF, Is it possible to update that string as empty.
Quick question, what have you set as the default-character-set...
January 10, 2023 at 2:36 pm
Just a quick thought, UNION ALL without filtering (where clauses) will allocate enough memory for table and index scans, adding a filter / where clause will change some of those...
January 10, 2023 at 2:15 pm
Hi, I have this SQL fragment
SELECT COL1,
CASE WHEN Table1.COL2 = 0 then 'ZERO'
WHEN Table1.COL2 = 1 then 'ONE'
ELSE '' END AS MyResult
FROM Table1
Which is the best...
January 10, 2023 at 1:50 pm
TRY_CAST can be useful for simplifying error handling as it returns NULL rather than raising an error.
😎
Nice one Steve, maybe some people will read the documentation 😉
January 9, 2023 at 3:57 pm
We will need your help in order to be able to help you, so please help us!
😎
It would be greatly appreciated if you could provide the DDL (create table) script,...
January 9, 2023 at 2:52 pm
A question to everyone, how many times have you connected to a "known name wifi hotspot" such as Starbucks etc.?
😎
FYI: it takes less than a minute to spoof such a...
January 8, 2023 at 3:28 pm
I've been using Azure Serverless SQL Pool for a couple of months now. I don't have much knowledge on tempdb and I/O reads. I came across the following question:
You...
January 8, 2023 at 2:58 pm
I am having some kind of proprietary database with the file extension of .DSE i would like to import those in SQL Server 2019
Is there any way to...
January 8, 2023 at 2:44 pm
Heh... there's definitely a need for the art. Here are some folks that prove that...
https://samcurry.net/web-hackers-vs-the-auto-industry/
Spooky stuff.
Absolutely, little do we know!
😎
January 7, 2023 at 3:49 pm
EXEC sp_depends 'storedprocedurename'
This is a deprecated procedure.
😎
"This feature will be removed in a future version of Microsoft SQL Server....
January 7, 2023 at 3:25 pm
Suggest you start by looking at sys.sql_dependencies, sys.sql_expression_dependencies and sys.sysdepends.
😎
Here is an example of code for static t-sql code analysis (the first example I found in my repository)
January 7, 2023 at 11:32 am
Thank you our instances or VMs manged by hypervisor
Can you please elaborate a little further?
😎
What you have told us so far is as helpful as saying that you have...
January 6, 2023 at 4:18 pm
I'm on sql 2019 and I want to use static port 50010. I already set up an incoming firewall rule for port 50010 and deleted the default port 1433...
January 6, 2023 at 4:11 pm
What do you want it to do when you go to 1 more than 10.Z999 ?
Only guessing, probably a "Bottles on the wall" sequence with a twist: 09.A001 🙂
😎
January 6, 2023 at 4:01 pm
We will need your help in order to be able to help you, so please help us!
😎
It would be greatly appreciated if you could provide the DDL (create table) script,...
January 6, 2023 at 3:58 pm
Viewing 15 posts - 136 through 150 (of 8,760 total)