Johan Bijnens

Forum Replies Created

Viewing 15 posts - 496 through 510 (of 7,500 total)

Reply To: SQL help with updating table

Please provide Indexes for the tables to support whatever you want to do !!!
What did you try?
Why not just update what needs to be updated and insert what's new ?...
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 14, 2022 at 2:10 pm

#4112715
Reply To: Connecting to named instance
must be a routing issue.
Check the path ( tracert ) which your connection has to follow to be able to connect to your instance.
- router/switches/vlans/Wirewalls/...
- does it also need that...
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 14, 2022 at 10:55 am

#4112639
Reply To: SQL-Server backup performance

Double check if the target backup location hasn't been switched to a (windows) compressed volume !
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 10, 2022 at 5:48 pm

#4111056
Reply To: Non Clustered Index

Have a look at : "clustered-and-nonclustered-indexes-described"
and / or "Effective Clustered Indexes"
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 10, 2022 at 9:33 am

#4110870
Reply To: How to get ID from XML file?

There is a nice "Stairway" series about XML

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 9, 2022 at 12:31 pm

#4110482
Reply To: Split string

Did you searched SSC for a split string article ?
"Tally OH! An Improved SQL 8K “CSV Splitter” 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

November 9, 2022 at 7:48 am

#4110387
Reply To: Analyzing a huge ( more than 10600 lines )stoc proc using cte

Execute the sproc in PlanExplorer ( free tool ) to record its full execution plan en explore the marvels of that tool.
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 9, 2022 at 7:45 am

#4110385
Reply To: DevOps is Culture

Tonie Huizer wrote:
Johan Bijnens wrote:
DEVOPS is a buzzword !!!!! Can anybody point me a solid guideline how to manage legacy typed databases in a DEVOPS environment? NO ! ... Multiple projects /...
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 9, 2022 at 7:01 am

#4110372
Reply To: Transaction Logs and Service Stop

Check Shutdown

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 12:04 pm

#4110023
Reply To: DevOps is Culture

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

#4109924
Reply To: Float

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

#4109600
Reply To: Datafile full, but it isn't a table
Does it hold blobs ? ( of tables that reside in other filegroups TEXTIMAGE_ON yourtroubledfilegroup)
or indexes of tables/views that reside in other filegroups ?
- This reply was modified 3 years, 8 months ago by Johan Bijnens.
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

#4108683
Reply To: Euro Symbol and Collations
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

#4108649
Reply To: Options Window Of New Database In SQL

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

#4108637
Reply To: How do I decrypt that Data after adding Column Level Encryption

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

#4108614

Viewing 15 posts - 496 through 510 (of 7,500 total)