Forum Replies Created
Viewing 15 posts - 796 through 810 (of 7,499 total)
-
Reply To: Sql error log?
We always use
-- switch sqlserver logfiles (errorlogs)
EXEC msdb.dbo.sp_cycle_errorlogand
EXEC msdb.dbo.sp_cycle_agent_errorlog;
We do this in a single SQLAgent job, but in 2 steps, configured so they...
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: Agree or Lose Features
What disturbs me more is the fact that "will never share information" gets thrown overboard.
MS baught Whatsapp for its technology.
Instead of rebranding it to MSwhatever, they opt to keep the...
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: Monitor SQL Server Agent Jobs No Longer Executed
keep min mind, a disabled job can still be fired using sp_start_job !
( it will just not be started by its coupled schedules or alerts )
Just in case you let...
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: Understanding CRUD Operations Against Heaps and Forwarding Pointers
Nice article !
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: Help with detecting and sending alerts for lengthy blocking
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: Filtering a hierarchy-related query
What have you tried ?
hierarcyId may have looked to be an interesting option, but ....
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: Columnstore or not to columnstore?
here is a nice ref:
by Brent Ozar
https://www.brentozar.com/archive/2020/10/want-to-use-columnstore-indexes-take-the-columnscore-test/
or direct https://columnscore.com/
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: Are the posted questions getting worse?
Spot on, Jeff ! ??
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 backup for big database in 4 steps
Oh BTW, On top of compression, you may also want to fiddle around with following settings to see what works best for you !
--Media Set Options
...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: Top 5 by user query
This may be a start
;With cteSel as (
Select cUser, dDate, rank() over ( partition by cUser Order by cUser, dDate desc) UserDateRank
from #tmp_UserDates
)
Select distinct *
from cteSel
where...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 backup for big database in 4 steps
Jeff Moden wrote:.... Compressed backups are only available in the Enterprise Edition for production environments (and Developer's Edition for development/testing environments)....
Compressed backups are available on every edition except Express Edition !...
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: admin account and pwd
SSMS-Setup-ENU.18.8.exe /Passive DoNotInstallAzureDataStudio=1 /install /quiet /norestart /log SSMS_install.log
ref: last line of this paragraph
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: Rounding to 0
Did you try
select convert(decimal(22,2), Case when Sum(@q *COALESCE(NULLIF(COALESCE(@Weight, 0), 0), 0.01)) < 0.01 then 0.01
else Sum(@q *COALESCE(NULLIF(COALESCE(@Weight, 0), 0), 0.01))
end )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: What to expect on first day of PL SQL at new firm?
That is a concern you should have expressed during the interview.
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: Are the posted questions getting worse?
If you want it to be interpreted correctly ... ask your MS representative.
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 - 796 through 810 (of 7,499 total)