Viewing 15 posts - 1,186 through 1,200 (of 7,499 total)
if that meets the requirement, it's ok.
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 28, 2013 at 2:21 am
What will happen to your trigger if someone inserts data of multiple ProjectID / ProposalID / SolutionId / UnitID in a single batch ?
Keep in mind exceptions do occur !
e.g....
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 28, 2013 at 1:13 am
- I haven't played much with "merge", because of the issues with it I hear from time to time.
I think you should remove the "values" keyword before the select top...
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 28, 2013 at 1:07 am
- You are still using the deleted object in the insert trigger.
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 28, 2013 at 1:02 am
did you try the easy way ... split the trigger in two ?
1 trigger only for inserts
1 trigger only for updates
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 28, 2013 at 12:34 am
In such case, I would shrink the mdf file to an appropriate size and monitor its growth to prevent your application to go down because of the database restrictions.
If you...
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 20, 2013 at 1:18 am
SQL2008 R2 Express edition database size is limited to 10GB.
Solution?
- split the database
- drop/move some data
ref: Features Supported by the Editions of SQL Server 2008 R2 http://technet.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx#Scalability
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 19, 2013 at 11:51 pm
Sreejith! (8/19/2013)
But the files(txt,mdf,doc,excel,zip) in the 'test' directory doesn't have proper time stamp, which help us to determine whether these files has been placed in the folder for more...
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 19, 2013 at 7:55 am
Technet topic "Partitioning Unique Indexes" states:
When partitioning a unique index (clustered or nonclustered), the partitioning column must be chosen from among those used in the unique index key.
NoteNote
This restriction enables...
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 14, 2013 at 7:00 am
With linked servers, the provided logins are always SQLUsers ! ( no windows domain accounts )
I don't use linked servers to gather inventory information from my sqlserver instances.
I use...
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 14, 2013 at 5:05 am
ananda.murugesan (8/14/2013)
ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
Instead of above query, can we run as below query for make it online in MIRROR Database..? Mirror database always sychronizing/Restoring mode. wheather High...
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 14, 2013 at 3:27 am
Of course, testing it is fairly easy to do and the preferable way before implementing it into production.
Walk through all scenarios and test the actions before you need to apply...
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 12, 2013 at 5:13 am
Did you have a look at BOL ?
Forced Service (with Possible Data Loss) http://technet.microsoft.com/en-us/library/ms189977(v=sql.100).aspx
it has a ref How to: Force Service in a Database Mirroring Session (Transact-SQL). which...
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 12, 2013 at 3:48 am
1) centrainly not a good practise to use sysadmin privileges in regular aps.
(even for testing ! The sooner you encouter a security issue the better !!)
2) are you getting an...
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 12, 2013 at 3:38 am
Just my 2 ct.
You're still running SQL2008R2 RTM version.
Current is 2008 R2 Service Pack 2 ( and if you also do the CU it is on CU7 for...
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 19, 2013 at 12:51 am
Viewing 15 posts - 1,186 through 1,200 (of 7,499 total)