Viewing 15 posts - 6,976 through 6,990 (of 22,212 total)
syquil (1/7/2015)
Can you expand on any 'gotchas' or 'no-nos' with the edit window for my own benefit? I typically only...
January 7, 2015 at 4:39 pm
Hello and welcome to the forums.
I absolutely agree with #5. It's actually good advice.
Unfortunately, the rest, in fact, I'd say they got basically 180 degrees out of alignment.
You should...
January 7, 2015 at 4:20 pm
It's kind of a weird question. I mean I've built complex queries, but I don't remember that many of them now. Plus, most of the ones I wrote, I probably...
January 7, 2015 at 4:00 pm
Maybe it's a typo, but why would you run the SQL Server 2014 Upgrade Advisor against a SQL Server 2014 instance? Isn't it already on SQL Server 2014?
January 7, 2015 at 3:49 pm
ROWVERSION is unsupported. There's a good listing of the supported and unsupported data types here in the Books Online.
Be very cautious about when and how you're going to apply...
January 7, 2015 at 3:48 pm
That's certainly a potential solution to the problem.
Let me provide the link as a URL link.[/url]
Just so you know, if you post a link, use the little globe button above...
January 7, 2015 at 3:35 pm
Definitely blocking. But no other information there. I don't think anyone is going to have anything to add beyond the suggestions we've made.
January 7, 2015 at 12:53 pm
Not a problem. Happy to help. Let me know how it works out. I'm curious.
January 7, 2015 at 11:59 am
Steve Jones - SSC Editor (1/7/2015)
SQLRNNR (1/7/2015)
Stefan Krzywicki (1/7/2015)
Steve Jones - SSC Editor (1/7/2015)
Ahhh, the cloud... http://www.computerworld.com/article/2865802/verizon-warns-enterprise-cloud-users-of-48-hour-shutdown.html
Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure...
January 7, 2015 at 11:57 am
I'm not familiar with the Solarwinds tools, but I'd think there might be some way to do it with them.
However, if I were doing this with the native tools, I'd...
January 7, 2015 at 11:53 am
Running a RESTORE WITH VERIFY_ONLY, which is what the backup validation does, shouldn't interfere with log shipping or anything else on your server.
January 7, 2015 at 11:34 am
Take a look at the execution plan for the query. See how it's being resolved. That will tell you if it's doing a scan or a seek for the UPDATE....
January 7, 2015 at 9:03 am
GilaMonster (1/7/2015)
Grant Fritchey (1/7/2015)
Further, your databases may have to be distributed across multiple servers through sharding in order to ensure additional redundancy.
In multiple data centers, with redundant network connections...
January 7, 2015 at 7:10 am
This is not something I've attempted myself, but there is documentation on how to set it up available on MSDN. That includes a step by step process along with the...
January 7, 2015 at 7:05 am
The only way to achieve anything like this is a combination of code and database design, regardless of your data platform. You're going to have to have an application server...
January 7, 2015 at 6:58 am
Viewing 15 posts - 6,976 through 6,990 (of 22,212 total)