Viewing 15 posts - 46,966 through 46,980 (of 49,571 total)
It varies by company and interviewer. I don't usually ask the same question in 2 different interviews.
I usually ask a couple of questions on indexes, at least one on execution...
April 9, 2008 at 2:17 pm
Is this for a written interview test, or did someone ask you these?
If you're trying to memorise answers for an interview, don't. A good interviewer can see through that very...
April 9, 2008 at 1:36 pm
If you open enterprise manager, and look down the bottom of the tree you should see SQLAgent.
Expand that out. The jobs are recorded under there.
Does that help?
April 9, 2008 at 1:35 pm
Profiler won't show you anything. Profiler captures events sent to the server. When a tran log is restored, the SQL engine works through the tran log and just does the...
April 9, 2008 at 1:33 pm
No need to start a second thread. People have already posted suggestions to your other one - http://www.sqlservercentral.com/Forums/Topic481421-338-1.aspx
April 9, 2008 at 5:56 am
Did you copy the files off a CD/DVD? If so, they'll be marked readonly (file property) and hence the DB will be read only once attached.
April 9, 2008 at 4:15 am
Is the folder that the DB files are in either encrypted or compressed?
April 9, 2008 at 3:48 am
tosscrosby (4/8/2008)
Just a tip - When you have really bad fragmentation, with the databases offline (SQL server services are stopped), you can run the system tool "Disk Defragmenter".
That will...
April 9, 2008 at 3:38 am
The Practical troubleshooting book (edited by Ken Henderson) has a chapter dedicated to memory, including when and why to use the switches and exactly what effect they have. It's a...
April 9, 2008 at 3:21 am
bradfordshultz (4/8/2008)
A)you shouldnt index 150 fields
If you're using SQL 2000, you can't create a covering index over 150 fields. Index keys are limited to 16 columns.
In 2005 and...
April 9, 2008 at 12:37 am
SQL 2005's a lot better at ORs than 2000 was. It now can (and sometimes does) process an or the same way it would process a union.
Try them both, see...
April 9, 2008 at 12:29 am
Matt Miller (4/8/2008)
The truncate activity (which essentially deallocates pages or marks them as "free") itself is not logged.
The changes to the allocation pages are logged, otherwise you couldn't...
April 9, 2008 at 12:27 am
Stanley Pagenel (4/8/2008)
Msg 195, Level 15, State 5, Line 2'SHOWPLAN_XML' is not a recognized option.
Are you using SQL 2005 or 2000?
April 8, 2008 at 8:07 am
There shouldn't be any difference in performance.
April 8, 2008 at 7:50 am
I'm curious. Why do you need to do this?
You can use a startup procedure, or you can create a job that will run when SQL agent starts. Either will...
April 8, 2008 at 5:50 am
Viewing 15 posts - 46,966 through 46,980 (of 49,571 total)