Viewing 15 posts - 32,851 through 32,865 (of 39,818 total)
John,
a couple things. First simple logging does clear the transaction log, but only of committed transactions! So if you run 100,000 deletes as a "set rowcount 100000 delete from mytable...
December 6, 2006 at 9:25 am
Mike,
I don't think there's anything to take you from start to guru. You'll probably end up with a variety of materials.
For books, I think any of the "SQL Server in...
December 6, 2006 at 8:24 am
rao's solution is the best.
if (x = y)
raiserror ()
return
else
-- continue
December 6, 2006 at 8:13 am
I think this is one of those cases you'd be better off controlling it. Do you know how big a row can be? If so, I'd calculate how many you...
December 6, 2006 at 7:55 am
Did that work? Have one machine where this is my problem.
December 6, 2006 at 7:53 am
Simon,
Congrats and that sounds like a job I left years ago. Don't really regret it, it was a good decision at the time, but I miss it.
Besides, I have...
December 6, 2006 at 7:49 am
Some very interesting responses here and I can see the other side from many of you.
I guess I'd still stand by my point for the conference/seminar presentations since time...
December 5, 2006 at 9:34 pm
SQL Server 2005 is a great move forward for security in the MS world.
Charles, I've read about a few of those tricks before and it's certainly made me rethink the...
December 5, 2006 at 9:30 pm
Thanks for the professional answers and I have emailed directly to the original poster regarding the less than professional behavior.
December 5, 2006 at 9:28 pm
Updates here: http://news.com.com/Searchers+believe+they+are+nearing+missing+CNET+editor/2100-1028_3-6141107.html?tag=nefd.lede
and why you should carry a cell phone: http://news.com.com/2100-1039-6140794.html
December 5, 2006 at 6:06 pm
Profiler is a utility that comes with SQL Server. You should read about it in Books Online and experiment with it. If you configure it to capture minimal data, users,...
December 2, 2006 at 12:41 pm
The job should show failure, and you should have a notification set up to let you know. Check the logs for teh maintenance plan, not the job history for the...
December 2, 2006 at 12:37 pm
Do you have someone measuring bandwidth usage? Possibly from individual machines? What about running Profiler and seeing how much and how quickly traffic is being sent to and processed by...
December 2, 2006 at 12:35 pm
Tim that's a really interesting solution. I've love to hear more in an article as I'm sure many would. How much data are you talking about for a full backup?
Dave,...
December 2, 2006 at 12:33 pm
Viewing 15 posts - 32,851 through 32,865 (of 39,818 total)