Johan Bijnens

Forum Replies Created

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

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, 7 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
Reply To: Select into variable table name

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

#4108604

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