Skip to content

Instantly share code, notes, and snippets.

@kappa7194

kappa7194/prestazioni.sql

Created December 12, 2011 09:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kappa7194/1466220 to your computer and use it in GitHub Desktop.
Save kappa7194/1466220 to your computer and use it in GitHub Desktop.
Download ZIP
Query per prestazioni
Raw
prestazioni.sql
dbcc dropcleanbuffers
dbcc freeproccache
select a.IdErrore, a.Url, a.[Description], a.[File], a.Line
from dbo.Errori a
left join dbo.ErroriSql b on b.[Description] = a.[Description]
where b.[Description] is null and a.Data >= '2011-12-12' and a.Data < '2011-12-13' and a.Url like '%tracking%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment