Forum Replies Created
Viewing 15 posts - 946 through 960 (of 1,221 total)
-
RE: Weirdest interview question?
It would not be a bad idea to have some of these questions thought out before your next interview! I was discussing this with my wife a couple of...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Am I Old-Fashioned?
It's the only way to be sure that the business rules will be enforced -- put it all in the database. Take a clue-by-four upside the head of anyone...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Am I Old-Fashioned?
Oh, man! That guy is frightening! If that's where the industry is leading, I'm getting back into photography and letting my wife support me!
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Recomendations and opinions please
Juan, you can pick up the SQL Server 2005 Developer Edition for around $50(US) or less, and it's not time-expiring, so it lasts forever (but you can't use it for...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Book Recommendations...
This was a major part of my last good SQL Server job. I was formatting data then spitting out a file for uploading to a mainframe. The first...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Taking Risks
I took a risk on my laptop and got burned. I was among the legion running as admin, which is a mistake in and of itself. But the...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Optimal disk/RAID config for six drives?
Yeah, I'm aware of 2000 going out of support. The box that I'm migrating from is kinda shaky, so the migration is going to happen. Plus, it'll free...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: SQL SERVER RECOVERY TOOLS
I don't trust anyone with my backups. Period. Full stop. They were using a backup agent when I arrived (they had not had a DBA prior to...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Disaster - Recovery Order of events
Your safest way would be to restore master & msdb first. msdb has all of your jobs and DTS packages, it would be easy to forget restoring it once...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: A Matter of Trust
All that bonding does is it shows that in the past you appeared to be a trustworthy person. As the investment adverts say, "past performance is no indicator of...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: A Matter of Trust
Couldn't a lot of this could be solved using the crypto features in 2005? Encrypt the salary column, the SSN (assuming it's not your PK), the bank account or...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Optimizing Performance of Stored Procedures in SQL Server 2000
This is kind of trivial, but....
If you change your date fields to smalldatetime, you save 8 bytes per record (4 bytes per storage value for smalldatetime vs 8 bytes per...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Revisit What You Know
I'd kinda like to see your personal standards document. Sounds like an article in the making...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: truncate a database(help required urgent)
Two ways come to mind immediately. The first would be to script out the database and re-run the script. The second would be to use the sp_MSforeachtable to...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font] -
RE: Beginning SQL Server - Logins and Users
Always good to review the basics. I noticed that the .\ usage in figure 7 was no different than if I click the ... button without it. Am...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 15 posts - 946 through 960 (of 1,221 total)