skip to main | skip to sidebar

Kala's Blog Spot

Birds Eye Views...

Saturday, September 12, 2009

Handy sql script to find lost quries

I always forget to save the quires that I'm executing against sql server and want to recover them without writing them back, here's a handy script which I use for this

select objtype,p.size_in_bytes,[sql].text
from sys.dm_exec_cached_plans p
outer apply sys.dm_exec_sql_text (p.plan_handle) sql
where [sql].[test] like '%Something goes here%'
order by usecounts desc
Posted by Kalhara at 8:27 PM

2 comments:

Anonymous said...

Danke sehr an den Webmaster.

Gruss Nadja

5:07 AM
Unknown said...

Jual obat aborsi Jual obat cytotec
Obat aborsi cytotec Jual obat penggugur kandungan
Jual obat telat bulan Jual obat asli cytotec
Pills aborsi janin Pills cytotec
Aborsi paket 1 bulan Aborsi paket 2 bulan
Aborsi paket 3 bulan Aborsi paket 4 bulan
Aborsi paket 5 bulan Aborsi paket 6 bulan


Paket obat aborsi usia 1 - 6 bulan

Dosis obat aborsi

Harga obat aborsi


Jual obat aborsi bandungan Jual obat aborsi samarinda
Jual obat aborsi kediri Jual obat aborsi lamongan
Jual obat aborsi singapura Jual obat aborsi hongkong
Jual obat aborsi sumedang Jual obat aborsi wonosari
Jual obat aborsi seleman Jual obat aborsi gunung kidul
Jual obat aborsi palopo Jual obat aborsi papua
Jual obat aborsi jayapura Jual obat aborsi jepara
Jual obat aborsi rembang Jual obat aborsi kudus
Jual obat aborsi demak Jual obat aborsi jember
Obat aborsi Obat cytotec
Pills cytotec Jual obat aborsi asli

10:53 PM

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

My photo
Kalhara
View my complete profile

Labels

  • .NET (8)
  • ASP.NET (3)
  • ADO.NET (1)
  • DNN (1)
  • Patterns (1)
  • Personal (1)
  • Tips (1)

Blog Archive

  • ▼  2009 (3)
    • ▼  September (2)
      • Designing UI applications
      • Handy sql script to find lost quries
    • ►  June (1)
  • ►  2007 (18)
    • ►  December (1)
    • ►  November (1)
    • ►  June (3)
    • ►  May (4)
    • ►  April (3)
    • ►  March (3)
    • ►  February (1)
    • ►  January (2)
  • ►  2006 (2)
    • ►  October (1)
    • ►  June (1)

Friends

  • Chamindu
  • Indika
  • Hasith
  • Merill

Favorite Links

  • ADO.NET Team
  • Rafik Robeal's
  • David
  • Scottgu