Viewing 15 posts - 1,036 through 1,050 (of 2,458 total)
I do not understand at all why I get a duplicate key error, when I am modifying data in the same record previously searched, not adding a new one.
That's an...
January 20, 2016 at 12:14 pm
Based on this thread it sounds as if you are dealing with a recursive CTE and I think you've received pretty good input.
With respect to SQL Server the only...
January 20, 2016 at 7:53 am
Just finished reading this. Excellent article Ed!
Extra cudos on the clever title and the naming of #DatesOfDeath made me chuckle.
January 20, 2016 at 7:11 am
guru2007 (1/12/2016)
Any simple answer to why I was receiving null from the query I was using?
Just adding to what Eirikur said - returning a NULL is the default behavior for...
January 12, 2016 at 12:24 pm
As already stated. atomic values would be ideal but sometimes you have to play the schema your dealt. One solution would be Full Text indexing then, instead of WHERE policyid...
January 11, 2016 at 10:03 pm
Try:
select dummyxml.value('(/*:Contact/*:CustomerId/text())[1]', 'nvarchar(max)')
from [dbo].[DummyTable]
January 11, 2016 at 9:42 pm
Ok, I have a nasty fast alternative for your under performing full-text index. We're going to create what I'll call a Nindex (N-Grams Index); it involves a Tally table and...
January 11, 2016 at 7:38 pm
homebrew01 (1/11/2016)
Alan.B (1/11/2016)
Can you post the query plan that's used for this query?
Also, does that column need to be NULLable? If not can you set it to NOT...
January 11, 2016 at 1:58 pm
A few things:
Can you post the query plan that's used for this query?
Also, does that column need to be NULLable? If not can you set it to NOT NULL, run...
January 11, 2016 at 12:36 pm
Brad Allison (1/11/2016)
January 11, 2016 at 12:23 pm
Jeff Moden (1/7/2016)
Alan.B (1/6/2016)
You can't write a recursive CTE with using pre-CTE features.
Technically correct because only an rCTE can be an rCTE but the rather well advertised rave in...
January 11, 2016 at 12:14 pm
erics44 (1/8/2016)
ChrisM@Work (1/8/2016)
erics44 (1/8/2016)
ChrisM@Work (1/8/2016)
erics44 (1/8/2016)
Hugo Kornelis (1/8/2016)
erics44 (1/8/2016)
Hugo Kornelis (1/8/2016)
Jeff Moden (1/7/2016)
Alan.B (1/6/2016)
You can't write a recursive CTE with using pre-CTE features.
Technically correct because only an rCTE can...
January 11, 2016 at 12:03 pm
[font="Arial Narrow"]
SeattleDBA (1/10/2016)
Alan.B (1/4/2016)
If the FTE salary for my area is $130,000 to $140,000 for a senior level DBA, that would be about $65 (W2) per hour based on 2,000...
January 11, 2016 at 11:43 am
Good riddance, I'm a Chrome guy myself. The only time I have IE open is because some application/website that I am working with must work with IE (e.g. an SSRS...
January 11, 2016 at 10:58 am
Good stuff. I've been there.
January 11, 2016 at 8:21 am
Viewing 15 posts - 1,036 through 1,050 (of 2,458 total)