meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 10 months |
| seen | May 9 at 21:12 | |
| stats | profile views | 7 |
SQL/MDX rube
|
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 suggested edit on 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. =) |
|
Jul 31 |
comment |
Is there any way to speed up a query with 3x UNION on the same large table? Remus, Andriy: Thank you both for your comments. I am a SQL newbie and have never used CROSS APPLY before. Reading the Online Help in SSMS, I don't yet fully understand what it does. Can you please provide the full syntax? |
|
Jul 31 |
accepted | Is there any way to speed up a query with 3x UNION on the same large table? |
|
Jul 30 |
revised |
Is there any way to speed up a query with 3x UNION on the same large table? added more information |
|
Jul 30 |
asked | Is there any way to speed up a query with 3x UNION on the same large table? |
|
Jul 28 |
accepted | Why does SELECT 1/2 return 0? |
|
Jul 28 |
asked | Why does SELECT 1/2 return 0? |
|
Jul 26 |
awarded | Nice Question |
