Viewing 15 posts - 9,241 through 9,255 (of 22,214 total)
It's certainly possible, and yes, it would matter. For example, you may have an application that knows it has issues with statistics, so as part of the install it creates...
December 16, 2013 at 4:15 pm
SQL Server Availability Groups were introduced with SQL Server 2012. But there are other types of "high availability" options that are there in other versions of the product, as were...
December 16, 2013 at 4:12 pm
Yikes! Not good. A consistency check should be run on the database right away. I hope you have good backups in place.
December 16, 2013 at 12:00 pm
Replication is also supported in Standard. Mirroring is also supported by Standard (although a slightly reduced version). You can see the versions here.
December 16, 2013 at 11:58 am
Or you can set up mirroring or log shipping or replication... None are easy, but all can be done in such a way to get a read only copy of...
December 16, 2013 at 10:57 am
As you have it currently configured, you're right not to trust it. You're completely open to SQL Injection. For a good laugh, and a good education, see to Bobby Tables[/url]....
December 16, 2013 at 6:33 am
A database backup consists of all the committed pages of the database and enough of the log roll forward or roll back active transactions at the time of the backup....
December 16, 2013 at 6:28 am
You're going to have to go through all the processes of tuning the server, the database and the code. I'd suggest getting a copy of my book on query tuning....
December 16, 2013 at 4:41 am
What version of SQL Server? Is this an Express version? If so, it's probably just not started. You'll have to locate it within the file system to get it started....
December 15, 2013 at 4:51 am
As much as I'd like to say that Red Gate is the way to go, I think you'd be better off using SSIS to build out a migration between the...
December 15, 2013 at 4:49 am
Two options come to mind. First, and possibly not the easiest but certainly the most direct, set up a VPN so that it's part of your network. Second, you can...
December 14, 2013 at 5:24 pm
And I agree with Sean and Jeff too. I didn't look at their answers first. I was just excited by the questions. These are pretty classic types of issues that...
December 14, 2013 at 5:20 pm
hmbtx (12/13/2013)
Question #1:What are the reasons, if any, for this company to seriously consider a SQL Server upgrade from SQL Server 2000?
Media. Make darn sure you have several copies of...
December 14, 2013 at 5:18 pm
tmlink99 (12/13/2013)
It's odd that nodoby here could just say what you do. Grant said to just rely on the integrity of the publication. Is that it?
I did say...
December 14, 2013 at 12:44 pm
Viewing 15 posts - 9,241 through 9,255 (of 22,214 total)