What Gail said really sums it up. 😉

Brandie Tarvin (8/11/2016)

---

Recently I noticed some of my code has the warning "Operator used tempdb to spill data during execution with spill level 1." I have a few questions on...

To alleviate the SARGability problem with the "WHERE CAST(RequiredByDate AS DATE) BETWEEN @StartDate AND @EndDate" solution Drew and I provided you could create an indexed view like so:

CREATE VIEW dbo.vw_TempDate

WITH...

Consider this query:

DECLARE @StartDate DATETIME;

DECLARE @EndDate DATETIME;

SET @StartDate = '20160801'

SET @EndDate = '20160805'

SELECT startdate = @StartDate, enddate = @EndDate;

Results:

startdate ...

cmullen77 29296 (8/10/2016)

---

Hey Alan,

That was my point.. I had an issue running an update statement, so I started eliminating rows to figure out what was causing my problem. ...

http://www.scarydba.com/2015/03/12/monitoring-timeouts/%5B/url%5D

cmullen77 29296 (8/10/2016)

---

Okay, I MUST be missing something;

update EmpActions set isactive = 'N' where 1=2

When I run this, my MS SQL server goes to about 33% and just...

is250sp (8/10/2016)

---

I have a table with the following records.....

emplid effdt effseqjobcode

00001068 3/27/200500241

00001068 ...

sam 55243 (8/10/2016)

---

Hi All,

I'm using stored procedure where i'm getting role Id in comma separated values and i need to check for specific role id in that. Im using charindex...

Depends on what kind of DBA (operations, application, all of the above), how junior...

shambhavi13 (8/10/2016)

---

I am pretty satisfied with the NGrams8k solutions you gave . The results are accurate and since I only have to deal with one candidate at a time the...

shambhavi13 (8/9/2016)

---

Yeah no doubt the below solution you gave is the fastest of all .. but after testing it on few resumes it doesn't seem to give exact count ..

SELECT...

Alternatively you could parse those strings into individual words and create a search table that would avoid the scan problem, but that is probably a lot more work than just...

Using my sample data from earlier, the best way would be like so:

SELECT...

J Livingston SQL (8/4/2016)

---

ALan....consider the following please

DECLARE @tblResumeTag TABLE ( int identity primary key, TextVersion varchar(8000));

INSERT @tblResumeTag(TextVersion) VALUES

('I accelerated the development of the system by making rationale decisions based on...