Viewing 15 posts - 1,996 through 2,010 (of 9,715 total)
Grumpy DBA (2/26/2016)
Sean Lange (2/26/2016)
You are quite welcome. Happy to share the joy. At least is isn't "All Out of Love" from Air Supply. :w00t:
Well, that's a good thing because...
February 26, 2016 at 11:52 am
Orlando Colamatteo (2/25/2016)
Brandie Tarvin (2/25/2016)
...some OLTP databases reference tables in the Reporting databases.
How many tables? I am thinking a simple Transactional Replication Publication on Server B subscribed to by Server...
February 26, 2016 at 5:33 am
TheSQLGuru (2/11/2016)
February 26, 2016 at 4:19 am
Lynn Pettis (2/25/2016)
February 25, 2016 at 9:45 am
I'll keep OPENQUERY in mind (and discuss it with the Devs) when we fix things, but it isn't going to help me now. My current sticking point is stored procedures...
February 25, 2016 at 8:55 am
Thanks, Grant. I'll look into that.
February 25, 2016 at 8:47 am
Was it indeed corrupted .mdf and .ldf files?
Regardless, I'm glad you resolved your issue.
February 25, 2016 at 8:41 am
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
Viewing 15 posts - 1,996 through 2,010 (of 9,715 total)