Viewing 15 posts - 571 through 585 (of 7,506 total)
With most articles, you can pose questions.
As these people have tested the subject, they may already have the answer ready or even blog about it later 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
August 2, 2022 at 7:34 am
GRANT view definition TO [uRole_ViewDefinition/useraccount];
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
August 1, 2022 at 1:57 pm
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
August 1, 2022 at 11:07 am
someone must have granted at least read to public ( for the tables ).
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
July 28, 2022 at 2:02 pm
Thank you for the feedback.
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
July 28, 2022 at 10:37 am
Your assumption is incorrect !
It needs the space, not according to backup size, but according to the size of the files of the original database !
Sequence should be:
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
July 27, 2022 at 1:45 pm
Best practice is hat match the SIDS. (or you'll have to fix that with every failover )
Easiest way to do that is do use DBATools (free)Β Copy-DbaLogin
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
July 27, 2022 at 11:12 am
You can restore any kind of db as long as you have a FULL backup (and the needed diff/log restore to get it to the PIT you need).
After the restore,...
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
July 27, 2022 at 10:58 am
why do you need to convert to char(8) ?
where CONVERT(DATE, CONVERT(CHAR(8),[WED] ))
What's the data type of your column [WED]Β ??
Rule number 1 ( with ANY RDBMS ):...
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
July 27, 2022 at 6:31 am
SELECT M.mailitem_id
, M.profile_id
, M.recipients
, M.subject
-- , M.body
--...
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
July 25, 2022 at 1:32 pm
DBownership also by the same account ? ( check when primary on instance )
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
July 25, 2022 at 1:18 pm
Read this: Author Jeff Moden - Article:Β Tally OH! An Improved SQL 8K βCSV Splitterβ Function, http://www.sqlservercentral.com/articles/Tally+Table/72993/
Example query:
SELECT ACC.ts_easeofworking
,...
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
July 25, 2022 at 6:34 am
Read this:
Author Jeff Moden - Article:Β Tally OH! An Improved SQL 8K βCSV Splitterβ Function, http://www.sqlservercentral.com/articles/Tally+Table/72993/
Example query:
SELECT ACC.ts_easeofworking
, GOM.ts_easeofworking
...
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
July 20, 2022 at 1:40 pm
If that is a business rule for your database, you should enforce it in the database. ( mainly to avoid manual mistakes )
ERD:
Drivers - id/name/...
Busses -Β id/LicensePlate/Capacity/...
DriversBussesAllocation - Date/DriverID/BusID/... -->...
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
July 20, 2022 at 12:00 pm
did you try adding an OUTER APPLY ( with e.g. DelimitedSplit8K or string_split ) to your queries to handle the multi valued column ?
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
July 20, 2022 at 11:44 am
Viewing 15 posts - 571 through 585 (of 7,506 total)