in EMEA.
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Sherry Kissinger
Sent: Tuesday, April 04, 2017 12:37 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: SQL Query question
I was thinking Henry was just asking a "in general, which sql
:)
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Sherry Kissinger
Sent: Tuesday, April 4, 2017 12:37 PM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: SQL Query question
I was thinking Henry was just asking a "in general, which sql query
I was thinking Henry was just asking a "in general, which sql query s!cks
less". the fact that the subselect was using .net in there was just
coincidence.
On Tue, Apr 4, 2017 at 7:57 AM, Garth Jones wrote:
> Is there a reason why you are not using the MOF edit for this?
>
ceviewer -- I look at that all the time to see what was the longest running
collection (the last time). I also have a couple of reports which can tell
me which collections took > xx seconds to run, and via SRS then I link to
another report about "everything I know about that collection that I
Neither. I'd use this one. resourceid is resourceid is resourceid. there
is no reason to join sms_r_system in the subselect itself. Extra work for
SQL, and not needed. We've done this type of 'not in' subselect lots of
times.
select
SMS_R_SYSTEM.ResourceID,
SMS_R_SYSTEM.ResourceType,
ull Sql version.
>
>
>
> Any idea if it would be covered under the CM license?
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Wendell Hutchison
> *Sent:* Friday, March 3, 2017 11:12 AM
> *To:* mssms@lists
...@lists.myitforum.com] On
Behalf Of Wendell Hutchison
Sent: Friday, March 3, 2017 11:12 AM
To: mssms@lists.myitforum.com
Subject: RE: [mssms] RE: SQL Query question / best practice
Use Express. It is free and if you are only storing/sharing data it will work
for your purpose.
From: listsad
istsad...@lists.myitforum.com] On Behalf Of Enley, Carl
Sent: Wednesday, March 1, 2017 1:25 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: RE: [mssms] RE: SQL Query question / best practice
Thanks for all of the replies, I was thinking the same thing about not l
. Would this secondary
SQL server be required to have the Config Mgr client installed
Thanks
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Sherry Kissinger
Sent: Wednesday, March 1, 2017 10:29 AM
To: mssms@lists.myitforum.com
Subject: Re: [mssms] RE: SQL
I agree with Troy--setup a replica database. We have two "classes" of
people that desperately feel they need access to our data. For 1 set, the
replica is what they get, and it works perfectly for their needs. There's
another set of people who, through mainly political maneuvering, convinced
10 matches
Mail list logo