SQL Server Performance Tuning Interview Questions 

i have like 5 and they are taking up ALOT of disk space.
They end with different updates like suck
-j2se runtime enviroment 5.0 update 5
-j2se runtime enviroment 5.0 update 6 8 and 9 and so on.
will effect my computers performance of better it?
Should i just keep the most recent one?
Same thing with java.
-java(tm)6 update 5-6-7.
Can i remove the older "updates" without it effecting
my computer?

ALSO>>>?
What microsoft SQL server 2005?

I work in data migration for a small software company based in Southampton. When I started the job I accepted (what I thought was) a very basic salary of £25,000. Can you tell me what is a good percentage to ask as a salary increment? The job involves Oracle and PL/SQL. I have completed 1 year. I have 2.5 years experience in Oracle related technology. I have also proven my skills at my job and have had very good performance reviews. I have looked around on the internet and have an idea about what the average salary is for my job/skills but I would like your views on this! You don’t need to be in IT – any advice on what sort of percentage increase to demand would be much appreciated.

I realize this is more of a server question than a networking one, but hopefully somebody could shed some light on this for me.

We have a client running a .net setup across IIS; we've convinced them to install PHP an MySQL on their system. They're wondering what type of performance impact or footprint these installs will leave on their system. I just don't know enough about servers to answer it effectively; I stick to coding and leave the server stuff to more capable people.

Oh, btw - they're also going to be running MS SQL Express on the same box for some legacy applications they have in place.

Any help would be appreciated - thanks!

i m using sql server 2000 and VB 6.0 as front end.
i have a table named tblCompany in which company information is stored. when i open recordset and save it and apply rs.requery method then it take long time to complete the transaction. i have 50000 rows what can i do? please help me

how to enable sql server management studio and performance tools. In sql server 2005.

I've been trying to get a response from customer service for MONTHS. My web hosting service is down an average of 2-3 HOURS DAILY now (this includes SQL). It is NOT (be assured) a problem on my end. I've sent detailed information, including logs to no avail. The only emails I receive from yahoo are offers to purchase more services from them.

I'm supposed to launch my website (retail business) in a few days and I know I'm going to lose quite a bit of money because of the unbelievably horrible server performance (which seems to be getting worse, by the way). I'm not trying to create a problem, I'm trying to solve one.

Could someone please offer some suggestions as to how to handle this situation?

I m an IT student practicing oracle 10g... i have installed oracle 10g on my laptop but everytime I boot into my laptop, "oracle.exe" appears on the process in the "task manager" with stunningly 168,000 or more KB or about 168 MB on my memory.... It affects in the performance of my laptop.... When i "end process" it and start oracle sql*plus, error occurs... is there possible way to solve this problem.. I mean, i want oracle start ONLY if I need to use it ONLY??? THNKS in ADVANCE!

student information system should contain the information about student,class,room,teacher,time-table,se...
Design the ER Diagrame with all relationships.
Give an SQL DDL defination of the database.Identify referencial integrity constraints that shoule hold,and includethem in DDL defination.
Write the SQL statements which illustrates the use of cartesian product','RESTRICT' and JOIN operations on the above database.
Show the normilazation of tables with proper justification.
Get the names of students who have secured B grade in a computer science coursr csi-14 in the autumn semester.

I am new to ASP.NET but not to SQL Server. I created a Windows and WEb front end using VB.NET and ASP.NET respectively, using hand coding the SQL connection, command, stored procedures etc. The data wizards seem to greatly simplify this process, especiall when binding objects like text boxes, drop down lists etc. My question is, is there a difference in performance, is it considered cheating, do employers or other developers frown upon using the wizard method?

am running pc with intel p4 processor 2.66 ghz 704 mb ram d101ggc mother board ..........am connected 2 internet.also...........how vl my system performance will b effected if i install microsoft .net 3.5 ...........& sql server 2005..............
need i increase my ram ?

I currently work for an online company backed by a mysql database. Our websites performance is slowing down due to the heavy traffic. Here's my question

I know MS SQL and Oracle our great databases for heavy traffic. Is there any MYSQL databases that will work for heavy traffic sites?

I have a lot of php code that I would have to switch over to sql syntax if I change the database structure

It doesn't like "Category." If I remove all the code to handle the category column, it works fine. I'm working in Visual Studio 2005, and I'm stumped...???

MY CODE:

OleDbConnection myConn;
myConn = new OleDbConnection("Provider=Advantage OLE DB Provider;Data Source=\\\\server123\\ m \\dst \\plx_data\\ planfaxsystem.add; User Id=XXXXXXXXXX; Password=XXXXXXXXXX;");

myConn.Open();

string morningStar = "MorningStar";

string sql2 = String.Format("INSERT INTO PERFORMANCE_TABLE(SecurityName, Ticker, Cusip, Category) VALUES ('{0}', '{1}', '{2}', '{3}')", fundName, ticker, cusip, category);

OleDbCommand cmd = new OleDbCommand(sql2, myConn);
cmd.ExecuteNonQuery(); // ** CRASHES HERE **
if (myConn != null && myConn.State == ConnectionState.Open)
{
myConn.Close();
}



ERROR MESSAGE:
Error 7200: AQE Error: State = 01004; NativeError = 2102; [Extended Systems][Advantage SQL Engine]Data truncated INSERT INTO SYSTEM_PERFORMANCE (SecurityName, Ticker, Cusip, Category) VALUES ('Newton Balanced', 'STASX', '001285400', 'Moderate Allocation')

We currently have a PC and need a new computer so we are thinking of switching to a Mac. My husband loves gaming and currently has PC games. He will need new games so that is a negative. I'm into programming and love databases but Mac doesn't support MS Access. This is another negative. Also, my husband is a budding writer. This will be our first time on a Mac so there will be some getting use to it but we love it's sleak design. In the overall experience of things, is it easier and better to stick with a PC or are there great advantages to getting a Mac? My programming languages include C++, Java, Cobol, MySQL, PHP, and HTML with interest in SQL and VB. Also, we have a digital camera with tons of pic from our weddingmoon that we need to download (I've heard good things about Mac and managing pics). Some other considerations are money and performance. We want a powerful computer that has lots of space and speed that is also easy to upgrade without completely breaking the bank. Help. :)

String sql = new String("SELECT NAME FROM OTHER_SERVICE_MASTER WHERE ACTIVE='Y' AND SERVICE_TYPE='Music'");
StringBuffer sqlb = new StringBuffer("SELECT NAME FROM OTHER_SERVICE_MASTER WHERE ACTIVE='Y' AND SERVICE_TYPE='Music'");
String sql = ""SELECT NAME FROM OTHER_SERVICE_MASTER WHERE ACTIVE='Y' AND SERVICE_TYPE='Music'""
Performance - wise (execution time in milliseconds)
and Resource - wise (minimum memory consumed)

All these three queries find rows from two tables that does not match each other based on a single column comparison. IN Short, Find all records of both tables, except for the matching ones. They produce the same result. But we're looking for the query that uses the least resources and best performance

Answer specific to SQL Server in relation to the best performance based on execution plan will be chosen as the best answer. But general answers with good explanation will also be considered.

query1:
SELECT tbl.a FROM (SELECT table1.a FROM table1 UNION ALL SELECT table2.a FROM table2) as tbl GROUP BY a HAVING COUNT(*)=1

query2:

SELECT Table1.A
FROM Table1 LEFT OUTER JOIN Table2 ON Table1.A =Table2.A
where Table2.A is null

UNION

SELECT TABLE2.A
FROM TABLE2 LEFT OUTER JOIN TABLE1 ON TABLE1.A = TABLE2.A
WHERE TABLE1.A is null

query3:

SELECT table1.a FROM table1
WHERE table1.a NOT IN (SELECT table2.a FROM table2)
UNION
SELECT table2.a FROM table2
WHERE table2.a NOT IN (SELECT table1.a FROM table1)