Reputation
206
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 13
Newest
 Yearling
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 17 votes cast
Nov
24
comment Which Azure service for use as data warehouse/analysis store?
So is that just a standard DB hosting affair, not a warehouse? Can SQL Server on-premise push data to this service directly, or does it need some intermediary software to do its thing?
Nov
20
comment Which Azure service for use as data warehouse/analysis store?
The .Net exe would just export each table as save somewhere as XML,XLSX, etc as an alternative approach.
Nov
20
comment Which Azure service for use as data warehouse/analysis store?
Thanks. Its small at present, perhaps 5mb or so for a couple of tables, but will eventually be perhaps a million or so rows across 10 tables. The target Qlikview is reporting/analytical (its a dashboard thing).
Nov
19
asked Which Azure service for use as data warehouse/analysis store?
Sep
4
awarded  Yearling
Sep
4
accepted Why would SQL Server remain unresponsive after a slow query completes?
Sep
4
comment Why would SQL Server remain unresponsive after a slow query completes?
Don't worry I've found something that helps... stackoverflow.com/questions/2554333/…
Sep
4
comment Why would SQL Server remain unresponsive after a slow query completes?
I took a look for Inline Table Valued Functions, but can't quite figure how its different to what I have now. Can you shed any light for the layman?
Sep
4
awarded  Curious
Sep
3
comment Why would SQL Server remain unresponsive after a slow query completes?
Thanks Aaron. I think you have enough upvotes these days so that your comments be preceded by the Superman theme
Sep
3
comment Why would SQL Server remain unresponsive after a slow query completes?
16Gb RAM and 1TB hard drive. I'm not sure if there's a cap; I've never applied one but am happy to check if you can tell me how?
Sep
3
asked Why would SQL Server remain unresponsive after a slow query completes?
Aug
4
awarded  Caucus
Aug
3
accepted Show all stored procedure definitions (content) for editing
Aug
3
comment Show all stored procedure definitions (content) for editing
Checks done. Largest proc was only 31,500 characters so I was well under the 65,535 limit. A lucky escape and your lesson will be well-remembered :-)
Aug
3
comment Show all stored procedure definitions (content) for editing
Well I didn't win the lottery; so here I am. Done some tests today creating massive stored proc's, and I do see the truncation, so yes I was lucky. I'm going to run your code to find the large procs, then check each one manually using Modify to see that they're all there. Thank you very much for sharing your wisdom.
Jul
31
comment Show all stored procedure definitions (content) for editing
No reason at all @MisterMagoo apart from that my tiny brain was reeling at the thought of the day ahead, and missed the simple things...
Jul
31
comment Show all stored procedure definitions (content) for editing
... If so I'm doing the lottery tomorrow night
Jul
31
comment Show all stored procedure definitions (content) for editing
Thanks @Aaron. Just to help me get my head around this... After I had pasted the results into an editor and checked for the create issue (just one occurrence), I executed the query and it completed (47,800 lines of code in all and 550 proc's compiled). I then ran an alternate query with LEN(m.definition) sorted in descending order. The largest proc was 33,222 (characters?) in size. I located that in the object browser and went to modify it. It loaded up in all its former glory; no truncation, line breaks and tabs all in tact, everything (AFAIK). Am I just being extremely lucky here?
Jul
31
comment Show all stored procedure definitions (content) for editing
Fantastic post, thank you. I ran the > 4000 script, and it pulled out about 80 proc's. When I checked one though in my orginial code, ALL of the code seems to be there (no truncation). Why would that be? In my SSMS Tools > Options, the Maximum Characters Retrieved value is 65535. Is that larger than normal (not sure I've change it a long time ago).