Viewing 15 posts - 1,186 through 1,200 (of 7,506 total)
Please don't x-post.
This post has already been replied to: http://www.sqlservercentral.com/Forums/Topic1488317-391-1.aspx
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
September 9, 2013 at 3:39 am
of course if depends on the level of granularity of the grants for your current QA-accounts.
IMO scripting all grants may be the easiest approach.
Then, use restore db and run the...
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
September 9, 2013 at 3:36 am
it depends if the backup has been taken before the corruption occured.
One way of testing this is using Allens automation script : Test Your SQL Server Backups with PowerShell[/url]
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
September 9, 2013 at 3:17 am
As Gail stated, your "and o.type = 'abcd'" is part of the join predicate for the left join.
if you only want abcd typed rows in your result, you should move...
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
September 6, 2013 at 6:15 am
Of course it is a choice to just add a gender value and an indicator it is a value to be double checked.
Updating the current column content isn't such a...
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
September 2, 2013 at 1:31 am
Koen Verbeeck (8/28/2013)
craig.schlieve (8/28/2013)
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 7:45 am
kapil_kk (8/28/2013)
ALZDBA (8/28/2013)
if that meets the requirement, it's ok.
But what abt the scenario for which I posted the question...
How can I implement this:
Scenario is: Currently if made any changes in...
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 5:01 am
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
Viewing 15 posts - 1,186 through 1,200 (of 7,506 total)