Forum Replies Created

Viewing 15 posts - 481 through 495 (of 7,506 total)

  • Reply To: cannot grant user view definition on a database

    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

  • Reply To: TEMPDB Version Store Growth when READ_COMMITTED_SNAPSHOT IS OFF

    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

  • Reply To: Struggle Bus - Varbinary(max) Performance Suggestions?

    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

  • Reply To: Restore data for a single tenant in a multi tenant DB

    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

  • Reply To: Designing Database from a piece of paper

    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

  • Reply To: Compare 2 tables and highlight where the column values has been updated

    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

  • Reply To: how to minimize prevent sql injection

    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

  • Viewing 15 posts - 481 through 495 (of 7,506 total)