Viewing 15 posts - 1,801 through 1,815 (of 7,499 total)
side note on DBCC DBREINDEX in books online :
Important:
This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development...
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 1, 2011 at 12:56 am
my car consumes 9L/100km.
Is that good ?
Maybe, maybe not.
That depends on the kind of car, track, payload,...
What I mean is, without the query, table structure, available indexes, number of rows...
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 31, 2011 at 11:51 pm
GilaMonster (7/31/2011)
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 31, 2011 at 12:41 pm
- Online only works with EntEdtn / Devedtn / eval edtn ( and not in all cases ... see bol)
- couple of guidelines in msdn: http://msdn.microsoft.com/en-us/library/ms189858.aspx
- bol:http://msdn.microsoft.com/en-us/library/ms188388.aspx
How it works:...
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 31, 2011 at 12:26 pm
Here are two little articles that can help you throwing some light on your log "problem".
http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
If you still want to proceed with your current handling after reading these, you just...
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 30, 2011 at 7:23 am
0
Please elaborate as Gail requested.
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 30, 2011 at 7:14 am
Gianluca Sartori (7/30/2011)
Jeff Moden (7/29/2011)
Gianluca Sartori (7/29/2011)
I'm inaugurating my "Vote for Jeff" signature. 😎
BWAA-HAAAA!!!! VERY cool, Gianluca. And, Uncle Sam is my favorite patriotic character to boot!
The 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
July 30, 2011 at 3:10 am
you may also want to add your purge script, used every 16h to let us have a look how you are trying to do it.
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 28, 2011 at 8:57 am
How about just recording key data with a trigger to a staging table, then have a sqlagent job launch your SSIS job through an alert ?
Have a look at http://www.sqlservercentral.com/scripts/Miscellaneous/31032/
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 28, 2011 at 5:50 am
Nice tests Gianluca !
However, regarding the performance impact for this quest compared to a trigger should be the same.
(b)locking will be part of the game with either solution, so support...
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 27, 2011 at 3:26 pm
SQLRNNR (7/27/2011)
ALZDBA (7/27/2011)
Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
I just want you to know
I want...
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 27, 2011 at 11:22 am
Steve Jones - SSC Editor (7/27/2011)
I don't control the announcement. I assume it will be a business day or two afterward.
I just want you to know
I want to hear...
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 27, 2011 at 11:16 am
Ninja's_RGR'us (7/26/2011)
On another note, the only safe backup I know is the one I've successfully restored and then ran an error-free checkdb() on it. ...
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 27, 2011 at 4:03 am
Are you refering the Oracle rollback segments ?
In sqlserver that information is stored in the database log file(s).
Pre-size it as much as you can, but if you chose 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
July 27, 2011 at 1:36 am
As stated, the restore puts the database back as it was at the time the backup has been created.
( files, file size )
However, you can move the files using 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
July 27, 2011 at 1:27 am
Viewing 15 posts - 1,801 through 1,815 (of 7,499 total)