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

...

The link only gets you so far, as you have to pivot the results because your elements are key-value pairs instead of named elements.

I saw nothing in the sample xml...

Best case for physical disk drives: 100-150 IOPS per drive.

SSDs put up much bigger numbers; individual drives hitting 100,000 IOPS or better on the right benchmarketing loads.

What is more important...

For disk transfer rates, look at the DMF sys.dm_io_virtual_file_stats. The values are cumulative, so you need to sample it over a time range a diff the values.

As for network transfer...

SQL Server Mirroring on Window 2003 servers can see all sorts of networking problems if you have installed Windows Server 2003 SP2, which auitomatically turns on something called the...

Are you running the RTM version of SSMS 2005? That was the case with the original version, to present 'look, we're more secure this way', but after everyone howled about...

What's also important is to not look at this DMF for the whole time the server has been up - idle periods flatten the spikes out. For this data to...

I ignore io_stall and only look at the different read and write stalls. The io_stall number is rather out of whack with those two, and gives me no useful data....

There is a way of scripting out all of the statistics. I haven't used the scripts to build a database for testing, only for sending the results to Microsoft Support...