Viewing 15 posts - 9,421 through 9,435 (of 22,214 total)
SQL Show (10/22/2013)
Full backup file is being overwritten(append) by Differential backup so file size increases.
No, not overwritten, added to. As Gail said, it's adding the differential to the full within...
October 22, 2013 at 5:02 am
And you'll need each and every one of those files to restore the database.
October 22, 2013 at 5:00 am
Just know that the restore operation completely replaces the existing database. It doesn't merge the two. If you have changes you've made to your copy of the database, they will...
October 22, 2013 at 4:59 am
You could look at materialized or indexed views. These are actually a separate data store that you have to update to see data changes. But, they don't work well with...
October 22, 2013 at 4:54 am
My wife thinks what I do is the most boring thing in the world. But, sometimes, I still have to share with her, so, I explain all the concepts that...
October 21, 2013 at 4:57 pm
TWH (10/16/2013)
How do you keep current with SQL Server?
Lots and lots and lots of experimentation, reading and listening. I experiment with technologies I don't understand or need to learn more...
October 21, 2013 at 4:55 pm
One thing you can do is to use Red Gate SQL Prompt to format the query, whether it gets saved correctly or not.
October 21, 2013 at 4:48 pm
There are a number of things that could cause differences. I'd focus first on the execution plans for each query. Are they the same? If not, your issues are narrowed...
October 21, 2013 at 4:47 pm
It sounds like a permissions issue. Do you connect to the SQL Server instance with a different login than the one that is running Visual Studio?
You may need to create...
October 21, 2013 at 4:44 pm
I'm pretty sure you can use one of the file splitting utilities to break them apart and put them back together even though they're encrypted. Other than that, you could...
October 21, 2013 at 4:34 pm
Set up a powershell command to connect to each of the servers and run a query. You can even use threading and remoting within powershell to have the queries run...
October 21, 2013 at 4:29 pm
Sorry to say, I don't know anyone working for any of those three. My experiences with all outsourcing agencies is that the responses you get can be very uneven. I'd...
October 21, 2013 at 4:28 pm
In short, you're in a great situation. Leave it alone.
October 21, 2013 at 4:27 pm
You can also use Policy Based Management to look at how many days it has been since a backup was run on a database. That's a great way to double...
October 21, 2013 at 11:13 am
If you hit the issue again, I'd look for blocked processes. It's likely that you had one that was preventing your from completing what you were doing. You could have...
October 13, 2013 at 7:22 am
Viewing 15 posts - 9,421 through 9,435 (of 22,214 total)