Viewing 15 posts - 3,721 through 3,735 (of 7,499 total)
so that would be a rbar promotion ?
I know I'm way off, but in would a pivot help to determine the set ?
IF object_id('v_SSC_Assignment_InstructorCorse') IS NOT NULL
...
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
May 12, 2009 at 8:09 am
With a system as yours that is apparently vulnerable to fast degradation of statistics, and that doesn't perform well after the daily updatestats I would try to disable the daily...
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
May 11, 2009 at 2:23 pm
just remove @ from your connectionstring and you should be ok
If sqlbrowser service is running, you don't need to supply the port number (,13...)
Then you can remove that...
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
May 11, 2009 at 7:51 am
Have a look at :
- "Moving Large Table to Different File Group" http://www.sqlservercentral.com/articles/Administration/64275/
- "Moving Tables and Indexes to Filegroups En Masse " http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/
- "Move a table between filegroups" http://www.sqlservercentral.com/scripts/Miscellaneous/31526/
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
May 8, 2009 at 7:36 am
Such operation will be noticeble for ongoing operations !
Can you afford downtime ?
If yes,
Can you move the whole db file, or do you want just to...
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
May 8, 2009 at 6:40 am
I think in this case it is worth the try.
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
May 8, 2009 at 12:20 am
Did you perform datapurity checks after you restored the db ?
http://support.microsoft.com/kb/923247
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
May 7, 2009 at 4:11 pm
mikesigsworth (5/7/2009)
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
May 7, 2009 at 3:22 pm
As shown in my previous reply a password encrypted master key can only be modified using the path of:
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'TestEncryption31' ; -- old...
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
May 7, 2009 at 3:16 pm
So this proves you actually have NULL s in the designated date column !
Since you didn't order the first time, these rows will have been some where random in 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
May 7, 2009 at 2:56 pm
Your variables content must match the predicates conventions.
In this case the conventions for Like.
Did you test this :
SET @Value = N'%My[_]Matching[_]Value%';
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
May 7, 2009 at 2:53 pm
skjoldtc (5/7/2009)
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
May 7, 2009 at 7:14 am
[
pp.pragnesh (5/7/2009)
I totally agree with you, many of the developers are using meaningless aliasing and that would be very tough to debug in future and waste of time. even...
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
May 7, 2009 at 5:51 am
I advise to use aliasses in all queries that involve more than one table, view, ...
This is really not a comparable issue for using leading commas, upper / lower case...
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
May 7, 2009 at 1:22 am
Please test this scenario (based on my previous post).
In my test it works on the second server.
edited this warning from BOL topic "ALTER MASTER KEY"
The REGENERATE option re-creates the 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
May 7, 2009 at 12:59 am
Viewing 15 posts - 3,721 through 3,735 (of 7,499 total)