Forum Replies Created
Viewing 15 posts - 661 through 675 (of 10,143 total)
-
RE: how to optimise a view having 3 to 4 derived tabels.
rajemessage 14195 - Thursday, July 6, 2017 7:52 AMRE: how to optimise a view having 3 to 4 derived tabels.
Quick suggestion: convert it into an inline table-valued function. They work like a parameterised view.
Other than that, as Eirikur says, way too little information.RE: Are the posted questions getting worse?
jonathan.crawford - Wednesday, July 5, 2017 8:05 PMRE: Cross Apply Timing Out on Large (1bn rows) Table
SirWittles - Monday, July 3, 2017 10:18 PMRE: Are the posted questions getting worse?
Happy holidays to our wonderful neighbours across the water, celebrating Brexit 1776!
RE: Please help me with a complex SELECT
salardx - Friday, June 30, 2017 6:17 AMHi, I got a table like this:
i need to convert it to a...
RE: MAX MIN OR SUB-QUERY
53 people have looked at your post and none have replied.
It's very difficult to determine exactly what you want as your result, significant language problem here.
Can you...RE: SQL Select
CREATE TABLE #Table1 (Item VARCHAR(5), Code VARCHAR(5))
INSERT INTO #Table1 (Item, Code) VALUES
('Item1', 'code1'),
('Item1', 'code2'),
('item2', 'code3'),
('Item2', 'code4')CREATE TABLE...
RE: How to identify the position of the nth occurance of character in a string
@awais_487It was an interesting exercise at the time 🙂
Mark Cowne's solution is far more efficient. If you wish to...RE: More problems with SQL 2014's new Cardinality Estimator
julian.fletcher - Thursday, June 29, 2017 9:30 AMRE: More problems with SQL 2014's new Cardinality Estimator
Both of those execution plans indicate that SQL Server baulked at the task of generating a decent plan from such a complex query (ReasonRE: Help needed in resolving dead lock
RohitK25 - Wednesday, June 28, 2017 12:52 AMRE: Query Taking too long to execute when filter on geography data (STContains,STGeomFromText)???
vineet_dubey1975 - Tuesday, June 27, 2017 6:40 AMRE: Parallelism (Repartition Streams) 55% in exec Plan, can I fight it ?
roshithkooleri - Monday, June 26, 2017 3:48 AMRE: Are the posted questions getting worse?
Eric M Russell - Saturday, June 24, 2017 8:24 PMViewing 15 posts - 661 through 675 (of 10,143 total)
