Forum Replies Created
Viewing 15 posts - 466 through 480 (of 7,500 total)
Reply To: SELECT ROWS ON TIME CRITERIA
you are validating two unrelated columns, right?
you need to correlate starttime and endtime
e.g. by adding ' and STARTTIME < ENDTIME '
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: SELECT ROWS ON TIME CRITERIA
double post !
https://www.sqlservercentral.com/forums/topic/select-rows-on-time-criteria
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 remove special chars?
I would use datalength(v.String) so the training space at the end shows up too, so nobody checking your script actually has to doublecheck the behavior of trailing spaces.
( btw: this...
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: Missing perf-MSSQLSERVERsqlctr.ini
did you check this article "SQL Server Performance Counter are Missing"
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: Code to sum hours and minutes (varchar), 800,000 rows.
Did you try this ?
Declare @tb table ( varcharcol varchar(10) not null )
insert into @tb
values ( '23:01'),( '00:01'),( '00:02'),( '00:03'),( '22:00')
;with cteTimes as (
Select...
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: Data length greater than 4000 issue
Looking at the provided data, someone had to produce XML, but missed the moint of it
<GrpID>Group ID: 14080.</GrpID>
should in fact be <GrpID>14080</GrpID> ( unless the "." has an actual significance,...
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: Dealing with super huge table which is partially partitioned.
As you noticed, something went wrong somewhere in 2011.
Did someone forget to:
- automate for new partitions?
- removal of old data?
Anyway, Whenever I implement a partitioned table, I implement boundary constraints,...
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: LOJ followed By LOJ - What is this and is it best practices
I haven't encountered a developer yet, who wrote such a query himself, without using the "query designer".
I've seen some cases where it actually provided a performance advantage, however, I plead...
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 is ChatGPT – Is it the rise of the Skynet era?
If only it would work.
It always generates this error 
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: bcp is giving SQL State = 1000 Native error =0 SQL Server
did you also try using double quotes ? "," ( it's command line, not tsql)
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: To Drop or Not to Drop (the temp table question)
This is the link holding the part that causes your confusion:
Performance improvements in tempdb for SQL Server
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: indexes
check the "mode" parameter of the sys.dm_db_physical_stats function
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: VSS / SQLWriter sequence of warnings and error (... subset of the volumes ...)
As this is the only clustered instance which produces these warnings and errors, we suspect SentinelOne - which we are testing on one of the nodes.
We moved the instance 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
Viewing 15 posts - 466 through 480 (of 7,500 total)