• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

tvanzele

Member since 03/29/2010

25 snippets

View their favorites

Their Tags

PROfile

All time reputation: 3

tvanzele's Recent Snippets Tagged 'sql'

• All / 
• JavaScript / 
• HTML / 
• PHP / 
• CSS / 
• Ruby / 
• Objective C

1. List of current sessions causing blocking

   SQL sql DMV saved by 1 person
   posted on May 17, 2010 by tvanzele

2. list of current locks

   SQL sql DMV saved by 1 person
   posted on May 17, 2010 by tvanzele

3. Get current users and connection type

   SQL sql DMV saved by 1 person
   posted on May 11, 2010 by tvanzele

4. Collection of I/O specific DMV's

   SQL sql DMV saved by 1 person
   posted on May 10, 2010 by tvanzele

5. Index Read/Write/Fill Factor stats (current DB)

   SQL sql DMV saved by 1 person
   posted on April 17, 2010 by tvanzele

6. List of recovery model, log reuse wait description, log file size, log usage size and compatibility level for all databases on i

   SQL sql DMV saved by 1 person
   posted on April 16, 2010 by tvanzele

7. List of single-use, ad-hoc queries that are bloating the plan cache

   SQL sql DMV saved by 1 person
   posted on April 16, 2010 by tvanzele

8. Display logfile size and usage via dmv

   SQL sql DMV
   posted on April 15, 2010 by tvanzele

9. Display logfile size and usage via dbcc

   SQL sql
   posted on April 14, 2010 by tvanzele

10. Display Missing Indexes of the Current DB ordered by Index Advantage

    SQL sql DMV saved by 3 people
    posted on April 12, 2010 by tvanzele

11. Page and row-count information for every partition in the current database

    SQL sql DMV saved by 1 person
    posted on April 12, 2010 by tvanzele

12. Cached SPs By Total Physical Reads (SQL 2008 only)

    SQL sql 2008 DMV
    posted on April 12, 2010 by tvanzele

13. Get current users and # sessions

    SQL sql DMV saved by 1 person
    posted on April 2, 2010 by tvanzele

14. Find tables without a clustered index

    SQL sql index DMV saved by 2 people
    posted on April 1, 2010 by tvanzele

15. Index fragmentation in all db's per instance

    SQL sql DMV saved by 2 people
    posted on March 31, 2010 by tvanzele

16. Who is connected via SQL DAC

    SQL sql DMV
    posted on March 31, 2010 by tvanzele

17. Wait stat list (user sessions)

    SQL sql DMV saved by 1 person
    posted on March 31, 2010 by tvanzele

18. Percentage of IO for each database and per driveletter

    SQL sql DMV
    posted on March 30, 2010 by tvanzele

19. Percentage of IO for each database

    SQL sql DMV
    posted on March 30, 2010 by tvanzele

20. Open transactions with text and plans

    SQL sql DMV
    posted on March 29, 2010 by tvanzele

21. Cached Query Plans per object type

    SQL sql DMV saved by 1 person
    posted on March 29, 2010 by tvanzele

22. Cached Query Plans

    SQL sql DMV saved by 1 person
    posted on March 29, 2010 by tvanzele

23. Buffer pool usage per database

    SQL sql DMV saved by 1 person
    posted on March 29, 2010 by tvanzele

24. Cache usage

    SQL sql DMV saved by 1 person
    posted on March 29, 2010 by tvanzele

25. Memory Clerks & used vas

    SQL sql DMV
    posted on March 29, 2010 by tvanzele