Viewing 15 posts - 21,856 through 21,870 (of 39,936 total)
These don't help you in backup recovery.
The LSNs are the sequences of transactions. In ordr to restore you need the logs in sequence for there to be a chain...
November 1, 2009 at 10:07 am
There's a gap often between development and operations, but I believe it's often due to a lack of professionalism. I've seen too many development groups that don't do more than...
November 1, 2009 at 10:03 am
Even if you script things, there are possibly names, identifiers, keywords, etc that are not valid on SQL 2000.
What are you trying to do? Can you not install SQL 2005...
November 1, 2009 at 9:59 am
Bru has good advice. I would make sure you have good backups of all databases in case you need to need to rollback. That would be an uninstall of SQL...
November 1, 2009 at 9:57 am
That's why you should move to Denver :), 2 hour flight to Seattle.
November 1, 2009 at 9:55 am
I'm glad it appears to be resolved and you didn't have to do anything. I'd cautiously watch the apartment for a new, smaller camera, or blinds/shades moving.
Hope for the best,...
October 31, 2009 at 8:57 am
There are any number of ways you could hash things. Here's a quick article on the functions you use (http://weblogs.asp.net/bradygaster/archive/2003/11/26/39935.aspx).
Basically instead of
insert users (username, password) select (@user, @pwd)
you'd do a...
October 30, 2009 at 4:23 pm
What do you mean by "mask" the password field?
Passwords in SQL Server are already hashed. If this is a user table, you can hash those. The values in a table...
October 30, 2009 at 2:48 pm
Go to 3!
I thought it was great. One died, and I need to replace it, but havnig 3 worked well. It cost me about $300 for another card and monitor....
October 30, 2009 at 9:40 am
Flo has good ideas. If you have some leeway for latency (I had to do the alliteration), and could handle the data update a minute later, I'd think about:
Write a...
October 30, 2009 at 9:38 am
That's correct. If you have read only data, go 100% and filll the pages completely.
October 30, 2009 at 9:35 am
For those in THE THREAD
New beta search engine. appreciate you trying it and feedback. http://www.sqlservercentral.com/Forums/Forum83-1.aspx
October 30, 2009 at 9:32 am
you are welcome.
A couple other notes. Look at the row size for your table, or index, and then compute how many per page. Look at page splits, and then as...
October 30, 2009 at 8:38 am
With fillfactor you control how many rows, or how much data, goes into the pages. It could be about size, but don't think of it that way. It's a case...
October 30, 2009 at 8:16 am
Right click agent, choose properties. There's a history tab. You can limit by rows or size, and remove history older than xx days.
October 30, 2009 at 8:02 am
Viewing 15 posts - 21,856 through 21,870 (of 39,936 total)