Viewing 15 posts - 1,936 through 1,950 (of 7,499 total)
Studying the matter is always a good thing.
Keep in mind you'll need to combine it with hands on experience as well.
I know people who practically know sqlserver very profound hands...
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
June 22, 2011 at 2:46 pm
Steve Jones - SSC Editor (6/22/2011)
PASS is not doing any welcoming thing, but Andy and I are thinking to try and do a welcome mixer/dinner/drinks back down on Pikes Peak.
Count...
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
June 22, 2011 at 1:26 pm
Steve Jones - SSC Editor (6/21/2011)
Just an update, the horse looks good. Vet came today, said there will be a scar, but full recovery expected.
Good to hear.
Did you find 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
June 22, 2011 at 6:29 am
:crying: No promo code
:crying: No party ?? :ermm:
:smooooth: I hope there will still be the welcoming lunch initiative like last years near the Pike place market :kiss:
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
June 22, 2011 at 6:09 am
for more info on the appy operator have a look at http://www.sqlservercentral.com/articles/APPLY/69953/
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
June 21, 2011 at 1:48 pm
jcrawf02 (6/21/2011)
GilaMonster (6/21/2011)
jcrawf02 (6/21/2011)
GabyYYZ (6/20/2011)
Well, MVP is the highest official accolade from MS
Not sure that's true, MCM would rank higher than MVP, I would think. Depends what you're measuring, I...
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
June 21, 2011 at 1:37 pm
Is any one of you using a gui to help with powershell script dev ?
btw
- I'm using Powershell ISE which shows me results
- I'm using Quest PowerGUI editor ( free...
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
June 21, 2011 at 11:03 am
I'm sorry to have overlooked you already had the identity property in use :blush:
Performance may be an issue it you don't have an index for the seqnumber column
Select T.Itemnumber
...
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
June 21, 2011 at 10:49 am
Lynn Pettis (6/21/2011)
Really?? (different person). Hope I wasn't too harsh in my reply.
What .... you were to lazy to copy / paste the data and check if your code...
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
June 21, 2011 at 12:26 am
Strange.
-- stub for the non-parameterized version, plan for the parameterized version
SELECT usecounts, cacheobjtype, objtype, [text]
FROM sys.dm_exec_cached_plans P
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
WHERE [text] NOT LIKE '%dm_exec%'
ORDER...
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
June 21, 2011 at 12:20 am
What OS are you on ? ( + sp/hf please )
What's the version info of your sqlinstance ?
Can you elaborate on the topology of your lefthand solution ?
Are the luns...
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
June 20, 2011 at 11:55 pm
please post full DDL of all involved objects ( tables, views, indexes )
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
June 20, 2011 at 11:40 pm
A child table should only refer to the full PK of its parent table. (or another AK is allowed in sqlserver)
as you state you PK of tblSurvey is composed of...
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
June 20, 2011 at 2:21 pm
Just read at Bob Beauchemin'd blog:http://www.sqlskills.com/blogs/bobb/post/Performance-features-in-SQL-Server-2008-RC0-Optimize-for-Adhoc-Workloads.aspx
"stub for the non-parameterized version, plan for the parameterized version"
Could you check/confirm that ?
edited: copied wrong ref.
This was RC0. should have been optimized by now...
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
June 20, 2011 at 1:48 pm
please post the sqlserver errorlog file !
You need to elaborate a bit more regarding your move operation :
- did you shutdown the instance ?
- did you copy the folder structures...
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
June 20, 2011 at 10:24 am
Viewing 15 posts - 1,936 through 1,950 (of 7,499 total)