Viewing 15 posts - 346 through 360 (of 708 total)
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
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...
May 23, 2011 at 4:09 pm
Viewing 15 posts - 346 through 360 (of 708 total)