Forum Replies Created
Viewing 15 posts - 2,761 through 2,775 (of 59,067 total)
-
Reply To: Fixing Impostor Syndrome
IMHO, if you have Imposter Syndrome... DON'T fix it. Don't let it prevent you from speaking or writing articles but don't fix it. It's a strong driver to be the...
-
Reply To: How to calculate canceled accounts / total accounts
Johan Bijnens wrote:ps: I forgot to mention user defined table valued function "master.dbo.fn_DBA_Tally2" is an implementation of Jeff Modens "tally table" to provide a series of numbers
If it's substantially different...
-
Reply To: Backup directly to cloud storage for 1.5 tb database
Your internet speed is why I'm suggesting a local backup to a different local machine and then have that do the upload to Azure. It keeps SQL Server from having...
-
Reply To: The "Numbers" or "Tally" Table: What it is and how it replaces a loop
Nate Schmidt wrote:In the first paragraph (of the 5-Sep-2022 reposting) in the Editor's Note that there is new updated code for the Splitter Functions and then a "The New Splitter Functions"...
-
Reply To: Are You a Traffic Cop?
lianvh 89542 wrote:DBA = DO your BACKUP UPS.
Hopefully you don't think that's all a good DBA does.
-
Reply To: How do I query to exclude the "first position of a 3 digit number"
Room names are a human manifestation. There's absolutely no reason why they cannot have a room number. Hotels have also been know to change room names. If you have a...
-
Reply To: Backup directly to cloud storage for 1.5 tb database
I don't work with Azure and did some brief work with AWS. I've found it to be easier on the server to backup to on-site storage and then copy the...
-
Reply To: Performance degradation - Help troubleshooting
p.s. And don't stop trying to find out what the code is that's causing the blocking because, when these nifty hardware tricks don't work, you have to remember... "Performance is...
-
Reply To: Performance degradation - Help troubleshooting
ramana3327 wrote:The Parallelism settings for the server is below
Processors: 8
Cost threshold for Parallelism: 25 Locks: 0 Max Degree of Parallelism:0 Query Wait:-1
For the processors, is that "Physical Core" or "Logical...
-
Reply To: Are You a Traffic Cop?
This all reminds me of one of my favorite T-Shirts and it's not limited to Developers, DBAs, Project Managers, or Managers...
Remember, the...
-
Reply To: Unable to add NOT NULL constraint (Msg 102, Level 15, State 1)
Or, setup a Default and use the WITH VALUES option,
The end result is the same though. There cannot be any NULLs in a NOT NULL column.
Viewing 15 posts - 2,761 through 2,775 (of 59,067 total)