Subscribe to this blog
Archives: March 2008
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is fairly innocuous. No harm, no foul, right?
Updating your procedures to not use Select * can be a daunting task. Here's a tip to help you work smarter, not… Read more
0 comments, 482 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 28 March 2008
Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is fairly innocuous. No harm, no foul, right?
But what about those precious milliseconds lost sending data across the network to client applications? That's where you start to… Read more
0 comments, 445 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 28 March 2008
The Shadow Knows What Procedures Lurk in the SQL Plan Cache
How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You can query the SQL Server dynamic management views to get a list of procedures in cache. In this example, I query sys.dm_exec_cached_plans and sys.dm_exec_sql_text:
Select object_name(st.objectid, st.dbid) As ProcedureName
From Read more
0 comments, 416 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 28 March 2008