Viewing 15 posts - 331 through 345 (of 700 total)
Having 512GB of memory lets me think you have a lot of CPUs in that box as well.
If you're seeing loads of CMEMTHREAD waits in SQL Server 2008 R2 on...
August 10, 2011 at 2:27 pm
Simply put, one or more of the varchar values you are converting to datetime won't convert - it's just a case of bad data. A value like '1/1/10000' looks like...
July 4, 2011 at 4:23 pm
A CXPACKET wait is experienced by a thread in a parallel query after it has finished its portion of the work, and is waiting for the other threads to complete...
July 4, 2011 at 4:14 pm
You're on the right track.
Please see this post for some more info:
http://www.sqlservercentral.com/Forums/Topic1025419-1292-1.aspx#bm1025536
-Eddie
July 4, 2011 at 3:56 pm
I'm just jumping in to stir stuff up 🙂
First, I'm goin g to agree with Kevin that an HP consultant is a nice way to spend money without getting results....
July 3, 2011 at 6:10 pm
To answer some questions:
1. Win2008 will take care of the partition alignment (default = 1MB), so you're correct there. Nothing to mess with.
As for the GUID partitions, read the heck...
July 3, 2011 at 5:55 pm
tfifield (6/30/2011)
That one is bloody brilliant! It would never have occurred to me to use an OUTPUT clause from an UPDATE for an INSERT.
Remind me to buy you a...
July 3, 2011 at 5:43 pm
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
Viewing 15 posts - 331 through 345 (of 700 total)