code snippets
all code snippets
/
popular code snippets
/
your code snippets
blog
privacy
about snipplr
New Snippet
/
Register
/
Login
Advanced Search
tvanzele
Member since 03/29/2010
24 snippets
1337 profile views
0 Comment(s) Posted
View their
favorites
their Tags
sql
Profile
Achievement
tvanzele's Recent Snippets
All
/
« Prev
1
Next »
SQL
List of current sessions causing blocking
sql
1
725
posted 14 years ago by
tvanzele
SQL
list of current locks
sql
1
689
posted 14 years ago by
tvanzele
SQL
Get current users and connection type
sql
1
759
posted 14 years ago by
tvanzele
SQL
Collection of I/O specific DMV's
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
sql
1
611
posted 14 years ago by
tvanzele
SQL
Index Read/Write/Fill Factor stats (current DB)
sql
1
753
posted 14 years ago by
tvanzele
SQL
List of recovery model, log reuse wait description, log file size, log usage size and compatibility level for all databases on i
sql
1
1161
posted 14 years ago by
tvanzele
SQL
List of single-use, ad-hoc queries that are bloating the plan cache
sql
1
785
posted 14 years ago by
tvanzele
SQL
Display logfile size and usage via dmv
sql
0
731
posted 14 years ago by
tvanzele
SQL
Display logfile size and usage via dbcc
sql
0
642
posted 14 years ago by
tvanzele
SQL
Display Missing Indexes of the Current DB ordered by Index Advantage
sql
3
869
posted 14 years ago by
tvanzele
SQL
Page and row-count information for every partition in the current database
sql
1
1019
posted 14 years ago by
tvanzele
SQL
Cached SPs By Total Physical Reads (SQL 2008 only)
sql
0
719
posted 14 years ago by
tvanzele
SQL
Get current users and # sessions
sql
1
790
posted 14 years ago by
tvanzele
SQL
Find tables without a clustered index
sql
2
887
posted 14 years ago by
tvanzele
SQL
Index fragmentation in all db's per instance
sql
2
729
posted 14 years ago by
tvanzele
SQL
Who is connected via SQL DAC
sql
0
637
posted 14 years ago by
tvanzele
SQL
Wait stat list (user sessions)
sql
1
616
posted 14 years ago by
tvanzele
SQL
Percentage of IO for each database and per driveletter
sql
0
802
posted 14 years ago by
tvanzele
SQL
Percentage of IO for each database
sql
0
682
posted 14 years ago by
tvanzele
SQL
Open transactions with text and plans
sql
0
801
posted 14 years ago by
tvanzele
SQL
Cached Query Plans per object type
sql
1
676
posted 14 years ago by
tvanzele
SQL
Cached Query Plans
sql
1
676
posted 14 years ago by
tvanzele
SQL
Buffer pool usage per database
sql
1
641
posted 14 years ago by
tvanzele
SQL
Memory Clerks & used vas
sql
0
635
posted 14 years ago by
tvanzele
« Prev
1
Next »
Choose a language for easy browsing:
ActionScript
ActionScript 3
Apache
AppleScript
ASP
Assembler
AutoIt
Awk
Bash
C
C#
C++
Clojure
ColdFusion
CSS
Delphi
Diff
Django
DOS Batch
Emacs Lisp
eZ Publish
Forth
Fortran
Gnuplot
Groovy
HAML
Haskell
HTML
iPhone
Java
JavaScript
jQuery
LaTeX
lighttpd
Lisp
Lua
Makefile
MatLab
Maxscript
Mel
MXML
MySQL
NewtonScript
Objective C
Open Firmware
Other
Pascal
Perl
PHP
PicBasic
PL/SQL
Processing
Prolog
Pseudocode
Python
R
Rails
Regular Expression
Revolution
Ruby
SAS
SASS
Scala
Scheme
SmallTalk
Smarty
SML
SPSS
SQL
SVN
Symfony
TCL
Textpattern
TYPO3
VB.NET
VHDL
Visual Basic
W-Language
Windows PowerShell
Windows Registry
XHTML
XML
XSLT