Viewing 15 posts - 481 through 495 (of 7,498 total)
did you try granting the account "view definition" on these specific databases ?
Using "any database" should indeed cover it all, but ...
use [yourdb]
create user ...
GRANT view definition...
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
January 26, 2023 at 1:32 pm
tempdb version store is always used whenever snapshot isolation is used with any query or database !
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
January 25, 2023 at 10:52 am
Most common mistake is to put data into a varbinary(max) column data is frequently needed for filtering etc.
IMHO that is not what this data type is intended for. ( with...
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
December 16, 2022 at 8:35 am
I hope your tenants don't have direct ( e.g. SSMS ) access to the database with mixed-tenant information in the objects.
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
December 1, 2022 at 1:48 pm
CustomerAcctNo DECIMAL(9, 2) ??? 1234567.02 ?
GPF DECIMAL(9, 2) ?? you expect big tanks ? 9999999.99 GPF
Rebate DECIMAL(3, 2) ?? don't you expect rabates to potentially be > 9,99
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
December 1, 2022 at 1:42 pm
have you tried Select ... from morerecenttable EXCEPT select ... from oldersnapshot
This gives you new and modified rows. Having that set, you can compare with individual columns
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 25, 2022 at 3:33 pm
don't use dynamic sql in your stored procedures! ( or use only parameterized queries with the semi generated sql )
don't grand datareader/datawriter !! Only grant exec for sprocs it 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
November 23, 2022 at 8:02 am
I would say "Yes" as it is a logged and persisted operation.
Easy to check using sys.dm_db_stats_properties for a given statistics.
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 19, 2022 at 5:37 pm
...
We only remove the old t-log backup if the new t-log backup is successfully created; othrwise we get notified with suitable message.
#Fail !!!
You need to keep all transaction log...
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 16, 2022 at 5:43 pm
And don't forget to make "compression" the default... especially when using a NAS.
That is SQLServer backup compression server level setting ( or at backup command level ) !!!
Do not...
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 16, 2022 at 7:09 am
...
Table Name: newtablename_ui84kQYrCAbhK6kvLrUyG0WXEfA
Error table name: newtablename_ui84kQYrCAbhK6kvLr
..
This indicates a bug in the marvelous software.
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 15, 2022 at 7:20 am
did you upgrade your SQLServer to its latest cumulative update? ( please 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 14, 2022 at 6:23 pm
it is a bad practice, but that doesn't mean it cannot be done.
Did you try "create table tempdb.dbo.tablename ..."
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 5:54 pm
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
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/...
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
Viewing 15 posts - 481 through 495 (of 7,498 total)