Forum Replies Created
Viewing 15 posts - 481 through 495 (of 7,500 total)
-
Reply To: In-Place upgrades
Please do keep in mind, if in case of major DRP, starting from scratch, you could end up with a partially working engine if you just install the latest version...
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: AG failover databases go into Initializing / in recovery
Using Set HADR OFF you're telling the engine to forget the whole content of the replica !
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: 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
Reply To: Update Statistics
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
Reply To: Saving transaction backup logs off the DB server
...
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
Reply To: Saving transaction backup logs off the DB server
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
Reply To: Sysadmin can't create tables
...
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
Reply To: Sysadmin can't create tables
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
Reply To: Sysadmin can't create tables
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
Viewing 15 posts - 481 through 495 (of 7,500 total)