Reputation
319
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 2 15
Impact
~21k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Apr
11
awarded  Popular Question
Feb
1
awarded  Yearling
Jan
28
awarded  Famous Question
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