Viewing 15 posts - 346 through 360 (of 709 total)
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.
July 3, 2011 at 5:34 pm
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...
July 3, 2011 at 5:19 pm
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...
July 3, 2011 at 5:06 pm
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...
July 3, 2011 at 5:03 pm
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...
July 3, 2011 at 4:31 pm
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...
June 28, 2011 at 4:24 pm
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...
June 27, 2011 at 2:34 pm
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...
June 27, 2011 at 4:51 am
The inserts look like:
insert into ScanTable (field, field, field, field, field,) values
("value","value","value","value","value")
Have you tried the database setting 'Force Paramaterization'? Turning that on for the database should turn those calls into...
June 20, 2011 at 5:15 am
viduvs (6/16/2011)
"The SQL Server service terminated with service-specific error 17058 (0x42A2)"
Application logs show up an error that it...
June 17, 2011 at 2:48 pm
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)
June 9, 2011 at 1:28 pm
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...
June 8, 2011 at 3:26 pm
Get rid of the WHERE clause and you'll see the sys.partition_stats query return data similar to sp_spaceused.
-Eddie
June 6, 2011 at 12:08 pm
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 =...
May 28, 2011 at 2:14 am
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
...
May 23, 2011 at 4:34 pm
Viewing 15 posts - 346 through 360 (of 709 total)