Viewing 15 posts - 2,731 through 2,745 (of 7,502 total)
Jeff Moden (10/21/2010)
ALZDBA (10/20/2010)
Dito.And it only serves a single purpose. i.e. strict hierarchy.
Ever tried building a family tree ?
Thanks for the input, Johan. Heh... from what I've seen, 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
October 22, 2010 at 12:53 am
Nice article, Shaun.:smooooth:
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
October 21, 2010 at 9:56 am
Chances are you will get errors if you just perform "select * from table".
This doesn't mean you will not be able to pull data from that table.
Try to put 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
October 21, 2010 at 2:03 am
Paul White NZ (10/20/2010)
WayneS (10/20/2010)
@paul-2 - interesting colours on your new avatar.Thanks - it's almost summer here, so I felt like brightening it up a bit 🙂
I tought it was...
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
October 21, 2010 at 2:00 am
If an activation sproc is modified, and ssb notices that, it will put a notification in sqlservers errorlog.
Off couse, this does not cover for the generated dynamic sql.
This message will...
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
October 20, 2010 at 2:48 pm
it depends ....
have a look at Dissecting SQL Server Execution Plans
http://www.simple-talk.com/sql/performance/execution-plan-basics/
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
October 20, 2010 at 2:43 pm
GSquared (10/20/2010)
Jeff Moden (10/19/2010)
Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
The current SQL development model is to address a small number of main product features in each new major...
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
October 20, 2010 at 9:04 am
CirquedeSQLeil (10/19/2010)
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
October 20, 2010 at 1:03 am
Does the SQL errorlog mention any changes to the sproc have been detected after the queue start ?
That's how it indicates it isn't using the latest version of your sproc.
Could...
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
October 20, 2010 at 12:21 am
sqldba_icon (10/19/2010)
Can we do it without exec plan? it has some confidential data, i will try to modify and put it here. Thanks
As Leo stated, a sqlplan will not reveal...
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
October 20, 2010 at 12:13 am
Please post sqlexecution plans of both queries (saved from SSMS .sqlplan files) as attachment of your reply.
Can you also post the ddl of your view ?
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
October 19, 2010 at 3:04 pm
ref: http://msdn.microsoft.com/en-us/library/ms190411.aspx states:
Every record in the SQL Server transaction log is uniquely identified by a log sequence number (LSN). LSNs are ordered such that if LSN2 is greater than LSN1,...
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
October 19, 2010 at 2:06 pm
- Is there a print statement in your SSB procedure ?
- Is there a select statement in your SSB procedure that doesn't return its result to a variable ?
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
October 19, 2010 at 1:58 pm
jcrawf02 (10/19/2010)
...but SQL prompt saves me from that because now I just fully name everything. ....
That's very handy when you restore a db on the same server, using a different...
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
October 19, 2010 at 8:02 am
Did you ever find a solution for this issue ?
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
October 19, 2010 at 7:36 am
Viewing 15 posts - 2,731 through 2,745 (of 7,502 total)