Viewing 15 posts - 4,666 through 4,680 (of 7,185 total)
Kelsey Thornton (3/1/2012)
Very well explained but missing one useful point:"Why would you want to change the port number in the first place?"
(1) Security, to prevent attacks on the default port....
March 1, 2012 at 2:02 am
I've seen backups succeed when the database has corruption in it. That's why it's important, periodically at least, to test that you can restore your databases and run DBCC...
March 1, 2012 at 1:51 am
You could use an OUTER JOIN instead, although I suspect that you may end up with the same execution plan. Have you considered indexes on the srno column in...
March 1, 2012 at 1:47 am
Kwisatz78 (2/29/2012)
Here is what I have altered it to:
But your original post was about splitting the update into batches. Have you tried doing that?
John
March 1, 2012 at 1:30 am
Matt Miller (#4) (2/29/2012)
Correct, you do log everything, but the truncate happens immediately after commit in simple mode so small batches roughly means no log growth in that scenario.
Actually, the...
March 1, 2012 at 1:28 am
You could do that, yes, but you're only explicitly doing something that would be implicitly done anyway. The original poster says that the whole thing is done in one...
February 29, 2012 at 9:08 am
(At least) two ways of working this out:
(1) Use Profiler to run a trace while you use the GUI, so that you can find out what commands were executed in...
February 29, 2012 at 8:43 am
Since there is no question here, I'm guessing that you want someone to write the stored procedure for you? That's not generally the way it works. Please have...
February 29, 2012 at 8:38 am
Matt Miller (#4) (2/29/2012)
February 29, 2012 at 8:16 am
Kwisatz78 (2/29/2012)
The code isn't just one big update, it is several wrapped in a single transaction.
If it's all one transaction, batching it will have no effect. The transaction will...
February 29, 2012 at 8:02 am
Ananda
Just as a matter of interest, why are you wrapping a SELECT statement in an explicit transaction?
John
February 28, 2012 at 1:46 am
It's best to let your presentation layer handle things like this. If you have to do it in the database layer, you can use FOR XML to concatenate the...
February 27, 2012 at 8:58 am
It's worth having a look in the default trace next time it fails to see whether the activity is recorded in there. Another thing that's worth doing is piping...
February 20, 2012 at 3:53 am
I've just tried your script, and it looks like I was wrong about not being able to use a variable in your BACKUP statement, so ignore that comment. I...
February 20, 2012 at 3:12 am
You can't use a parameter for the database name in a BACKUP statement. You need to use dynamic SQL instead, or find some other way of building your SQL...
February 20, 2012 at 2:57 am
Viewing 15 posts - 4,666 through 4,680 (of 7,185 total)