Viewing 15 posts - 511 through 525 (of 7,506 total)
DEVOPS is a buzzword !!!!!
Can anybody point meΒ a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO !
The only guideline you get is: "start small...
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
November 8, 2022 at 7:48 am
Why on earth would you use data type FLOAT ????Β ( especially if smallint / tinyint ) would do !
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
November 7, 2022 at 1:46 pm
Does it hold blobs ? ( of tables that reside in other filegroups TEXTIMAGE_ON yourtroubledfilegroup)
or indexes of tables/views that reside in other filegroups ?
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
November 4, 2022 at 1:22 pm
Generate your test code:
Select 'DECLARE @test VARCHAR(5) = ''β¬'';
SELECT convert(char(100),'''+name+''' ) AS DBCollation, @test collate ' + name + ' AS VarcharText;
GO
' SelectQueries
from fn_helpcollations()
where name like '%latin%'
order...
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
November 4, 2022 at 12:00 pm
have a look at "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
November 4, 2022 at 11:47 am
have a read at: "Encrypt a Column of Data"
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
November 4, 2022 at 10:43 am
Great example on how naming variables ( etc ) can be confusing and lead you totally out of focus
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
November 4, 2022 at 10:00 am
removed - you're talking SSIS ( I assumed SQL DB engine )
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
November 3, 2022 at 3:09 pm
indeed, Jeff
Sorry, Johan... I'm not sure how to take that.Β To be sure, it wasn't meant as an insult to anyone (especially you).Β You hit the nail 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
October 28, 2022 at 12:47 pm
indeed, 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
October 27, 2022 at 5:50 pm
what security context did you use when you created the linked server?

This is what my test uses. The account is dbo in my case.
btw I prefer...
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
October 27, 2022 at 5:27 pm
sys.dm_io_virtual_file_stats returns data since last startup of SQLServer.
To get what you aim for, you should persist its data yourself.
By itself that data means nothing at all.
It's only use 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
October 27, 2022 at 7:11 am
I suspect this may be an OP spam post ....
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
October 25, 2022 at 2:07 pm
What are you trying to accomplish?
Why should a UDF be able to handle that?
Check "Valid statements in a 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
October 24, 2022 at 7:02 am
Here is what I use:
-- Deadlock information analysis
Declare @Debug bit
Set @Debug = 1
Set @Debug = 0
Declare @waitresource varchar(128)
set @waitresource = 'KEY: 7:72057600361103360 (97e5c9409bc8)'
set @waitresource...
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
October 18, 2022 at 12:42 pm
Viewing 15 posts - 511 through 525 (of 7,506 total)