Viewing 15 posts - 31 through 45 (of 2,343 total)
Hello - rather new to this feature and looking for advice. So, I have existing CNAME records in our test environment that are used in the connection strings as...
March 25, 2024 at 5:15 pm
What reason do you need to rebuild these indexes?
March 11, 2024 at 10:26 pm
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...
March 8, 2024 at 10:30 pm
Seriously, why would anyone want to use this type of date? It doen't comply with any standard, can't handle seconds, and will run out of thread in the lifetimes...
March 8, 2024 at 10:30 pm
... and a few things came together recently that reminded me of you.
Oh my. I can only imagine. Any chance of you sending an email about that? ...
February 14, 2024 at 1:55 pm
Hi Steve, no reports under home and not sure why I have sp_whoisactive in monitoring
Hi Steve, no reports under home and...
January 31, 2024 at 1:54 pm
Good Stuff. There were a couple of the queries that didn't run against my Synapse instance. "can't convert to int". I had to cast some of the columns to bigints.
The...
January 30, 2024 at 1:22 pm
Scott,
Your function works but outputs in rows.
I want like this in fact:
declare @tag varchar(100)
set @tag = 'one-two-three-four'
select
upper(convert(varchar(10),ltrim(PARSENAME(REPLACE(@tag, '-', '.'), 4)))) as [Post0],
upper(convert(varchar(10),ltrim(PARSENAME(REPLACE(@tag, '-', '.'), 3))))...
January 29, 2024 at 8:25 pm
DECLARE @StringToFind varchar(256) /* String to find */
DECLARE @ObjectType char(2) /* Only look for objects of this type */
DECLARE @NumberToExtract int /* Number of characters...
January 24, 2024 at 8:47 pm
One thing, Rod, to think about is complaints or concerns about tech not being ready could be true. They could also be fear that if we stop using VS2013,...
January 5, 2024 at 3:34 pm
I could probably cause WordPress to blow up with all of the poor practices I've had to fix.
Here is the issue of the day:
We have a large Synapse instance, it's...
January 3, 2024 at 5:46 pm
Did the query you wrote produce the correct results? What was wrong with it?
December 28, 2023 at 9:45 pm
I've been setting up bare metal SQL servers since SQL 2000, and I always set the max memory to the total memory - 4GB reserved for the operating system....
December 28, 2023 at 9:41 pm
Great job on the article, really bad job on the 75% recommendation.
If there is 32 GB of RAM, then 75% is probably too high. If there is 32TB of RAM,...
December 28, 2023 at 6:59 pm
Hi!
I have successfully installed the always-on system from your current repository, and I want to thank you for that. However, while the primary database is inaccessible, I want to...
December 27, 2023 at 7:09 pm
Viewing 15 posts - 31 through 45 (of 2,343 total)