Viewing 15 posts - 3,721 through 3,735 (of 7,506 total)
Check out topic "Readme_SlidingWindow" in BOL !
With partitioning, preparation is crucial !!
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 14, 2009 at 6:43 am
The one you already have is SQL Server Profiler ! ("C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE")
Start a trace and analyse it.
3th party tools:
- Quest software : Spotlight for SQL Server
- Idera :...
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 14, 2009 at 6:35 am
As Steve said : the password doen't need to be the same;
The backup password is used to encrypt the backup itself. Nothing else.
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 14, 2009 at 12:07 am
If your business applications connect providing all possible connection info (application name, workstation id,...) ....
those non-business application connections can easily be rejected using a login trigger and only allow...
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 13, 2009 at 3:07 pm
What's your backup frequency ?
You may experience the result of IO shortage.....
If you have online index rebuilds, tempdb will be used !
This may cause read/write contention with tempdb file(s)...
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 13, 2009 at 7:13 am
In fact a snapshot db is created without any entries !
Data is only inserted if rows are modified in the originating database (or objects altered/dropped).
That's why a snapshot db only...
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 11:47 pm
No.
A shapshot only preserves the state at the moment it has been taken !
So it only contains a single truth about a row at a certain point in time.
Keep 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
May 12, 2009 at 11:31 am
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
Viewing 15 posts - 3,721 through 3,735 (of 7,506 total)