Click here to Skip to main content
       

Database

 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 19:57 
GeneralRe: SQL Server 2012 annoyance... Pinmember_Damian S_27-Feb-13 20:06 
GeneralRe: SQL Server 2012 annoyance... PinmemberMycroft Holmes27-Feb-13 20:47 
QuestionWhat order to be followed while generating schema upgrade script? PinmemberMember 313707826-Feb-13 18:10 
AnswerRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 20:01 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMember 313707827-Feb-13 21:40 
GeneralRe: What order to be followed while generating schema upgrade script? PinmemberMycroft Holmes27-Feb-13 22:15 
QuestionSQL weirdness when aliasing columns PinmemberGregory.Gadow22-Feb-13 11:19 
I have a method that takes a SQL query and a file name, then converts that query into an XML-based Excel file. Works great. The code gets the schema of the query, and uses the column names to generate the column headers in Excel. This, too, works great.
 
The problem is aliasing the columns into the headers that I want. I am using this notation:
SELECT
    "First Name" = view.MeaninglessColumnNameImposedBySystem1,
    "Last Name" = view.MeaninglessColumnNameImposedBySystem2, 
    "Address 1" = view.MeaninglessColumnNameImposedBySystem3,
...
FROM LongViewName AS view
WHERE etc=@etc
Whether I have one column or 50, the query takes several minutes to run; the more data, the longer it takes. If I were to use SELECT *, with no aliasing, I can return the data in a few seconds, regardless of how many rows are returned.
 
I have also tried view.MeaninglessColumnNameImposedBySystem1 AS [First Name], which does not speed up the results.
 
Presumably, this is an optimization issue where * lets SQL make assumptions that it cannot when each column is aliased. Any suggestions on what I can do with the query to speed things up?
AnswerRe: SQL weirdness when aliasing columns Pinmembergvprabu22-Feb-13 18:18 
AnswerRe: SQL weirdness when aliasing columns PinmemberMycroft Holmes24-Feb-13 13:08 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow28-Feb-13 9:09 
GeneralRe: SQL weirdness when aliasing columns PinmemberMycroft Holmes28-Feb-13 12:04 
GeneralRe: SQL weirdness when aliasing columns PinmemberGregory.Gadow1-Mar-13 5:10 
AnswerSolution PinmemberGregory.Gadow1-Mar-13 9:28 
GeneralRe: Solution PinmemberMycroft Holmes1-Mar-13 11:53 
QuestionDatabase PinmemberMember 961179522-Feb-13 8:52 
AnswerRe: Database Pinmemberjschell22-Feb-13 9:30 
AnswerRe: Database Pinmembermark merrens22-Feb-13 10:38 
GeneralRe: Database PinmemberMember 961179523-Feb-13 1:05 
GeneralRe: Database PinmemberS Douglas28-Feb-13 7:58 
AnswerRe: Database PinmemberJörgen Andersson22-Feb-13 11:11 
AnswerRe: Database PinmemberPIEBALDconsult22-Feb-13 13:38 
QuestionSQL Server + Procedure or function has too many arguments specified PinmemberHemant Thaker21-Feb-13 18:53 
AnswerRe: SQL Server + Procedure or function has too many arguments specified PinmvpSandeep Mewara21-Feb-13 19:00 
AnswerRe: SQL Server + Procedure or function has too many arguments specified PinmemberMycroft Holmes21-Feb-13 20:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.140921.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid