Viewing 15 posts - 2,011 through 2,025 (of 9,720 total)
TheSQLGuru (2/25/2016)
2) Review the object accesses. Some linked-server queries can be refactored for HUGE perf gains depending on if...
February 25, 2016 at 8:19 am
TANSTAAFL is big here too. Fortunately, the solution is short term. We're putting a hard date on when things need to be fixed, so no one will have any excuses.
February 25, 2016 at 8:17 am
mcopa (2/25/2016)
February 25, 2016 at 6:53 am
GilaMonster (2/24/2016)
I disagree. Jupiter is descending.
That is an awesome link. Thanks, Gail.
On another note, this might be one of those days when I should step away from my computer. I...
February 25, 2016 at 6:50 am
rhythmk (2/25/2016)
Brandie Tarvin (2/25/2016)
Hard coding based on the dates given is not wise. Ideally, code should be written to logically decide what fits either circumstance...
February 25, 2016 at 6:39 am
I forgot all about synonyms, but you're right. Not the best solution. For one, I can't create one that just points to the server.dbname. I just tried it, it doesn't...
February 25, 2016 at 6:27 am
deltajade (2/21/2016)
I was told that is an industry standard, I could delete because I have read / write access.Is this true?
I have never run into a situation where having read...
February 25, 2016 at 6:14 am
sgmunson (2/23/2016)
You might want to try CAST(PortNumber AS smallint)...
This or try to change the INT16 in expression to INT32. But yes, INT in a database comes across as INT32 in...
February 25, 2016 at 6:06 am
At a guess, I would think you need to contact Microsoft.
I don't know if this document tells you anything helpful (I haven't read through the whole thing yet). Microsoft...
February 25, 2016 at 6:03 am
What logic determines IN verses OUT?
Hard coding based on the dates given is not wise. Ideally, code should be written to logically decide what fits either circumstance depending on other...
February 25, 2016 at 5:59 am
Orlando Colamatteo (2/13/2016)
Brandie Tarvin (2/12/2016)
Because ... Excel .... SUCKS ... that way. :pinch:
I would say it as "because integrating with Excel sucks that way." It is not technically Excel that...
February 24, 2016 at 7:34 am
Alan.B (2/23/2016)
February 24, 2016 at 7:22 am
djj (2/18/2016)
February 24, 2016 at 7:12 am
mw112009 (2/12/2016)
I don't have a need to understand how SQL SERVER works. That is not a part of my job.
Honestly, if knowing how SQL Server works is NOT part...
February 12, 2016 at 11:27 am
So what smtp stuff are you logging? IIS stuff? Or database mail?
February 12, 2016 at 11:16 am
Viewing 15 posts - 2,011 through 2,025 (of 9,720 total)