Login / Register

Share Snipplr

Follow @Snipplr

Welcome To Snipplr

Everyone's Recent SQL Snippets Tagged sql

« Prev 1 ... 8 9 10 11 12 Next »

SQL Index fragmentation in all db's per instance

sql

2 83 posted 10 years ago by tvanzele

SQL Who is connected via SQL DAC

sql

0 57 posted 10 years ago by tvanzele

SQL Wait stat list (user sessions)

sql

1 83 posted 10 years ago by tvanzele

SQL Percentage of IO for each database and per driveletter

sql

0 90 posted 10 years ago by tvanzele

SQL Percentage of IO for each database

sql

0 64 posted 10 years ago by tvanzele

SQL Open transactions with text and plans

sql

0 85 posted 10 years ago by tvanzele

SQL Cached Query Plans per object type

sql

1 70 posted 10 years ago by tvanzele

SQL Cached Query Plans

sql

1 74 posted 10 years ago by tvanzele

SQL Buffer pool usage per database

sql

1 65 posted 10 years ago by tvanzele

SQL Memory Clerks & used vas

sql

0 66 posted 10 years ago by tvanzele

SQL TSQL - Find All Empty Columns in a Database

I found this and simply want to store it. It was done by Valentino Vranken

sql

2 370 posted 10 years ago by ezerick

SQL SQL: Create a user that has only access to one database

creates a user that has only access to one database, from any host

sql

1 162 posted 10 years ago by manuelstofer

SQL Create UTF8 Database

Create a new utf8 database in MySQL

sql

1 87 posted 10 years ago by manuelstofer

SQL Finding duplicates with SQL

Here's a handy query for finding duplicates in a table.

sql

3 123 posted 10 years ago by jmiller

SQL Search Stored Procedure for String

sql

1 111 posted 10 years ago by CDIDevs

SQL List all Stored Procs in Database

sql

1 146 posted 10 years ago by CDIDevs

SQL Re-seed Identity Table

Re-seed identity table if rows were deleted/there are gaps in numerical order

sql

2 79 posted 10 years ago by CDIDevs

SQL Script table as INSERTS

sql

1 103 posted 10 years ago by CDIDevs

SQL Search Database for string

sql

2 124 posted 10 years ago by CDIDevs

SQL Search Database for Column Name

sql

1 133 posted 10 years ago by CDIDevs

SQL Calculating distance in Kilometres and Miles from Latitude and Longitude

Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth.

sql

3 165 posted 10 years ago by zingo

SQL Joomla admin password reset

Reset joomla super admin password to â€adminâ€œ

sql

1 98 posted 10 years ago by elisium

SQL Create a Temporary table within a SQL Stored Procedure

A Temp table is great for combining multiple SELECT statements in a Sproc and outputting as just one table. Don't forget to Drop the table after the SELECT * FROM #TempTableName at the end.

sql

2 164 posted 10 years ago by highlyevolved

SQL Convert Date/Time in SQL

These statements convert a date/time field into just a date or a time field

sql

2 136 posted 10 years ago by highlyevolved

SQL Get Plesk FTP account passwords w/o logging into MySQL

sql

0 84 posted 10 years ago by tobewan

SQL Grab Plesk FTP account passwords

sql

0 75 posted 10 years ago by tobewan

SQL Delete All Foreign Keys

Delete All Foreign Keys in a database; (make sure you USE keyword)

sql

2 73 posted 10 years ago by marcocs

SQL Create New User and Grant

sql

1 92 posted 11 years ago by wearetherock

SQL TSQL Convert DateTime

I am forever forgetting this. Have to look up the 101 vs 103 in books online every time. Also forget which way around is US/NZ format. :-)

sql

1 128 posted 11 years ago by rengber

SQL TSQL to Get the SQL Autonumber ID of the Row Just Inserted

Dead simple, but often forgotten.

sql

1 133 posted 11 years ago by rengber

« Prev 1 ... 8 9 10 11 12 Next »