Viewing 15 posts - 27,166 through 27,180 (of 39,793 total)
http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30043/
Uses PKZip, but you can modify to use the command line for WINRAR.
September 9, 2008 at 6:48 am
You can run frequent diffs, but they'll get larger and larger. For that matter, why not run a full every hour? You could do that and it would let you...
September 9, 2008 at 6:47 am
As mentioned above, a simple in the WHERE clause should do this.
This sounds like some test question or interview question. We are happy to help, but we want to...
September 9, 2008 at 6:46 am
Good points on your value and something I hadn't considered.
As an FYI, I actually have a balanced NCA where the I have to give xx notice and the company must...
September 9, 2008 at 6:12 am
RE-uploaded the file for the WMV. Hope that works.
September 8, 2008 at 4:12 pm
localhost/mssqlserver is a named instance. (local) defaults to local (I think 127.0.0.1)
The /mssqlserver isn't necessary for a default instance. You'd just connect to the Windows machine name.
If you want to...
September 8, 2008 at 4:11 pm
Agent shouldn't restart SQL Server. If it is, I'd call MS. Perhaps keep an eye on it to be sure it wasn't coincidence.
September 8, 2008 at 4:08 pm
There are very few secrets. Is SQL Server doing something that Oracle can't? Hardly.
I heard Jason Fried of 37 Signals speak last week. He talked about how often they blog...
September 8, 2008 at 3:57 pm
Thanks Keller, I've updated the feed. Not sure it's working, but that's the one I have from Mevio.
Feed broken at times, working on that, or I've been trying to get...
September 8, 2008 at 3:55 pm
Read the articles by Jeff Moden. He covers some great basics you might want to avoid.
September 8, 2008 at 3:25 pm
There isn't a good way to do this. You could script grabbing 10% of rows in all tables, but the issue is that you'll have FKs and child rows that...
September 8, 2008 at 3:24 pm
Is there a unique index on the table?
September 8, 2008 at 3:22 pm
Haven't seen the error, but I'm amazed it would restart the server. Did the SQL Server instance restart or was it Windows? Or SQLAgent?
I'd probably call Microsoft on this one.
September 8, 2008 at 3:15 pm
You have a syntax error there with the name of the column. What is the column name of the table?
September 8, 2008 at 12:20 pm
I think you're kidding, and I hope so. Soft Skills are important. Even in the military, where it's a top-down, no-nonsense, do what I say attitude, soft skills are needed...
September 8, 2008 at 11:46 am
Viewing 15 posts - 27,166 through 27,180 (of 39,793 total)