Found em.

SQL 2000 IO basics

IO Basics chapter 2

Back to the subject of shrink. Have you tried several smaller shrinks instead of one large? If you're trying to shrink the file...

Hmmm....

Are those disks in a RAID array, or are they single disks?

Be careful with write caches and SQL server. Not so much of an issue, since its a dev server...

Agreed. I did, amoung other courses, compiler theory, 2 forms of assembler, low-level networking...

Could also be that there's a trigger, or that the foreign and unique constraint checks are taking the time on the insert. They shouldn't but...

That's the main reason I want...

VAIYDEYANATHAN.V.S (10/24/2007)

---

System SPID

You can define a trace that records only Microsoft® SQL Server™ processes while filtering out any unnecessary system events. Filtering out system server process IDs (SPIDs) saves system...

In my company, the first interview is technical. After that there's a technical test, then the HR-type interview.

Seems to work quite well. So few people get through the first interview....

p.s. What you'll get from dm_exec_sql_text in the case of stored procs and functions is the creation script, not the code that executed the procedure which is what you will...

You can always run a trace serverside if you don't want to use the profiler GUI (which you shouldn't on a production system) See sp_tracecreate in BoL.

As for getting the...

Huh? What does an indexed view have to do with anything?

Kiruba:

I'm not sure I understood your question totally. You have an application that's exhibiting poor performance. Using profiler,...

Just be aware that isnumeric can return true for values that can't be cast to int.

SELECT ISNUMERIC ('346E05'), ISNUMERIC ('25,2566')

SELECT CAST('346E05' AS int)

SELECT CAST('25,2566' AS int)

Why are you storing amounts in a character field? The following will work, provided there are no values in the column that are not ints.

update T

set T.saleamount=tot.Totsales

from salestable T inner...

You didn't answer Grant's...

I've been having a similar thing recently while running CheckDB and have attributed it to overloading the IO subsystem. I've know for some time that I'm straining the disks.

What I...

Ratheesh.K.Nair (10/23/2007)

---

Better try to find out the reason as Maverick said ,If ur sole aim is to shrink the log the best way is

change ur database recovery model...

B.SC in computer science and physics. I wanted to go into physics, but there are very few jobs in that field in this country except teaching.

Currently working on my Masters...