Viewing 15 posts - 256 through 270 (of 430 total)
Hot damn, Lynn, that's awesome. Attached plans from running on my actual table. I'm expecting data for 13 more countries, so I'll compare again when I have everything.
Is there a...
November 24, 2013 at 8:30 am
Luis Cazares (11/19/2013)
Here's a more concise way to do it. You can update the table by updating the CTE.;-)
Put this on the list of things I'm mad I didn't know.
November 22, 2013 at 10:42 am
Hi Gary,
No problem. It just seemed like one of those tasks that PS is very suited to, and I thought there might be a neat trick to it. Thanks for...
November 15, 2013 at 8:15 am
I finally figured something out:
$files = ls "\\drive\S*" -recurse -Include *.txt |
foreach-object {
copy $_ "\\Drive\Erik"
}
The rest of what I was doing is this:
Get-Content C:\path\*.txt | Out-File C:\path\whatever.txt -Encoding Unicode -Width...
November 14, 2013 at 5:43 pm
dwain.c (11/4/2013)
Jeff Moden (11/4/2013)
dwain.c (11/4/2013)
Jeff Moden (11/4/2013)
shashianireddy (11/4/2013)
sql 2008 version ,,nvarchar(MAX)
You're using NVARCHAR(MAX) for a housenumber???? In SQL Server 2008???? Why?????
You probably don't release it but you cannot rebuild...
November 7, 2013 at 2:52 pm
Sean Lange (11/7/2013)
erikd (11/7/2013)
Louis Hillebrand (11/7/2013)
The WHERE filter on 3 * the same character to start (REPLICATE(LEFT(t.name,1),3) + '%')
and secondly on starting with...
November 7, 2013 at 2:33 pm
Louis Hillebrand (11/7/2013)
The WHERE filter on 3 * the same character to start (REPLICATE(LEFT(t.name,1),3) + '%')
and secondly on starting with a character between...
November 7, 2013 at 1:45 pm
I suppose I can let it slide this time, since I posted the question before thinking about about it for a minute. I was not thinking outside the brackets, and...
November 7, 2013 at 12:38 pm
mickyT (11/7/2013)
Seeing your previous post, you could change it slightly to
select *from (values (1,'blah blah'),(2,'bllaaahh'),(3,'blahhhh'),(4,'bbbblah')) s (id, name)
where name like replicate(substring(name,1,1),3) + '%'
That might perform better.
That is snappy. I...
November 7, 2013 at 12:21 pm
Yeah, I tried the same thing at first. This seems to work:
case when substring(name, 1, 3) = replicate(substring(name, 1, 1), 3)
Though I'm sure there's something that performs better. 😉
November 7, 2013 at 12:02 pm
Awesome article. I particularly like using NULLIF to check the search parameters.
Also a reminder that I wish the display more than 8k characters SQL Spackle were default server behavior....
November 5, 2013 at 1:10 pm
Grant Fritchey (11/4/2013)
I must have meant to just clean up the code. It's actually not a major...
November 4, 2013 at 12:38 pm
I understand that it's more succinct code (and apparently more performant?). I guess I'm trying to figure out a situation where I'd have to build an insert like that, especially...
November 4, 2013 at 11:21 am
Viewing 15 posts - 256 through 270 (of 430 total)