Useful SQL snippets. Mostly for MSSQL
Switch branches/tags
Nothing to show
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
CreateIndices.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
DBDocumentation_ext_properties.sql Updated files and cleaned the directory. May 18, 2011
DBLevelUserPermissions.sql Initial check in. Feb 2, 2011
DBLevelUserPermissions2.sql Initial check in. Feb 2, 2011
DMartComponenetExecutionTimes.sql Initial check-in. Oct 7, 2012
DMartComponentLoggingPivots.sql Initial check-in. Oct 7, 2012
DailyStats.sql Updated files and cleaned the directory. May 18, 2011
DexmaSitesQueries.sql Initial check-in. Oct 7, 2012
DriveSpace.sql Initial check-in. Oct 7, 2012
Generate_Weekly_Perfmon.sql Added new files. May 18, 2011
IPMonVerificationMaster.sql Initial check-in. Oct 7, 2012
IndexMaintenance.sql Initial check-in. Oct 7, 2012
IndexMissingNotes.sql Initial check-in. Oct 7, 2012
IndexUsage.sql Initial check-in. Oct 7, 2012
LogShippingTesting.sql Initial check in. Feb 2, 2011
MaintenanceSolution.sql Initial check in. Feb 2, 2011
OrphanedUserCleanup_bits.sql Initial check-in. Oct 7, 2012
ProgressQueries.sql Initial check-in. Oct 7, 2012
RealECOrdersBy30days.sql Initial check in. Feb 2, 2011
RegExExamples.sql Initial check-in. Oct 7, 2012
ReplicationMonitor_enumeratequery.sql Initial check in. Feb 2, 2011
ReplicationMonitor_job.sql Initial check in. Feb 2, 2011
SMCIndexCheck.sql Initial check-in. Oct 7, 2012
SQLErrorLogs_queries.sql Added new files. May 18, 2011
SQLFilesAudit.sql Added new files. May 18, 2011
SQLQuery23.sql Initial check-in. Oct 7, 2012
SQLSpaceStats_bits.sql Initial check-in. Oct 7, 2012
SQLStatsQueries.sql Initial check in. Feb 2, 2011
SQL_Overview_package.sql Initial check in. Feb 2, 2011
SSISErrorsEmail.sql Initial check-in. Oct 7, 2012
ServerDefaultLocations.sql Initial check in. Feb 2, 2011
ServerInfo.sql Initial check in. Feb 2, 2011
ServerInfo_html.sql Initial check in. Feb 2, 2011
TempMigrationTablesToDelete.sql Initial check-in. Oct 7, 2012
UsefullRegEx.sql Initial check-in. Oct 7, 2012
VerifyDBFiles.sql Initial check-in. Oct 7, 2012
VerifyFiles.sql Initial check in. Feb 2, 2011
VerifyRRD.sql Initial check-in. Oct 7, 2012
add_mmessano_db_operator.sql Initial check-in. Oct 7, 2012
alter_db_logicalnames.sql Initial check in. Feb 2, 2011
attach_db_script.sql Initial check in. Feb 2, 2011
backupset_queries.sql Minor updates. Removed one file. Oct 17, 2012
blat.sql Initial check-in. Oct 7, 2012
buffer_pool_usage_by_db.sql Initial check-in. Oct 7, 2012
compare_db_powershell.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
compare_sprocs.sql Initial check-in. Oct 7, 2012
compare_tables.sql Initial check in. Feb 2, 2011
create_ScriptTableData.sql Initial check-in. Oct 7, 2012
create_columnlist.sql Multiple updates Apr 29, 2011
create_db_changeowner.sql Initial check in. Feb 2, 2011
create_db_changeowner_All.sql Initial check in. Feb 2, 2011
create_db_dropuser_All.sql Initial check-in. Oct 7, 2012
cur_sync_users_logins.sql Initial check in. Feb 2, 2011
database_execute_permissions.sql Initial check in. Feb 2, 2011
date_manipulation.sql Initial check in. Feb 2, 2011
daysCTE.sql Initial check-in. Oct 7, 2012
dbamaint_create.sql Minor updates. Removed one file. Oct 17, 2012
dbm_BackupTranLogs.sql Initial check-in. Oct 7, 2012
dbm_Find.sql Initial check-in. Oct 7, 2012
dbm_ForEachDB.sql Initial check in. Feb 2, 2011
dbm_LockTree.sql Initial check in. Feb 2, 2011
dbm_SSAJ_SQL_Server_System_Report.sql Initial check-in. Oct 7, 2012
dbm_get_waitstats_2005.sql Added new files. May 18, 2011
dbownertosa.sql Initial check in. Feb 2, 2011
default_directories.sql Initial check in. Feb 2, 2011
dmart_bits.sql Initial check-in. Oct 7, 2012
dmart_bits_IAPPBO510.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
dmart_bits_PSQLRPT10.sql Initial check in. Feb 2, 2011
dmart_bits_PSQLRPT24.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
dmart_bits_STGSQLDOC710.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
dmart_bits_STGSQLMET620.sql Initial check-in. Oct 7, 2012
drop_SQLErrorLogs_duplicates.sql Multiple updates Apr 29, 2011
drop_dbs_in_norestore.sql Initial check in. Feb 2, 2011
drop_user.sql Initial check in. Feb 2, 2011
enable_DBMail_modified.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
enum_indexes.sql Initial check-in. Oct 7, 2012
enum_permissions.sql Initial check in. Feb 2, 2011
ex_CTEExample.sql Initial check in. Feb 2, 2011
ex_GROUPBY.sql Initial check-in. Oct 7, 2012
ex_SUMbyColumn.sql Initial check-in. Oct 7, 2012
expressmaint.sql Initial check in. Feb 2, 2011
filegroup_location_per_object.sql Initial check in. Feb 2, 2011
fix_filenames.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
generate_drop_user.sql Initial check in. Feb 2, 2011
generate_drop_users.sql Initial check in. Feb 2, 2011
index_bits.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
ipmonitor_notes.sql Initial check-in. Oct 7, 2012
jobalertstoDMemail.sql Initial check in. Feb 2, 2011
jobownertosa.sql Initial check in. Feb 2, 2011
ldf_virtuallogfilescount.sql Initial check-in. Oct 7, 2012
linkedserver_bits.sql Initial check-in. Oct 7, 2012
log_statistics.sql Initial check in. Feb 2, 2011
mandelbrot.sql Initial check in. Feb 2, 2011
perfmon_bits.sql Initial check in. Feb 2, 2011
perfmon_bits2.sql Initial check in. Feb 2, 2011
permissions_db.sql Added new files. May 18, 2011
pivot_examples.sql Initial check-in. Oct 7, 2012
pop_perfmon_new.sql Added new files. May 18, 2011
pr_RebuildIndexes.sql Initial check in. Feb 2, 2011
proc_controller.sql Added new files. May 18, 2011
project_status.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
replication_monitor_sp.sql Initial check in. Feb 2, 2011
replication_query.sql Initial check in. Feb 2, 2011
role_details.sql Initial check-in. Oct 7, 2012
script_db_permissions.sql Initial check-in. Oct 7, 2012
script_role_perms.sql Initial check-in. Oct 7, 2012
script_user_perms.sql Initial check-in. Oct 7, 2012
sel_DeadLinkedServers.sql Initial check-in. Oct 7, 2012
sel_IndexFragmentationByDatabase.sql Initial check-in. Oct 7, 2012
sel_IndexesMissingByDatabase.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
sel_IndexesUnusedByDatabase.sql Initial check-in. Oct 7, 2012
server_correlate.sql Initial check in. Feb 2, 2011
setSIMPLERecovery.sql Initial check in. Feb 2, 2011
set_dboptions2008.sql Initial check in. Feb 2, 2011
shrink_dbs.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
shrink_dbs_to_used_size.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
sp_FindMag.sql Initial check-in. Oct 7, 2012
sp_IndexDefragAndRebuild.sql Added new files. May 18, 2011
sprocswithservernames_bits.sql Initial check in. Feb 2, 2011
t_component_bits.sql Initial check in. Feb 2, 2011
t_monitoring_bits.sql Initial check-in. Oct 7, 2012
table_info.sql Initial check in. Feb 2, 2011
table_size.sql Signed-off-by: Michael J. Messano <mmessano@mortgagecadence.com> Aug 5, 2013
udf_ConvertBytes.sql Initial check in. Feb 2, 2011
udf_TableDate.sql Added new files. May 18, 2011
udf_split.sql Initial check in. Feb 2, 2011
umsstats.sql Updated files and cleaned the directory. May 18, 2011
verifySQLFiles.sql Initial check in. Feb 2, 2011
vwTableInfo.sql Initial check in. Feb 2, 2011