Forum Replies Created
Viewing 15 posts - 151 through 165 (of 7,499 total)
-
Reply To: Occasional Sql Server 2019 slowness (upgraded from 2014) -- please help...
Why did you leave it with version 15.0.2125.1 ? ( that is GDR plus a couple of security updates pior to CU1 !!! )
Current is
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data and code to get the best help- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Query Network Protocols from T-SQL or PowerShell
if you want to extract that information from the OS:
# View certificates in the Local Machine's Personal store
Get-ChildItem -Path Cert:\LocalMachine\My
# Get detailed info for a certificate by...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: DBATools in a agent job
what are the operating systems of both servers ?
if e.g. source is Win2022 and target is Win2003, chances are you may need to add 3DES to the communication protocols used...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Technology Fears
Let's see what Elon does within now and a couple of weeks or months.
I fear, technology fears will be fed and strengthend by all abuse of size/scale and the impact...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Parallel Index Operations on Azure Managed Instance
Just get a bigger truck may get this thing done $$$$
Did you validate and test other options for your single table ( 476GB ) ?
How much of that data is...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Error sub query return more than one value
Your subquery does not make sense as it is not related to the from clause of your query.
(and because it performs the same query as your from clause, it will...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: database restore chain
Just to be clear: A tail log serves the target database at the target server of your restore. ( so in case you need to restore that one back to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: database restore chain
Do not perform a Tail log backup if you just need a transaction log backup !!
A tail-log backups only purpose is that you can restore the original database as it...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: System views in a contained availability group
Did you actually prefix the correct master database ?
In that case you might as well perform a "union all"
/* contained AG master db */
SELECT 'AG1_master' SourceMaster, *...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: System views in a contained availability group
So you connect to one of the nodes of the Windows cluster hosting the Contained AG ?
( I don't know if access to master db is blocked when connecting to...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: How to determine if a DB is currently being used
Enable "auto close" for that database and monitor the sql server errorlog to see when it is being brought online.
ALTER DATABASE [Yourdb] SET AUTO_CLOSE ON WITH NO_WAIT...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Migrating standalone database to always-on cluster.
I first prepared both stand alone instances.
Then I restored the needed db on one instance, configured the needed sql accounts ( using dbatools Copy-DbaUser ) and sqlagent jobs (...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Database backup and restore questions.
- Your database needs to reside in a non-simple recovery model. ( preferable full recovery model )
You need at least create one FULL backup ( to actually activate the log...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Operand data type varchar is invalid for sum operator
did you try casting "value" to a numerical data type ?
e.g.
...
SUM(CASE WHEN [Metric] IN (...)
THEN cast([Value] as decimal(18,2)) END) AS [...],
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Reply To: Sql server 2005 cpu spiking issue
Launch a profiler trace to see what is going on
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 151 through 165 (of 7,499 total)