194 reputation
114
bio website
location
age
visits member for 2 years, 5 months
seen May 9 '13 at 21:12

SQL/MDX rube


Sep
24
awarded  Autobiographer
Aug
22
awarded  Popular Question
Jul
2
awarded  Curious
Apr
1
awarded  Popular Question
Aug
14
awarded  Nice Question
Jul
10
awarded  Notable Question
May
21
awarded  Popular Question
Jan
17
awarded  Popular Question
Oct
19
comment Query tuning help needed (Hash Match and Table Scans)
Aaron Bertrand: Regarding your second suggestion, the presentation layer (Cognos) seems to lack the ability. SQL Kiwi: I will upload the sqlplan in short order.
Oct
19
awarded  Commentator
Oct
19
comment Query tuning help needed (Hash Match and Table Scans)
Thank you all again. Once I create the recommended index, do I have to do anything else (one-time, periodically, etc.)? Does the index get updated automatically when table/s is/are refreshed (everyday)?
Oct
18
awarded  Custodian
Oct
18
reviewed Approve Query tuning help needed (Hash Match and Table Scans)
Oct
18
comment Query tuning help needed (Hash Match and Table Scans)
Thank you all for your comments. I can't add indexes because the DBA isn't allowing me to. The baseline runtime is 90-odd minutes to return ~8k rows. FMI: Can someone tell me whether the 'Impact' value in the Index suggestion text should be higher or lower?
Oct
18
asked Query tuning help needed (Hash Match and Table Scans)
Aug
1
comment Questions about handling NULLs and empty strings in nvarchar and numeric fields
D'oh... yet another case of post-lunch midday blindness. Also, just to be sure, I tried INSERT #foo SELECT 'M', ''; and it gives me the same 8114 error. Thank you for the education. =)
Aug
1
accepted Questions about handling NULLs and empty strings in nvarchar and numeric fields
Aug
1
comment Questions about handling NULLs and empty strings in nvarchar and numeric fields
Aaron, to answer your question on the parent post, isn't the third INSERT above inserting an empty string '' in a numeric field?
Jul
31
asked Questions about handling NULLs and empty strings in nvarchar and numeric fields
Jul
31
comment Is there any way to speed up a query with 3x UNION on the same large table?
Andriy, the two examples return different rowcounts. The UNPIVOT example returns one less row than the CROSS JOIN example. What could be the possible reasons? EDIT: It is because CROSS JOIN has a NULL record, whereas the UNPIVOT example does not. =)