Viewing 15 posts - 1,666 through 1,680 (of 5,590 total)
Koen Verbeeck (3/21/2011)
I'm glad I'm not the only Twitter noob around here 😀
It looks like there's quite a few of us jumping into this twitter thing all at once. :w00t:
March 21, 2011 at 7:45 am
Digs (3/19/2011)
Sorry wayne where do I put CHARINDEX('//',URLs)+2Can you show me the full select thanks
You would replace each of the "8"'s with that.
;with cte AS
(
SELECT URLs,
...
March 20, 2011 at 6:51 am
ColdCoffee (3/19/2011)
LutzM (3/19/2011)
Here's a slightly different approach:
SELECT SUBSTRING(URLs,8,charindex('/',URLs+'/',8)-8) AS URLsFROM @URLTable
Smart Lutz!! I dint notice that the first occurance of the slash will always be at 8 🙁
Sloppy...
March 19, 2011 at 7:34 pm
@trstringwer- excellent, and very well said!
March 19, 2011 at 7:27 pm
Sounds interesting. Looking forward to seeing this one - hurry up, will you:-)
March 19, 2011 at 6:16 pm
YES!!!!:-)
March 19, 2011 at 6:12 pm
GilaMonster (3/19/2011)
Craig Farrell (3/19/2011)
GilaMonster (3/19/2011)
Craig Farrell (3/18/2011)
Somewhere, the gods are laughing at me... I've started a twitter account.And your twitter handle is????
Was a bit nervous about throwing it out there,...
March 19, 2011 at 6:05 pm
Interesting. I have to admit that I had to try it out to see how that extra comma would work
March 18, 2011 at 9:17 pm
I just noticed this...
Of the columns in the suggested index, I don't see any of those columns at all in the DDL you posted for the table definition.
The query also...
March 18, 2011 at 11:11 am
ptn1 (3/18/2011)
Emote :BeatingHeadAgainstDesk:
:Sigh:
I get tired of all the blocked sites from work...
March 18, 2011 at 10:54 am
Well, the execution plan is suggesting that you can get a 70% improvement by adding this index...
USE [FINRISK]
GO
CREATE NONCLUSTERED INDEX [IX_T_REPORTSTATUS_Cover] -- rename as appropriate
ON [dbo].[T_REPORTSTATUS] ([ProfileName],[DomainName])
INCLUDE ([COBDate],[BookName],[SystemName],[AdapterName],[ReportName],[RerunCount],[Status],[RunNumber])
March 18, 2011 at 10:25 am
Two comments:
1. If you're going to store dates in a varchar, at least store it in YYYYMMDD format.
2. Implicit conversions can also cause poor performing queries. Say you have...
March 17, 2011 at 10:08 am
Kiara (3/17/2011)
March 17, 2011 at 10:02 am
Brandie Tarvin (3/17/2011)
"If you teach it to others, you'll remember / learn it better than if you just teach yourself on the job."
This is so true - and it's the...
March 17, 2011 at 8:08 am
CirquedeSQLeil (3/16/2011)
Craig Farrell (3/16/2011)
CirquedeSQLeil (3/16/2011)
Brandie Tarvin (3/16/2011)
CirquedeSQLeil (3/16/2011)
Buck has clothing problems.TMI! TMI!
Someone get me the brain bleach!
:sick:
Just imagine reading a string of tweets about it everyday 😀
And people say there's...
March 16, 2011 at 1:38 pm
Viewing 15 posts - 1,666 through 1,680 (of 5,590 total)