Viewing 15 posts - 1,936 through 1,950 (of 7,502 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...
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...
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...
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:
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/
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...
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...
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
...
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...
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...
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...
June 20, 2011 at 11:55 pm
please post full DDL of all involved objects ( tables, views, indexes )
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...
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...
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...
June 20, 2011 at 10:24 am
Viewing 15 posts - 1,936 through 1,950 (of 7,502 total)