RE: [mssms] RE: SQL Query question

2017-04-05 Thread Henry.Wilson
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

RE: [mssms] RE: SQL Query question

2017-04-04 Thread Garth Jones
:) 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

Re: [mssms] RE: SQL Query question

2017-04-04 Thread Sherry Kissinger
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? >

Re: [mssms] RE: SQL Query question

2017-04-04 Thread Sherry Kissinger
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

Re: [mssms] RE: SQL Query question

2017-04-04 Thread Sherry Kissinger
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,

Re: [mssms] RE: SQL Query question / best practice

2017-03-03 Thread Sherry Kissinger
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

RE: [mssms] RE: SQL Query question / best practice

2017-03-03 Thread Enley, Carl
...@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

RE: [mssms] RE: SQL Query question / best practice

2017-03-03 Thread Wendell Hutchison
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

RE: [mssms] RE: SQL Query question / best practice

2017-03-01 Thread Enley, Carl
. 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

Re: [mssms] RE: SQL Query question / best practice

2017-03-01 Thread Sherry Kissinger
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