ModifiedBy and ModifiedOn do require triggers, but unless there's a reason to just know who changed a row without having any idea what they changed, there's probably not that...

full text is stored outside the DB as full text catalogues - they have nothing to to with clustered or nonclustered indexes

see this article to get you started

http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server

full text indexing...

mldardy (5/8/2012)

---

Well I tried something a little different with the difference formula and I get a 'Divide by zero error encountered'. This is on the bolded line below

SELECT CouncilName,...

I'm not sure if reading good suggestions from this forum would prevent many of newbies from being "promptly escorted off the premises" after interview with some of us :w00t:.

But,...

i would wager that this is faster

SELECT drm.requestid, DRM.RunningBoard,DRM.DutyBoard,DRM.DriverId,DRM.PublicServiceCode,DRM.ServiceCode,DRM.DepotCode,DRM.Direction,DRM.EOJMethod,DRM.JourneyNo,

CONVERT(datetime, MW.MessageTimeStamp,2) as MessageTimeStamp

FROM FactETMPositionRequests DRM

JOIN ETMMessage EM ON EM.ETMMessageID= DRM.ETMMessageID

JOIN MessageWrapper MW ON EM.WrapperID= MW.ID

WHERE

CONVERT(datetime, MW.MessageTimeStamp,2)...

so how many times a day is this extra 200k being read from disk? once...

Jeff Moden (5/4/2012)

---

michael vessey (5/4/2012)

---

capn.hector (5/4/2012)

---

Eugene Elutin (5/4/2012)

---

Jeff Moden (5/3/2012)

---

BWAAAA-HAAAA!!!!! Ask that question on the receiving...

Matthew Cushing (5/4/2012)

---

awesome, thanks man.

If I had another condition where a and b = us and c = null, can I just add another statement like this after the initial...

Matthew Cushing (5/4/2012)

---

I have a query that I've written that is pulling data from joined selects. I have a need to look at the results and exclude rows that...

you will need to supply more info on the stored procedure for anyone to be able to really help you - but my first question

is there the same amount...

you'll need to provide more information than that if you want people to be able to help you

first though - have you checked that SQL agent is running an that...

I'd also suggest that you have a carefull look in books online at the reference material for

set concat_null_yields_null on

set concat_null_yields_null off

these change the default behaviour of string concatenation involving...

SELECT l.Id

, MAX(CRM.dbo.fn_ConvertSFDateTime(e.CreatedDate)) AS lastevaluationdate__c

, e.ProductId__c AS lastevaluationproduct__c

FROM Customers.dbo.Evaluation__c AS e

INNER JOIN Customers.dbo.Lead AS l...

so the format of your query is

select x,y,max(z)

from mytable

where x<5

GROUP BY x,y

you must include all columns (except those you are aggregating) into the group by clause

oh - also if you have the budget for in house training then you might want to talk to a company based in Nottingham called "Quantix"

http://www.quantix-uk.com/

I worked for them for...