i need some help. im going back for second interview for dba job and l am been told that there's going to be a test. Not writing but just task to perform. what should i expect? i want to be ready?
thanks for hint
Ok a network tech put an executive assistants database on sql with the upsize wizard in access. Only problem is that she cant input anything into the database, my guess is that its due to no Primary key in the new sql table. I have had this problem before am I correct in my assumptions???
View 6 Replies View RelatedIs anybody out there using SQL Expert Pro? Can you give me some feedback please?
I've been evaluating it for two weeks now and am very pleased with the results but I'm a bit hesitant to spend $5000.
Thanks!
Pete Karhatsu
I just got their demo but having problems with running ApexSQLDiff , any feedback how it works for others?
Maybe there are some other tools worth looking at ?
Thanks for any suggestions
Something happened, they are sending me to this conf on May 23-28. This is the first conference since 1999 that I would be attending. Personally I consider this to be the best conference, and I can attend it every day. But it would be interesting to see some of you. Anybody else going?
View 2 Replies View RelatedI am evaluating demo version of Lockwood Tech Audit Tool and having problems with "undo" module.
When I click "UNDO" it not only freezes application but entire PC, did any of you experienced same sort of problem ???
Thanks
Hello, everone:
Anybody can offer technical information about DTS appied in data warehousing? Website, tutorial, forum and books will be great. Thanks.
ZYT
We're a very small company, I’m the “technical” director who has evolved enough skill in a wide variety of tasks (network setup, machine config, email systems, html, asp, database...) and then one day you notice that parts of the system are starting to get way more complex and troublesome than the layman knowledge you have can cope with... Well, I think I’ve got to that point and I need some outside help to get our system to the next level!
OK, some rough details to start with. We run a small but fast-growing vehicle tracking system that sends back a LOT of data via GPRS to our SQL 2000 Enterprise server hosted on a dedicated server in London. The physical machine is a P4 3.2Ghz Dual-core Dell rackmount with 2GB RAM and 2 x 76GB SCSI disks in a RAID 1 array. This is partitioned into a 15GB C: partition and a 51GB D: partition. The system paging file is set to be 1536MB and is on the C: partition. The server is used for everything we do... it runs Smartermail email server (only about 5 or 6 domains and a few users, hardly used at all), SQL server as mentioned, web server & the proxy software that receives incoming data from our tracking devices.
There are 9 or 10 active databases on the SQL server. 8 of them take up less than a gigabyte between them and are sparingly used. The main “active” database on the SQL server is the tracking system – and this is big... As our tracking devices send in data every 10 – 30 seconds, the database is hit with hundreds of thousands of events per day. On a weekday, some half a million rows of data are written to the main “events” table on the database. Over 7 days from 26th November to 2nd December, almost exactly 3 million rows of data were written to the events table. We undertake to hold 3 months or so of data “live” for our customers and I periodically archive data off. I’ve been too busy to archive recently and the database is holding data on the events table going back to July 1st. The physical .mdf file is just under 30GB on partition d: at present. The plan is to drop the active data stored to only 1 – 2 months, but this still leaves a 12GB .mdf file.
The worrying thing with this is that this is only 700 or so devices writing to us at present... we aim to have thousands out there soon! We are looking into how we can hugely improve system performance and look to the future. Our hosting company is recommending VMWare virtual servers and SAN storage, but I’m not entirely sure that is the best way forward.
Our non-tech MD thinks the way forward is to have one database per customer and can't understand when I tell him I think that's bad as it will create all the system tables and bits & pieces for EVERY customer if we do that, right? Also it would be a nightmare to add a new column to a table as I'd have to update every single version of the database too... I want to avoid this unless I'm missing something and this is actually the best way to go forward?
I've had someone mention horizontal partitioning to me? not sure what implications this has to coding and table naming? Or is it all one big database spread among separate servers?
Currently our server is drowning on disk access and it's only going to get worse... any suggestions or links to reading online that I can do would be great, thanks!
Carl
My name is W. Curtis Preston, and I'm the author of "Backup & Recovery"(formerly "Unix Backup & Recovery") from O'Reilly & Associates.(http://www.oreilly.com/catalog/unixbr/ )We're updating the book for 2006 and adding a chapter on SQL Serverbackup and recovery. Someone has already written what appears to be astrong chapter. The problem is that I'm not qualified to review it,since I'm not that familiar with SQL ServerCan anyone in this group step up to the plate and review the SQL Serverchapter? You would be mentioned in the acknowledgments of the book andreceive an autographed copy of the book.We're looking for two tech reviewers.
View 1 Replies View RelatedGood fortune came my way this morning I was invited to an interview for a Database Administrator/IT Support position with a local charity.Although my 2 years experience with IT has been mainly supporting desktops Win 98,2K ,XP in a workgroup together with training users on MS Office Professional I decided to go for the database admin/IT support because I want to broaden my experience with IT applications. The objective being to become more marketable to employers.While I definately meet most of the IT support/training requirements for the post a few requirements are making me nervous because I have no experience in them since I believe I may need programming and or other skills which I don't have. The accountabilities that make me nervous are the following :
1. Devise and implement solutions to corrupted data and software inconsistencies or failures of the housing database.
2. Devise and implement solutiions to corrupted data and software inconsistences or failures of the management information system.
3. Devise and deliver reports from the housing database or MIS in order to satisfy the requirements of managers and external regulatory bodies.
4. Test and validate new versions of software.
Do I need database programming skills for these requirement?If not what skiils do I need and what would be the best way of answering quetions about these requiremnts during interview since I have no database admin experience ?
Looking forward to your thoughts on this.
Eastfield
Hello everybody,
I'm new to SQL Server,I have a interview tomor,could anybody give me a website from where i can get questions on SSRS.
Thanks in advance
Help please? Does anyone have any suggestions for me in regards to my first interview for a SQL DBA position. I will be meeting with the technical team including developers and IT professionals as well as the hiring manager. I want to make sure I as the right questions and have the correct answers. This is my first interview for this type of position. What are good questions? Any help or advice would be greatly appreciated.
Jerry
Hi,
I was wondering if some one would be able to help me?
I'm interviewing a SQL Admin soon and I'd like to ask him some
SQL 7 questions to test his knowledge. He has less than a year
of experience. Does anyone know any good questions I could ask him?
Please e-mail them if possible. I appreciate any help that could be provided.
Thanks,
Jim
here is a question asked in a interview:
u created the sales database with the initial size of hte transaction log of 50 mb with autogrow, but no autoshrink
u do not make any backup and donot set the truncate log on check point option to on.
what will be the transaction log size after the next check point has passed?
How many tables can be updated with a single update ?
View 14 Replies View Relatedwhen does sql use update lock?
View 1 Replies View RelatedHello
Can any one help me for below question....
" write a query using FOR UPDATE syntax "
Thanks
Ganesh
Solutions are easy. Understanding the problem, now, that's the hard part
Hi,
I know sql and Dataware housing.I got a job offering for sybase sql but I don't anything about sybase.Will it be in programming in Actually what we will do in sybase? What will be the nature of work? and I just want to know what type of question will be asked ? Please do reply.
Regards,
Raji
hi,
i have been attending interviews and jotting down a couple of questions that were asked to me. could someone please answer to these..it would be of gr8 help..
Q 1> give example of situation when & why u would use clustered and unclustered index. not the definition a practical example.
Q 2> a website has a lot of users using it and the pages are loading very slowly what would you check..
i said would look for deadlock , the next question how would you look for dead lock?
i answered would check on the stored procedure on that page, question what if there are multiple stored procs then what would you do?
Q 3> what if u have a dts package and execute SQL task and there is a stored proc that is doing inserts on a table and that table has triggers on
it for insert, delete etc.so would the triggers also be executed with the dts package run?
thanks.
Dear All,
Could anyone guide me to prepare for the Interview in SQL SERVER 2005.
I have studied the relevant things from background knowledge from the SQL Server books. But is there any specific areas in which I have to concentrate for the sake of Interview?
Thanks in Advance.
My boss asked me to interview 2 people on Monday for a programmer/developer position. They say they are gurus, but my boss wants me to find out for sure. I thought a question about bitwise operations would be good, maybe one about semi-joins. Are there any questions you can think of that will spot the phony pretty quick?
Thanks,
Jim
Hi to all. Recently i attended an interview .I have so many doubts ,could any one tell me about these questions.
1.) How to identify a query which is used by end user with out profiler. (the exact query)
2.) my tempdb is full what to do.
Then i said i will restart the server
then he asked My company is not allowing to restart the server.then what we can do?
3.) Transaction log is full what to do ?
4..How can we improve the performance of database.
5..how to rebuild the master database if it is corrupted.
6.. what new features are introduced in log shipping in 2005.
7..how can we give a permission to a userto use only profiler. he is not allowed to do any operations
8..after finding long running queries the next stop what we can do?
9..what i can do if my secondary database is no in sync with primary database in log shipping.?.
10..if the quereader agent fails will the transactional replication completely fails or partially fails.
11..how to replicate identity column in merge replication?
Waiting for ur replies,
Sripathi
DBA Interview Questionshttp://quickdba.blogspot.com/2006/0...-questions.htmlVisit for more Articles
View 3 Replies View Related
I've met an interview question. How to do when you need to add an normal column to a very large table? what should you do carefully?
Thanks.
I have been asked by a person who is going to interview me to supply this informationl;
'Come prepared to be able to talk me through how to set up an SQL driven .NET website on a server.
You are given a webroot folder containing root files such as the web.config and all the files for a .NET website and a data folder which contains an .mdf and .ldf files.
Talk me through what each of these folders contain and what you would do with them in order to set up the website on a server such that you would be able to open a browser type the URL you have configured and visit that website.'
I come from a Cisco background and no nothing about what she is asking. Is it unreasonable of me to expect to be able to gain this information in 2 days? Can you tell me the best place to look for this knowledge?
Thanks for any help.
hi,
pls help me ,i am going to attend the interview for SQL DBA pls give me a some tips.
Hi,
I will be going for an interview and I heard that the interviewer usually ask one question which is "if a table contains only one field in which normal form it lies.". What I wanted to know is if it is normalized or not if normalized then in which normalized form it will lie and if not lie in any normal form then why?
I would also appriciate if someone can give me some good source for that as well.
Please treat it as urgent as my interview will be day after tomorrow.
Thanks and best regards,
Suggest me for SQL Server 2000/2005 Interview & Practical Preparation... 1) FAQ2) Interview Questions.3) Books.4) Tutorials.5) Others.
View 2 Replies View RelatedAny suggestions for some really juicy questions to ask contractors in an interview scenario?? What are your best questions any further ideas would be nice to hear. Cheers.
View 1 Replies View RelatedAnyone know the answer to this? Looks an awfull lot like a trick question. How long will it take to create a non-clustered index comprised of 5 columns with each column being 50 bytes wide? The table has 6 million rows and an average row size of 2000 bytes. The hard drive system is comprised of 5 disks, which spin at 15,000RPMs and are setup in a RAID 5 configuration
View 7 Replies View RelatedI was on an interview and one developer asked me:
Suppose three transactions have three different isolation levels, one of them has isolation level
serializable, and all of then hit one table. How will SQLServer handle this?
He said that SQLServer automatically set isolation level for all transactions to serializable.
Is it true?
Thanks Nick
In my experience of going through plenty of interviews, I have came across a question that I am reminded of by someone's signature.
The common question in this instance is:
What is the advantage of a cursor over a stored procedure? Vice Versa?
I could only, in my so few experiences, have answered that stored procedure consumes less system resources than a cursor. The advantage a cursor has is record by record examination and looping capabilities.
Needless to say that whenever asked those questions, I haven't landed the position. So I'm wondering, what is the more appropriate answer?
Does anyone has, a list of interview questions for SSIS? Or can somebody list possible SSIS interview questions?
------------------------
I think, therefore I am - Rene Descartes