Forum Replies Created
Viewing 15 posts - 946 through 960 (of 8,760 total)
-
RE: Reaping the benefits of the Window functions in T-SQL
Lynn Pettis - Friday, November 2, 2018 10:32 AMRE: Concatenate Strings in a COLUMN using comma delimiter, I need some nice code.
Lynn Pettis - Tuesday, September 18, 2018 11:22 AMmw_sql_developer - Tuesday, September 18, 2018 11:14 AMRE: Write Conflict
barry.nielson - Sunday, November 4, 2018 9:43 PMRE: TSQL query suddenly taking hours to run
Jeff Moden - Sunday, November 4, 2018 7:35 AMHe he,...
RE: TSQL query suddenly taking hours to run
First thing to test is how the query performs without the parallel execution plan, append "OPTION (MAXDOP 1)" to the query to test it.
😎
In the execution plan,...RE: view generator
I am all for generating code and the idea of exposing tables as views in a separate schema is a valid one. The problem here is that this code would...
RE: Quoting Identifiers
Sowbhari - Friday, November 2, 2018 3:59 AM
Though I chose the option that has been marked correct, think the more...
RE: Reaping the benefits of the Window functions in T-SQL
Lynn Pettis - Friday, November 2, 2018 7:52 AMRE: Quoting Identifiers
Bruceo - Friday, November 2, 2018 1:10 AMRE: Exponential values conversion
Jeff Moden - Wednesday, October 31, 2018 7:44 AMRE: Exponential values conversion
Suggest you do this in the database, here is a suggestion for a solution.
😎Note, you'll need the scale of minimum 19 as in this case =...
RE: Exponential values conversion
pwalter83 - Wednesday, October 31, 2018 4:33 AMRE: Are the posted questions getting worse?
Ed Wagner - Monday, October 29, 2018 6:33 AM
