Viewing 15 posts - 61 through 75 (of 225 total)
There's no magic involved. One likely doesn't just run faster than the other. If I saw that my first impression would be that the local database is set up differently...
April 14, 2014 at 12:10 am
Grant Fritchey (4/13/2014)
I mean, not Cr or something else stupid.
And thus the challenge has been issued for the most stupid name we can come up with. tblFWB is my guess,...
April 13, 2014 at 7:35 am
I'd be more interested in the other half of the question. How will you prepare for your upgrade?
Places I've seen have no testing methodology for their LOB applications and basically...
April 11, 2014 at 6:20 am
GilaMonster (4/11/2014)
You put it in the coding standard, along with all your other good, required coding practices and require people to follow it.
So you have a document with your 1000-odd...
April 11, 2014 at 2:04 am
I'm pro-"when".
The reasoning is that if you propose security to the business as an "if" case, the answer is always, "no, that will never happen, because we're not a target...
April 10, 2014 at 11:28 pm
Ummm someone I know works on LOB applications.
They would run their application on the CTP, then the RTM, and then on the development server, and finally tell the business to...
April 10, 2014 at 10:54 pm
Grant Fritchey (4/9/2014)
Prediction? No. But following coding best practices to write queries such that they access objects in the same order
How does this come about in real life? I ask...
April 10, 2014 at 10:46 pm
Not that I know of - aside from syncing, dropping the subscription, deleting the rows, then recreating the subscription with "replication support only" (no snapshot or anything).
Otherwise you could put...
April 10, 2014 at 7:40 pm
belvdr (4/10/2014)
Definitely worth noting. For Standard, you can still use Mirroring or Log Shipping, if you can handle a delay.
You can't use secondary mirrors for reporting without enterprise edition...
April 10, 2014 at 6:27 pm
If you run the code regularly, and it fails from time to time, then wrap it in a try/catch block, and in the catch block have it insert records from...
April 10, 2014 at 7:07 am
Grant Fritchey (4/9/2014)
April 10, 2014 at 1:33 am
Jeff Moden (4/9/2014)
All good suggestions. My favorite, though, is to put the hammer on the 3rd party providing the data and get them to clean up their act.
I've never...
April 9, 2014 at 8:51 pm
OklahomaDave (4/9/2014)
P.S. Can anyone recommend a really good SQL Server internals book that really dives deep into the internals of the SQLCLR?
+1 I have looked and not found much, and...
April 9, 2014 at 8:50 pm
zz14hl1 34362 (4/9/2014)
Any and all suggestions are welcome.
75 databases x 1300 tables likely rules out replication. The overhead and management would be pretty ridiculous.
I would like to know of some...
April 9, 2014 at 8:46 pm
I have an iPad loaded with ebooks even though I prefer physical copies.
Physical copies are super expensive almost always $50+ and sometimes even higher. They very rarely go on significant...
April 9, 2014 at 8:30 pm
Viewing 15 posts - 61 through 75 (of 225 total)