Viewing 15 posts - 1,936 through 1,950 (of 7,502 total)
what was the former db level ?
If it was 90, I'm pretty confident it will work with 100.
Did you run the upgrade adviser (sqlua) ?
It will analyze and detect...
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 24, 2011 at 3:04 pm
Jeff Moden (6/24/2011)
bitbucket-25253 (6/23/2011)
Nah we are all here sucking on those frozen beer popsicles that Jeff hordes in his freezer.
Well, if you were a dust bunnie that knew how 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
June 24, 2011 at 8:23 am
james.morrison 19355 (6/22/2011)
ALZDBA (6/22/2011)
I know people who practically know sqlserver very profound hands on, but haven't got any certs.
I also know people who are certified but don't have hands on...
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 24, 2011 at 12:47 am
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
Viewing 15 posts - 1,936 through 1,950 (of 7,502 total)