Looking for database administrators familiar with inner workings of SQL Server 2005, comfortable working with clustering and replication and...
Thank you Ranjit, I will try to answer the questions The position expecting a mix of technical skills with some understanding on business - a lot of...
We are starting to look for the potential person to join our database team and specialize primarily in datawarehousing and business intelligence for...
We are starting to look for SQL Server DBA to join our database team. Responsbilities include system/database design and development, administration...
Hello to everyone, I am currently looking into setting up multi-node cluster using Windows 2003 Advanced (to avoid 2 node limitations W2K has)...
We are looking for a person to join our data team and help with design and development of database solutions (plus some database administration and...
Joe - you are right. CBO is now a default option (especially in 10g) and RBO is "depreciated technology" on its way out Simas
tell us a little more on what you mean by "need storage redundancy" - do you mean that you need to stay up if any one (or more) drives in your array...
Couple of things 1) you may want to consider setting the recovery mode to FULL as it was mentioned here. Not being able to do point of failure and...
Thank you to everyone who read/replied to this message - the position is filled. Simeon
What do you see in Current Activity when you run select * from sysdatabases (if anything)? Is that process waiting for something (if yes, what is it...
We are looking for SQL Server Database Administrator to join our database team and assist with design and development of database solutions,...
Also check outhttp://www.sqldev.net/xp/xpsmtp.htm and their XPSMTP.DLL - I use it to be very useful for most of the alerting.. simas
Upps, sorry - posted to the wrong forum (meant to go to Peformance Tuning for Developers). Moderators, please move if you can.. simas
Interested in comments of others on performance of performance of ordered and unordered TOP statement. Assume I have three queries (a) SELECT TOP...
As Satya said - either replication (you can adjust the scripts), custom built app using DTS or both.. is 1.5 Gb the total amount of data you are...
it depends on how much money you are willing/able to spend on...
Farhad , Please let me know if there are still items you have questions about - restart of SQL Server is "reboot" of the database engine (cleaning...
Thank you Franco . I would second Argyle opinion - if you have resources to separate the application out , do it to minimize the impact they would...
Microsoft also has a tool you may want to check out SQLIO and SQLIOStress...
Separate names with a comma.
