Viewing 15 posts - 31,876 through 31,890 (of 39,749 total)
I agree with Sugesh. It's not necessary, but it can help. The important thing is to really balance the pros and cons of the .NET v TSQL and choose ...
July 4, 2007 at 10:25 am
I avoid new instances because of the memory limitations of most machines. It might be better to let SQL Server manage the memory and CPU. In SS2K8, there will be...
July 4, 2007 at 10:23 am
I appreciate everyone's responses and one of the great things about this is being able to express disparate opinions. However, there is a time and place where free speech applies.
If...
July 4, 2007 at 10:01 am
I updated Carstens after an email. If you have issues, please send them to sjones at sqlservercentral.com (60x60 pixels) and I'll upload them. Include your registration email.
July 4, 2007 at 9:50 am
Yikes, hate to hear that. I worked on the 443 and 444 exam book for Sybex.
In SQL Server 2005, there's the MCTS and MCITPro certs. Use SQL Server 2005 and...
July 2, 2007 at 11:08 pm
Good advice above.
I'll add that you should document your work and use email to respond to people when there are issues, copying your boss. If he cannot work with you...
July 2, 2007 at 10:50 pm
Hugo,
No offense and you brought up some great points, but honestly when I'm working on questions, I work in one area, try to write 3-5 questions on something in that...
July 2, 2007 at 9:21 pm
http://www.sqlservercentral.com/columnists/sjones/3044.asp
Got a second part coming as well.
July 2, 2007 at 10:16 am
You ALWAYS want free space in your data files. This is so as you add data, it has a place to go. The only time you'd want 0% free space...
July 2, 2007 at 10:15 am
If I understand, you want to create a new log file and then remove the old one from your database? AFAIK this isn't possible. You can "move" the log to...
July 2, 2007 at 10:14 am
I don't live in Iowa and I use Google too. I've been disappointed in Live, though the MS folks at TechEd claim it's much better.
I'm sure Google made the decision...
July 2, 2007 at 10:05 am
Wow, you guys are overthinking this. The questions aren't intended to cover every possible option on your server. It's intended to help you learn about one tiny aspect of SQL...
July 2, 2007 at 9:59 am
And enjoy yourself!!!
Have fun, joke with friends and co-workers, smile, take "fun breaks", run to Dairy Queen/Starbucks/Jamba Juice, keep a football around and throw it with a friend for 5...
July 2, 2007 at 9:38 am
Redd has a great explanation and I'll just add my little bit to it.
The memory above 4GB is "swapped" or "mapped" (not sure which) down into the OS section of...
June 30, 2007 at 8:48 am
I've heard great things about both Red Gate and Innovartis (dbGhost) as products from people. Haven't really used either, but people seem to like both.
June 29, 2007 at 7:58 pm
Viewing 15 posts - 31,876 through 31,890 (of 39,749 total)