Viewing 15 posts - 3,901 through 3,915 (of 19,560 total)
GilaMonster (2/5/2014)
MinhTuCSharper (2/5/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 10:24 am
Koen Verbeeck (2/5/2014)
Being a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 10:17 am
Kurt W. Zimmerman (2/5/2014)
BWFC (2/5/2014)
Kurt W. Zimmerman (2/5/2014)
Ed Wagner (2/5/2014)
BWFC (2/5/2014)
SQLRNNR (2/4/2014)
tokeDraw
Shoot
Skeet
Clay
Pot
hemp
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 10:07 am
There are plenty of top notch people that have specialized in various things with SQL server. Even with that, there is a lot to learn and plenty of effort...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 10:06 am
EXCELLENT cartoon.
Love that cartoons are coming back to SSC.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 9:15 am
Gary Varga (2/5/2014)
I hope that is not...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 5, 2014 at 9:14 am
That would mean that you have other urls that do not fit the patterns you have provided. I couldn't tell you what is different not having much of a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 10:55 pm
Not sure I fully understand your question.
But if you mean replace everything after the ? with an empty string, then it wouldn't be very useful or efficient. You typically...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 10:34 pm
Of that small sample set, the following is throwing a curveball
/trwmjh.asp?Info=m/Txnxt1AKNvdWkS
The issue is the / that comes after the ?. Is this a valid url?
In any case, this should...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 10:26 pm
Are you able to handle those NULL values in the query for the datasource for this report? Changing that NULL to a different value such as 0 is a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 9:51 pm
You probably have some null values in the table. Or you have some urls that do not fit that pattern.
Having a sample set of data would have helped to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 9:42 pm
Well this should work for you
DECLARE @blah TABLE (someblah VARCHAR(256))
INSERT INTO @blah
VALUES ('http://www.xyz.com/region/department.asp?FID=8907')
SELECT REVERSE(SUBSTRING(REVERSE(someblah),CHARINDEX('?',REVERSE(someblah),1)+1
,CHARINDEX('/',REVERSE(someblah))-CHARINDEX('?',REVERSE(someblah),1)-1))
FROM @blah
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 9:24 pm
Can you provide a little more information such as the table structure and 20 or so sample records for this table?
Having this kind of information is extremely helpful in being...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 9:10 pm
Do all of these URLs have the ? following the asp? Or do you have different page extensions too such as htm html asp etc?
That information will play into...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 9:08 pm
That would pretty much be it. That is a fairly basic overview of it - but I think you are getting the gist.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 4, 2014 at 5:06 pm
Viewing 15 posts - 3,901 through 3,915 (of 19,560 total)