SQL Server and Poker
I know there are a few poker playing DBA’s out there. Andy, Chris and Peter to name a few. I have uncovered what would be equivalent to unmasking batman.
The mild mannered SQL Server Ambassador,Kevin Kline, is really Daniel Negreanu, the high stakes Vegas hustler.
RE: The SQL Server Experience
It is live and the funnies are here.
Notebook opinions?
I am thinking about this for my new laptop since my existing one is out warranty and I want more power. I have looked as Dell, HP and Sonys. The t9400 proc and DDR3 memory is what does it for me. Any other ones I should be looking at?
P.s Anyone want to buy a slightly used 17 inch dv9335nr? Upgraded to Mojave ultimate and 4GB of RAM.
|
|||||||||||||||||||||||||||||||||||
Introducing the SQL Server 2008 Experience
Well, not quite yet. It will hit Monday morning. They floated this press release late Friday afternoon so I figured I would scoop the blogosphere give them a plug.
There full release can be found here.
Editor’s note: the Web site referenced below will not be live until 8:00 a.m. PDT, Sept. 29.
REDMOND, Wash. — Sept. 26, 2008
What: On Monday, Sept. 29, Microsoft is launching the SQL Server 2008 Experience online at http://www.SQLServerExperience.com. With more than 500 short videos in 11 different languages, the SQL Server 2008 Experience is a Web site that helps Microsoft’s global customers and partners learn more about SQL Server 2008, Microsoft’s recently released data management and business intelligence platform. SQL Server 2008 provides a trusted, productive and intelligent data platform for business-critical applications. The launch of the SQL Server 2008 Experience kicks off a worldwide readiness outreach that will reach over 350,000 customers, partners and community members through in-person events over the next year.
Visitors to the SQL Server 2008 Experience can expect the following:
• Brief interviews with the SQL Server Engineering team, providing a behind-the-scenes view of the many technologies in SQL Server 2008
• Guidance on a wide range of topics such as business intelligence, compliance, upgrades and application development, including videos from customers showing how SQL Server 2008 is helping them be more successful. Customers that will be featured include Xerox Corp., Baltika Breweries and DriveCam Inc.
• Great deals on SQL Server 2008 books, courses and exams offered by Microsoft Learning
When: Sept. 29, 2008, at 8 a.m. PDT
Where: Online at http://www.SQLServerExperience.com
Capt. Varchar(MAX) and the Pagelatch Posse Vol. 10
SQLOS uses a cooperative scheduler. They actually wrote it from the ground up because it performs better than the Windows preemptive scheduler. KenH(R.I.P.) describes it way better than I can here. It was written for SQL 2000 but is still pretty applicable.
Less Signal Wait. More CPU lovin’
Maybe I will come up with something funny next week. Happy Friday!
This comic was adapted from Office OFFline.
This Post Needs More Stored Procedures
New in SQL Server 2008 is a server setting called “Optimize for adhoc workloads”. I was happy to see this. You should be too especially if you have ever had arm wrestle an app that causes a bloated proc cache on an x86 box. Ugghh… Adam blogged on it here, Bob blogged on it here and here is the documentation.
I was wondering how this setting would play with the forced parameterization database setting. It looks like forced parameterization trumps the new server wide setting. If my simple tests below are right, it could present an interesting problem. What if your app generates a lot of totally unique adhoc queries that have no benefit from parameterization and you have queries that would benefit from parameterization? Well, the answer is still the same. Write stored procedures. 
In the real world, sometimes you get a pig and all you can do is put lipstick on it. If you have to choose, “Optimize for Adhoc” would most benefit memoryIO bound servers while “forced parameterization” could help both the CPU and memory usage. However, that is a very general statement. Other things should be considered so it will depend.
--So what happens when you turn on "Optimize for adhoc" and forced parameterization exec sp_configure 'show advanced options', 1reconfigure with overridegoexec sp_configure 'optimize', 1reconfigure with override alter database master set parameterization forceddbcc freeproccache–Let’s run a query will not generate a trivial plan.
select name, object_id, create_datefrom sys.all_objects
where object_id = 3 and create_date = ‘2008-07-09 16:19:59.943′
go
–The CacheObjType is a compiled plan and 57344 bytes
select p.cacheobjtype, p.size_in_bytes , s.*from sys.dm_exec_query_stats s
join sys.dm_exec_cached_plans p
on s.plan_handle = p.plan_handle
cross apply sys.dm_exec_sql_text(sql_handle)
where text like ‘%select name , object_id , create_date from%’
–Now, let’s turn off forced parameterization
alter database master set parameterization simple
dbcc freeproccacheselect name, object_id, create_date
from sys.all_objectswhere object_id = 3 and create_date = ‘2008-07-09 16:19:59.943′
go
–The CacheObjType is a Compiled Plan Stub and 320 bytes
select p.cacheobjtype, p.size_in_bytes , s.*from sys.dm_exec_query_stats s
join sys.dm_exec_cached_plans p
on s.plan_handle = p.plan_handle
cross apply sys.dm_exec_sql_text(sql_handle)
where text like ‘%select name , object_id , create_date from%’
The 1st Cumulative for SQL Server 2008 is out
Time flies. Just by eyeballing the fix list, it looks like the majority of the fixes are for the new features and the BI stack. That is good news if you are thinking about a bleeding edge upgrade of an existing app.
There are two fixes that I find notable:
- (A data scribbler?) 50003453 – no KB yet – When you programmatically retrieve data from a SQL Server 2008 database, the data in memory may be overwritten
- 50003224 – 926292 – FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order
The second one is a behavior change that could cause some headaches.
SYMPTOMS
You have a view in a database in SQL Server 2005 or SQL Server 2008. In the definition of the view, the SELECT statement meets the following requirements:
• The SELECT statement uses the TOP (100) PERCENT expression.
• The SELECT statement uses the ORDER BY clause.
When you query through the view, the result is returned in random order. However, this behavior is different in Microsoft SQL Server 2000. In SQL Server 2000, the result is returned in the order that is specified in the ORDER BY clause.
Hmm, I thought that worked on SQL 2005. I bet someone had to scream _really loud_ to get that one in.
A SQLCLR Twitter Client
The product is TweetSQL. It is not out yet but you can see some details here and follow @rhyscampbell. You probably just uttered a profanity at the thought of it on production server. I did when I first heard of it. I even had a day dream moment where I pictured myself going all street fighter on a jr DBA who installed it prod box. Sure, install it on your test box and tweet when you do something cool like write a custom policy with ExecuteSQL() or write a script to only generate indexes. But production? Hell no.
Later, @AlanBarber made a point.
@statisticsio we’re using twitter right now for status and error messages at my company. Surprisingly a nice tool to keep tabs on everything
Hhrmm, I do use twitter to communicate more than the telephone. Maybe not as much email and IM yet but if the bread and butter database fails over, some one better reach out an touch me. More ways the better. Email, SMS, and a phone call from the monitoring already happens. Why not a tweet too? This could be especially important if you do not have SMS capabilities by default. Of course, this is not something you want to go crazy with and pay attention to security. The launch of Yammer whose focus is the enterprise could bring about more usage like this.
I will tell you this… There is not much worse than having your boss call you to tell you there is a major SQL outage. The conversation goes so much better when you call him to let him know there is a problem with the SQL Server and you are on it like a hound dog on a pork chop.
Capt. Varchar(MAX) and the Pagelatch Posse Vol. 9
How many times have you heard “Cursors are evil”? Well, +1.
A cursor vs. set based solution
Happy Friday.
This comic was adapted from Office OFFline.
How do you Roll?
Ok, one more OT post. The OS war is heating up with Microsoft fighting back.
vs.
I am not trying to start an eFight. I agree that Mac’s have their place. They are great for n00bs and grandma’s.
My RSS
-
My LifeStream
My Presence
