Viewing 15 posts - 1 through 15 (of 19 total)
For 15+ years my co-workers and I have supported a single-tenant system. It was originally designed for on-prem installation, which is why we could only have one client per database....
June 8, 2022 at 1:25 pm
That's too bad to hear, Rod. I think it comes down to what kind of conflict the team uses - are they debating to find the best answer, or are...
October 13, 2016 at 9:55 am
You write:
Global temp tables are used so that they will be accessible from our dynamic SQL statement, which otherwise would be out-of-scope with respect to a local temp table,...
April 15, 2016 at 7:18 am
samot-dwarf (1/14/2016)
January 14, 2016 at 7:56 am
I did see that, David. And then I started my research into how the trick itself worked, to see if I could make use of it in other places for...
June 25, 2015 at 11:07 am
It still works in 2012 (my default environment and the one in which I experimented with your code). It also works in SQL 2014. I just wanted to point out...
June 25, 2015 at 8:25 am
Very interesting resolution to a problem. I looked at your code sample with the "IF 1=0" and couldn't believe it worked. Tested it, and of course it does.
I hadn't ever...
June 25, 2015 at 7:58 am
Amen! Allow for wider screens. Restore the table of contents to the top of the document.
Glad your family is OK, Steve!
July 2, 2013 at 7:32 am
That's the config for the "Results to Grid" display. The "Results to Text" config dialog has a different setting, "Maximum number of characters displayed in each column:". The max value...
July 1, 2013 at 12:32 pm
The was (re)posted on SQLServerCentral and delivered to my inbox on the very day that I needed to examine why a 8k+ VARCHAR(MAX) dynamic SQL string was not executing the...
July 1, 2013 at 9:55 am
(sorry, duplicated after error when posting; delete doesn't work)
(I'm persistent...)
July 9, 2009 at 8:27 am
(sorry, duplicated after error when posting; delete doesn't work)
July 8, 2009 at 3:27 pm
(sorry, duplicated after error when posting; delete doesn't work)
July 8, 2009 at 2:14 pm
(sorry, duplicated after error when posting; delete doesn't work)
July 8, 2009 at 2:14 pm
Viewing 15 posts - 1 through 15 (of 19 total)