sys.dm_db_task_space_usage

the space usage is only for tempdb, so any session with an entry here is consuming tempdb space.

Session_id corresponds to session_id in sys.dm_exec_connections and sys.dm_exec_sessions.

Congrats! 🙂

Remember, folks, that certification isn't necessarily proof of expertise, but proof to yourself that you can go outside your comfort zone and learn new things.

It's also proof to employers...

agreeing with Patrick in a big way (wait stats is the key to, um, well, everything)

If you see lots of CMEMTHREAD (not a normal wait) then it's off to patch...

Provided you are formatting the disk with Windows2008 (just guessing, you're using SQL2008 so I hope you're also using Win2008), you'll get an automatic disk partition offset of 1MB. Leave...

check the wait type of the running statements when things are spiking in CPU... if you seed a lot of CMEMETHREAD waits then you could be hitting a bug in...

The PK violation is error severity 14 - it's a correctable error that leaves the XACT_STATE() value at 1.

The better colution is to not program by exception, to not use...

I've spoken about this at a few SQL Saturdays and SQL Rally (or at least it's been part of the presentations). This seems like a good topic for me to...

Use the XQuery .nodes method to shred the XML into a series of individual nodes, then the XQuery .value method on those nodes to extract values that can be manipulated...

Have you tried the database setting 'Force Paramaterization'? Turning that on for the database should turn those calls into...

viduvs (6/16/2011)

---

SQL service for that instance is not starting up giving following error:

"The SQL Server service terminated with service-specific error 17058 (0x42A2)"

Application logs show up an error that it...

Here's a hint:

SELECT ParamValues.Practices.value('../@ID','VARCHAR(20)') AS OfficeID,

ParamValues.Practices.value('@ID','VARCHAR(20)') AS PracticeID

FROM @Offices.nodes('/Offices/Office/Practice') as ParamValues(Practices)

There's a few examples in Book Online, but the key point is the Event Notifications is that there are no Events for DML.

To see all of the event types for...

Get rid of the WHERE clause and you'll see the sys.partition_stats query return data similar to sp_spaceused.

-Eddie

If I understand the question correctly, you're asking the difference between this:

LEFT JOIN V_ReportComputerDetailsSoftware r ON r.Client = c.Client

AND r.ManufacturerName = s.Mfg AND r.Product = s.Name AND r.VersionNumber =...

Being SQL Server 2008, you can use Composable DML, which lets you wrap a statement generating an OUTPUT set with another DML operation:

INSERT INTO [Sandbox].[dbo].[CarProductionHistory](CarID, BuildStateID, DateofState)

SELECT CarID, BuildStateID, DateofState

...