tedschoenling.blogspot.com
Thoughts of the Terrible Ted: November 2009
http://tedschoenling.blogspot.com/2009_11_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Monday, November 23, 2009. Transactional Replication vs Log Shipping. I plan on writing a bit more on this in the future. Perhaps I am way behind the curve here (as I have been using Merge Replication on rather 'smallish' databases for the past several years) But I have been tasked with replacing our poorly cobbled together reporting database structures with something that doesn't take 9 hours a day to process. So I go to test SQL ...
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: October 2009
http://tedschoenling.blogspot.com/2009_10_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Friday, October 09, 2009. Tooting my own horn. So I had a developer run up to me yesterday and exclaim "Dude, you have to check SQL Server Central out, they have an article about that thing you fixed like a year ago". Http:/ www.mssqltips.com/tip.asp? I know there is some ugliness here but here goes the code, it has been in production for a while with no mods! Program.: SSRS ScheduledReportsStatus. Author.: Ted E. Schoenling. SubnO...
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: February 2010
http://tedschoenling.blogspot.com/2010_02_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Friday, February 12, 2010. I can't take credit for finding these but man they are the bees knees. Http:/ www.sqlsolutions.com/downloads/sql-heartbeat/Download.html. Searches the DB code for text. Http:/ www.red-gate.com/products/SQL Search/index.htm. I really LOVE SQL Heartbeat. It shows a stack graph of waits, a line graph of Seek Time (Reads and Writes) a line graph of Physical Reads and Writes, a line graph of Cache Hits. It has...
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: July 2009
http://tedschoenling.blogspot.com/2009_07_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Wednesday, July 29, 2009. Just an FYI, the SQL 2008 cluster has been alive for a week and a half now, and we have even done a maint window OS patch on it. Works like a champ. I had to work through the normal SQL 2000 to SQL 2008 performance nightmares, poor or non-existent indexing (inherited databases ya know) and refreshing of stats along with the rebuilding of some key indexes. Posted by Ted Schoenling at 3:45 PM. It is normally...
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: June 2009
http://tedschoenling.blogspot.com/2009_06_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Friday, June 05, 2009. Windows 2008 Desktop hangs (RDC Will not connect). The desktop would never show. after 5 minutes the session would 'lock' and ask me to provide my credentials. Still no desktop. We tried the console, no dice. We tried the DRAC, no dice. Force a reboot, try again. Look at the logs nada. nothing. Well my Microsoft tech guy called but I missed the call. Good thing! So, lesson time. Even tho Windows 2008 is m...
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: September 2009
http://tedschoenling.blogspot.com/2009_09_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Friday, September 18, 2009. SQL Server, Parallelism and Simple Queries. We all marveled when Martin wrote a seemingly simple query that simply brought our OLTP cluster to its knees. How on earth did he manage to spawn so many threads and peg all 8 cores of our massive new cluster server? What could possibly cause all of these problems? One word, Parallelism. What, pray tell, is Parallelism? What causes this to be so slow? The act o...
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: March 2009
http://tedschoenling.blogspot.com/2009_03_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Wednesday, March 11, 2009. Adventures in SQL 2008 Clustering on Windows 2008. So I’m sure most of you (who follow these things) were possibly aware of much of what I’m sayin, but it was news to me. Different to 2008 clustering (from what I was used to in 2000 clustering). Odd settings (to me) that caused me grief for testing:. Setupexe /q /ACTION=AddNode /INSTANCENAME=". 15 min retry time for network failover. I was assured by ...
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: August 2009
http://tedschoenling.blogspot.com/2009_08_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Wednesday, August 12, 2009. Some (new to me) SQL 2008 quirks. Let's just say that I inherited a bunch of really optimistic (naive? Code on the half a dozen or so SQL 2000 servers at my company. Um right. That makes lots of assumptions on the security side (do the SID's match, are there the proper logins etc) not to mention the fact that performance over a linked server leaves a lot to be desired. So when it is boiled down we have.
tedschoenling.blogspot.com
Thoughts of the Terrible Ted: May 2009
http://tedschoenling.blogspot.com/2009_05_01_archive.html
Thoughts of the Terrible Ted. A rambling mess of what is between my ears. Wednesday, May 06, 2009. More SQL 2008 Clustering. So it has been a while since I've posted because, well, I had little to report. I have discovered a couple odd little things that the upgrade adviser missed when upgrading from a SQL 2000 to SQL 2008 server, but nothing to write home about. 2 weeks later it happened again. No logs. So we called Microsoft. They hadn't a clue. They looked at our configuration, and our...We know it is...
