Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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

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

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