Viewing 15 posts - 1,936 through 1,950 (of 2,356 total)
It shouldn't.
When a cluster is setup, cluster services take over the management of anything that's been clustered. So you would want to use that to do any...
October 9, 2015 at 1:36 pm
Use cluster administrator. Take the resource offline, and back online.
October 9, 2015 at 10:49 am
You have wayyyyy too much time on your hands Steve.
October 9, 2015 at 8:54 am
Michael L John (10/8/2015)
SQLPain (10/8/2015)
For the this year Funded, approved, etc the following where statement should work correct?
WHERE c2.DateContractFunded >= dateadd(yy, 0, DATEADD(yy, DATEDIFF(yy, 0, getdate()), 0))
Yes. Look at...
October 8, 2015 at 10:44 am
SQLPain (10/8/2015)
For the this year Funded, approved, etc the following where statement should work correct?
WHERE c2.DateContractFunded >= dateadd(yy, 0, DATEADD(yy, DATEDIFF(yy, 0, getdate()), 0))
Yes. Look at your code for...
October 8, 2015 at 10:39 am
ChrisM@Work (10/8/2015)
Greg Edwards-268690 (10/8/2015)
Aggregates must first gather all results.
I am not at all surprised it is generally faster.
Many times I...
October 8, 2015 at 10:26 am
SQLPain (10/8/2015)
October 8, 2015 at 9:31 am
Same technique, these can be a series of sub-queries.
Is this the fastest execution? Probably not. Not very elegant either.
But when it come to reports, there is...
October 8, 2015 at 8:57 am
There was a good article written on Soundex http://www.sqlservercentral.com/articles/Programming/101836. You may be able to leverage this to a certain degree.
One technique that I've seen used successfully is to...
October 8, 2015 at 8:54 am
How about:
SELECT COUNT(*), Column_to_Check1, Column_to_Check2,
FROM Table
GROUP BY Column_to_Check1, Column_to_Check2,
HAVING COUNT(*) > 1
That will provide a list of duplicates based upon the columns provided.
October 8, 2015 at 8:02 am
SQLPain (10/7/2015)
October 7, 2015 at 8:14 pm
Sorry, but you are guessing at a solution. And you are probably a bit stressed right now. Those two things are a good way to turn out an...
October 7, 2015 at 2:57 pm
Nope, I actually double checked
October 7, 2015 at 2:05 pm
Try changing your code to this:
SELECT DISTINCT
C.OldDealerID
,C.NameLong
,C.NameShort
,C.MailingState
,CC.NameFirst
,CC.NameLast
,CC.Phone
,CC.FaxPhone
,MR.Name
,CC.Address
,CC.City
,CC.Zip
,C.MailingStreet
,C.MailingCity
,CC.EMailAddress
,C2.nameshort
--,(SELECT nameshort FROM channels WHERE channelid = c.assignedbranch) AS Facilitator
,C.DateLastReview
,HC.HoldingCoDescription
--Funded, Approved,Conditioned, Declined
/*,(Select Count(C2.AppID) From Channels c left join Applications a...
October 7, 2015 at 2:03 pm
Viewing 15 posts - 1,936 through 1,950 (of 2,356 total)