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...

Yup. That's correct.

If you don't need to be able to make point-in-time restores, then you can change to simple recovery mode. In simple the log auto truncates on checkpoints.

Look at sp_executesql

DECLARE @ReturnValue DATETIME, @EmployeeID INT

SET @EmployeeID = 1

exec sp_executesql N'SELECT @JoinDate = JoinDateQuery NewHireEmployee where empid = @EmpID ',

N'@EmpID int, @JoinDate DATETIME OUTPUT', @EmpID = @EmployeeID, @JoinDate...

What you're seeing in parallelism waits. Is there a wait type of CXPacket?

iirc, the display of spids blocking themselves was new in SP3 or 4. Before that you wouldn't see...

rhunt (10/22/2007)

---

Great, thanks. I thought the whole AWE issue was resolved with Server 2003...guess not. I did find info that said it would be on if my system...