Skip to content

list of .sql files

Jump to bottom Edit New page
sterbalr edited this page Jul 20, 2017 · 9 revisions

Here is an a-z list of scripts on the wiki

  • Test
File Path
AutoGuessingForeignKeyConstraints.sql \Scripts\AutoGuessingForeignKeyConstraints.sql
Backup_Restore_What's_My_Status.sql \Scripts\Backup_Restore_What's_My_Status.sql
BackupRestoreTrace.sql \Extended_Events\BackupRestoreTrace.sql
BaselineCollectorSolution.sql \Solution\BaselineCollector\BaselineCollectorSolution.sql
Blocked_Session.sql \Scripts\Blocked_Session.sql
BufferPoolExtension.sql \Scripts\BufferPoolExtension.sql
CommandExecute.sql \Solution\Ola_Maintenance_Solution\CommandExecute.sql
CommandLog.sql \Solution\Ola_Maintenance_Solution\CommandLog.sql
ConvertingSQLTracetoExtendedEvents.sql \Extended_Events\ConvertingSQLTracetoExtendedEvents.sql
Count character matches.sql \Scripts\Count character matches.sql
CPU_Utilization.sql \Scripts\CPU_Utilization.sql
CPU_Utilization_Graphical_form.sql \Scripts\CPU_Utilization_Graphical_form.sql
Current_Running_Queries.sql \Scripts\Current_Running_Queries.sql
Current_Running_Tasks_and_Server_Info.sql \Scripts\Current_Running_Tasks_and_Server_Info.sql
DarkQueries.sql \Extended_Events\DarkQueries.sql
Database_Mail_Configuration.sql \Scripts\Database_Mail_Configuration.sql
DatabaseBackup.sql \Solution\Ola_Maintenance_Solution\DatabaseBackup.sql
DatabaseIntegrityCheck.sql \Solution\Ola_Maintenance_Solution\DatabaseIntegrityCheck.sql
Date Calendar Cross-Reference Table.sql \Scripts\Date Calendar Cross-Reference Table.sql
Date_Format_Cheat_Sheet.sql \Scripts\Date_Format_Cheat_Sheet.sql
DBA_sp_jobhistory_row_limiter.sql \Solution\SysJobHistory\DBA_sp_jobhistory_row_limiter.sql
DBA_sysjobhistory_config_tbl.sql \Solution\SysJobHistory\DBA_sysjobhistory_config_tbl.sql
DBA_sysjobhistory_driver.sql \Solution\SysJobHistory\DBA_sysjobhistory_driver.sql
DBA_sysjobhistory_driver_Tests.sql \Solution\SysJobHistory\DBA_sysjobhistory_driver_Tests.sql
dbWarden.sql \Solution\dbWarden\dbWarden.sql
dbWarden_UNINSTALL.sql \Solution\dbWarden\dbWarden_UNINSTALL.sql
Deadlocks.sql \Extended_Events\Deadlocks.sql
Decrypt T-SQL module.sql \Scripts\Decrypt T-SQL module.sql
DynamicallyGenerateDMAStatement.sql \Scripts\DynamicallyGenerateDMAStatement.sql
Enable Microsoft.ACE.OLEDB.12.0.sql \Scripts\Enable Microsoft.ACE.OLEDB.12.0.sql
Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql \Scripts\Estimate_When_Long_Running_SQL_Processes_Will_Finish.sql
Finding_Blocking_Queries.sql \Scripts\Finding_Blocking_Queries.sql
FindingSpecificColumns.sql \Scripts\FindingSpecificColumns.sql
FindTablesWithSimilarTableStructure.sql \Scripts\FindTablesWithSimilarTableStructure.sql
fn_recurringDates.sql \User_Defined_Function\fn_recurringDates.sql
FN_SPLIT.sql \User_Defined_Function\FN_SPLIT.sql
fnWordDifference.sql \User_Defined_Function\fnWordDifference.sql
Foreign_Key_batch_rename.sql \Scripts\Foreign_Key_batch_rename.sql
Generate_Restore_Script_From_Backup_Folder.sql \Scripts\Generate_Restore_Script_From_Backup_Folder.sql
Get_Statistics_Details.sql \Scripts\Get_Statistics_Details.sql
Get_Table_Hierarchy.sql \Scripts\Get_Table_Hierarchy.sql
GetResourceNameFromBlockedProcessReport.sql \Scripts\GetResourceNameFromBlockedProcessReport.sql
GoogleJobTimeline.sql \Scripts\GoogleJobTimeline.sql
How_old_your_backups.sql \Scripts\How_old_your_backups.sql
How_to_Find_Queries_Using_an_Index.sql \Scripts\How_to_Find_Queries_Using_an_Index.sql
Identify_All_Logins_With_No_Associated_Default_Database_User.sql \Scripts\Identify_All_Logins_With_No_Associated_Default_Database_User.sql
Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql \Scripts\Identifying_In-Memory_Objects_When_Querying_the_Transaction_Log.sql
IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql \Scripts\IdentifyObjectNameForCreateAndAlterUsingFn_dblog.sql
Identity_gap_sql_server_2012.sql \Errors\Identity_gap_sql_server_2012.sql
Index Breakdown.sql \Scripts\Index Breakdown.sql
Indexes_Script_Out.sql \Scripts\Indexes_Script_Out.sql
IndexOptimize.sql \Solution\Ola_Maintenance_Solution\IndexOptimize.sql
InstallRegex.sql \CLR\Regex\Fill_Factor\InstallRegex.sql
installRegexAssembly.sql \CLR\Regex\Fill_Factor\installRegexAssembly.sql
installRegexSample.sql \CLR\Regex\Fill_Factor\installRegexSample.sql
InvestigateWaits.sql \Extended_Events\InvestigateWaits.sql
LatchStats.sql \Scripts\LatchStats.sql
Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql \Scripts\Listing_SQL_Agent_Jobs_Running_at_a_Specific_Time.sql
LoginFailure.sql \Extended_Events\LoginFailure.sql
loop.sql \SSMS\SSMS_Snippets\loop.sql
MaintenanceSolution.sql \Solution\Ola_Maintenance_Solution\MaintenanceSolution.sql
MAXDOP_recommendation.sql \Scripts\MAXDOP_recommendation.sql
MaxServerMemoryCalculator.sql \Scripts\MaxServerMemoryCalculator.sql
Monitor_Deadlocks_with_Extended_Events.sql \Scripts\Monitor_Deadlocks_with_Extended_Events.sql
New_Default_Database_Assignment_For_Any_Login
_Missing_Their_Default_Database.sql 		\Scripts\New_Default_Database_Assignment_For_Any_Login_Missing_Their_Default_Database.sql
PowerSavingCheck.sql \Scripts\PowerSavingCheck.sql
Procedure_dynamic_create.sql \SSMS\SSMS_Snippets\Procedure_dynamic_create.sql
QueryActiveDirectory.sql \Scripts\QueryActiveDirectory.sql
Recompile_Histogram.sql \Extended_Events\Recompile_Histogram.sql
RemoveNonAlphaCharacters.sql \User_Defined_Function\RemoveNonAlphaCharacters.sql
RenameDefaultConstraints.sql \Scripts\RenameDefaultConstraints.sql
Restore_script_for_Ola_Hallengren_backup.sql \Scripts\Restore_script_for_Ola_Hallengren_backup.sql
Ring_Bufer_Analyze.sql \Scripts\Ring_Bufer_Analyze.sql
Search_Script.sql \Scripts\Search_Script.sql
seeddata.sql \Solution\SysJobHistory\seeddata.sql
Show all permissions in a database.sql \Scripts\Show all permissions in a database.sql
ShredDeadlockGraph.sql \Scripts\ShredDeadlockGraph.sql
sp_AllocationMetadata.sql \Stored_Procedure\sp_AllocationMetadata.sql
sp_Blocked_Process_Report_Viewer.sql \Stored_Procedure\sp_Blocked_Process_Report_Viewer.sql
sp_capture_login_auth.sql \Stored_Procedure\sp_capture_login_auth.sql
sp_ctrl3.sql \Stored_Procedure\sp_ctrl3.sql
sp_DBA_job_notification.sql \Stored_Procedure\sp_DBA_job_notification.sql
sp_DBPermissions.sql \Stored_Procedure\sp_DBPermissions.sql
sp_Defrag_Indexes.sql \Stored_Procedure\sp_Defrag_Indexes.sql
sp_Example_RegisterAssembly_PDFCLR.sql \Stored_Procedure\sp_Example_RegisterAssembly_PDFCLR.sql
sp_generate_merge.sql \Stored_Procedure\sp_generate_merge.sql
sp_helpExpandView.sql \Stored_Procedure\sp_helpExpandView.sql
sp_IndexAnalysis-v11.sql \Stored_Procedure\sp_IndexAnalysis-v11.sql
sp_RestoreGene.sql \Stored_Procedure\sp_RestoreGene.sql
sp_sizing.sql \Stored_Procedure\sp_sizing.sql
sp_SQLskills_ExposeColsInIndexLevels.sql \Stored_Procedure\sp_SQLskills_ExposeColsInIndexLevels.sql
sp_SQLskills_helpindex.sql \Stored_Procedure\sp_SQLskills_helpindex.sql
sp_sqltrace.sql \Stored_Procedure\sp_sqltrace.sql
sp_SrvPermissions.sql \Stored_Procedure\sp_SrvPermissions.sql
sp_WhatsupQueryStore.sql \Stored_Procedure\sp_WhatsupQueryStore.sql
Space used by object.sql \Scripts\Space used by object.sql
SpaceusedByTable.sql \Scripts\SpaceusedByTable.sql
SplitFileGroup.sql \Scripts\SplitFileGroup.sql
SplitterB_CLR.sql \CLR\SplitterB_CLR.sql
SQL Server 2005 Diagnostic Information Queries.sql \Scripts\SQL Server 2005 Diagnostic Information Queries.sql
SQL Server 2008 Diagnostic Information Queries.sql \Scripts\SQL Server 2008 Diagnostic Information Queries.sql
SQL Server 2008 R2 Diagnostic Information Queries.sql \Scripts\SQL Server 2008 R2 Diagnostic Information Queries.sql
SQL Server 2012 Diagnostic Information Queries.sql \Scripts\SQL Server 2012 Diagnostic Information Queries.sql
SQL Server 2014 Diagnostic Information Queries.sql \Scripts\SQL Server 2014 Diagnostic Information Queries.sql
SQL Server 2016 Diagnostic Information Queries.sql \Scripts\SQL Server 2016 Diagnostic Information Queries.sql
SQL Server 2017 Diagnostic Information Queries.sql \Scripts\SQL Server 2017 Diagnostic Information Queries.sql
SQL_Server_Fixed_Role_Permissions.sql \Scripts\SQL_Server_Fixed_Role_Permissions.sql
sqlg_ParseDiskskpXml.sql \Stored_Procedure\sqlg_ParseDiskskpXml.sql
system_health.sql \Extended_Events\system_health.sql
Table Count alternative.sql \Scripts\Table Count alternative.sql
Table_and_Index_storage_size.sql \Scripts\Table_and_Index_storage_size.sql
Table_upload_order.sql \Scripts\Table_upload_order.sql
Tempdb_Contention.sql \Scripts\Tempdb_Contention.sql
tempdb_Information.sql \Scripts\tempdb_Information.sql
TrackPageSplits.sql \Extended_Events\TrackPageSplits.sql
Truncate log file.sql \Scripts\Truncate log file.sql
TuneYourIndexingStrategyWithDMVs.sql \Scripts\TuneYourIndexingStrategyWithDMVs.sql
udf_2DateDiff.sql \User_Defined_Function\udf_2DateDiff.sql
udf_AlphaNumericOnly.sql \User_Defined_Function\udf_AlphaNumericOnly.sql
udf_AlphaOnly.sql \User_Defined_Function\udf_AlphaOnly.sql
udf_CalculateDistanceBetween2Coordinates.sql \User_Defined_Function\udf_CalculateDistanceBetween2Coordinates.sql
udf_CalcWorkingHours.sql \User_Defined_Function\udf_CalcWorkingHours.sql
udf_ConvertRangesInIntegerList.sql \User_Defined_Function\udf_ConvertRangesInIntegerList.sql
udf_DamLev.sql \User_Defined_Function\udf_DamLev.sql
udf_DateFormattedByMask.sql \User_Defined_Function\udf_DateFormattedByMask.sql
udf_DigitsOnlyEE.sql \User_Defined_Function\udf_DigitsOnlyEE.sql
udf_FindPosition.sql \User_Defined_Function\udf_FindPosition.sql
udf_ForeignKeyScript.sql \User_Defined_Function\udf_ForeignKeyScript.sql
udf_FuzzySearchOf.sql \User_Defined_Function\udf_FuzzySearchOf.sql
udf_GetNumsAB.sql \User_Defined_Function\udf_GetNumsAB.sql
udf_Haversine.sql \User_Defined_Function\udf_Haversine.sql
udf_INSTR.sql \User_Defined_Function\udf_INSTR.sql
udf_IntegerListFromRangesFunction.sql \User_Defined_Function\udf_IntegerListFromRangesFunction.sql
udf_Is16digitValidCard.sql \User_Defined_Function\udf_Is16digitValidCard.sql
udf_IsValidCard.sql \User_Defined_Function\udf_IsValidCard.sql
udf_parseJSON.sql \User_Defined_Function\udf_parseJSON.sql
udf_PatExclude8K.sql \User_Defined_Function\udf_PatExclude8K.sql
udf_PatReplace8K.sql \User_Defined_Function\udf_PatReplace8K.sql
udf_PatternSplitLoop.sql \User_Defined_Function\udf_PatternSplitLoop.sql
udf_RenderXMLToString.sql \User_Defined_Function\udf_RenderXMLToString.sql
udf_RTF2Text.sql \User_Defined_Function\udf_RTF2Text.sql
udf_SecondConvertRangesInIntegerList.sql \User_Defined_Function\udf_SecondConvertRangesInIntegerList.sql
udf_SplitStringByDelimiter.sql \User_Defined_Function\udf_SplitStringByDelimiter.sql
udf_StringComparisonsLevenshteinFull-matrix.sql \User_Defined_Function\udf_StringComparisonsLevenshteinFull-matrix.sql
udf_StringComparisonsLevenshteinString-based.sql \User_Defined_Function\udf_StringComparisonsLevenshteinString-based.sql
udf_StringComparisonsLongestCommonSubsequence.sql \User_Defined_Function\udf_StringComparisonsLongestCommonSubsequence.sql
udf_StringComparisonsMetaphoneAlgorithm.sql \User_Defined_Function\udf_StringComparisonsMetaphoneAlgorithm.sql
udf_strtok.sql \User_Defined_Function\udf_strtok.sql
udf_Tally.sql \User_Defined_Function\udf_Tally.sql
udp_IntegerListfromRanges.sql \Stored_Procedure\udp_IntegerListfromRanges.sql
ufn_HolidayList.sql \User_Defined_Function\ufn_HolidayList.sql
UnPivot_Output_Restore_Headeronly.sql \Scripts\UnPivot_Output_Restore_Headeronly.sql
usp_bcpTableUnload.sql \Stored_Procedure\usp_bcpTableUnload.sql
usp_bcpTableUnloadBatchMode.sql \Stored_Procedure\usp_bcpTableUnloadBatchMode.sql
usp_bcpUnloadSelect.sql \Stored_Procedure\usp_bcpUnloadSelect.sql
usp_BulkUpload.sql \Stored_Procedure\usp_BulkUpload.sql
usp_checkAllDatabases.sql \Stored_Procedure\usp_checkAllDatabases.sql
usp_CopyLogins.sql \Stored_Procedure\usp_CopyLogins.sql
usp_CreatePlantUMLCode.sql \Stored_Procedure\usp_CreatePlantUMLCode.sql
usp_DBA_Rename_Database.sql \Stored_Procedure\usp_DBA_Rename_Database.sql
usp_EnableAndAddFileStreamForDatabase.sql \Stored_Procedure\usp_EnableAndAddFileStreamForDatabase.sql
usp_FindDbObjects.sql \Stored_Procedure\usp_FindDbObjects.sql
usp_Generate_Merge.sql \Stored_Procedure\usp_Generate_Merge.sql
usp_GetPackageDetails.sql \Stored_Procedure\usp_GetPackageDetails.sql
usp_GetUntrustedForeignKeys.sql \Stored_Procedure\usp_GetUntrustedForeignKeys.sql
usp_LoadTableBlobs.sql \Stored_Procedure\usp_LoadTableBlobs.sql
usp_LogError.sql \Stored_Procedure\usp_LogError.sql
usp_MonitorIdentityColumn.sql \Stored_Procedure\usp_MonitorIdentityColumn.sql
usp_Object_Search.sql \Stored_Procedure\usp_Object_Search.sql
usp_PrintDebug.sql \Stored_Procedure\usp_PrintDebug.sql
usp_PrintError.sql \Stored_Procedure\usp_PrintError.sql
usp_PrintString.sql \Stored_Procedure\usp_PrintString.sql
usp_RandomWait.sql \Stored_Procedure\usp_RandomWait.sql
usp_RunCheckAllUntrustedForeignKeys.sql \Stored_Procedure\usp_RunCheckAllUntrustedForeignKeys.sql
usp_SearchOnAllDB.sql \Stored_Procedure\usp_SearchOnAllDB.sql
usp_SetFileGrowth.sql \Stored_Procedure\usp_SetFileGrowth.sql
usp_SQL_Server_System_Report.sql \Stored_Procedure\usp_SQL_Server_System_Report.sql
usp_SQLskillsAnalyzeLog.sql \Stored_Procedure\usp_SQLskillsAnalyzeLog.sql
usp_SSIS_ScriptEnvironment.sql \Stored_Procedure\usp_SSIS_ScriptEnvironment.sql
usp_String_Search.sql \Stored_Procedure\usp_String_Search.sql
usp_TableUnpivot.sql \Stored_Procedure\usp_TableUnpivot.sql
usp_UnusedInputParameters.sql \Stored_Procedure\usp_UnusedInputParameters.sql
usp_who5.sql \Stored_Procedure\usp_who5.sql
Visualizing_Agent_Jobs_in_SSMS.sql \Scripts\Visualizing_Agent_Jobs_in_SSMS.sql
Visualizing_VLF.sql \Scripts\Visualizing_VLF.sql
Wait_Statistics.sql \Scripts\Wait_Statistics.sql
What_Agent_Job_is_Running.sql \Scripts\What_Agent_Job_is_Running.sql
Which_databases_were_backed_up_and_when.sql \Scripts\Which_databases_were_backed_up_and_when.sql
Which_Filegroup_is_that_Partition_Using.sql \Scripts\Which_Filegroup_is_that_Partition_Using.sql
Which_Indexes_are_not_Used.sql \Scripts\Which_Indexes_are_not_Used.sql
WhiteListIPTable.sql \Scripts\WhiteListIPTable.sql
Who_dropped_database.sql \Scripts\Who_dropped_database.sql
Windows logins not in AD.sql \Scripts\Windows logins not in AD.sql

category:sql scripts return to: home

Welcome to the world of live sex cams, a place where desire and pleasure come together in a virtual realm. For those of you who are new to this exciting and titillating world, brace yourselves because you are about to embark on a journey of self-discovery and unbridled sexuality. Live sex cams have taken the internet by storm and have become a booming industry, offering a vast array of sexual experiences and fantasies that cater to all types of desires. In this beginner's guide, we will delve into the world of live sex cams, specifically focusing on the popular category of Asian live sex and the growing popularity of BBW cam models.

Let's start with the basics, what exactly are live sex cams? Simply put, it is a form of interactive online entertainment that involves real-time streaming of sexual acts or performances by models through webcams. These models, also known as cam girls or cam models, perform various sexual acts or engage in erotic conversations with viewers who are watching and interacting with them through chat rooms. It is an intimate and personalized experience that can range from mild to wild, depending on the preferences of the viewers and the boundaries set by the models.

Now that we have a general understanding of live sex cams, let's focus on the category of asian live sex. In recent years, the popularity of asian cam models has skyrocketed, and for good reason. Asian women have long been desired for their exotic looks, petite figures, and sexual prowess, making them a prime choice for live cam shows. From Japanese, Chinese, Korean, and Thai, there is a diverse selection of Asian cam models that cater to various fantasies and fetishes.

One of the main reasons why Asian live sex is so popular is the cultural taboo surrounding sexuality in many Asian countries. In countries like Japan and South Korea, talking about sex is still considered a taboo, making live sex cams a way for Asian women to explore and express their sexuality without the fear of judgment or societal pressure. This freedom and confidence translate into their performances, making it all the more enticing for viewers.

Transitions Moreover, the Asian live sex industry offers a wide range of experiences and preferences. Whether you are into innocent schoolgirls, mysterious geishas, or dominating mistresses, there is an Asian cam model for everyone. The variety of costumes, roleplays, and fetishes make for an exciting and diverse experience for viewers. And with the advancements in technology, the video and audio quality of live sex cams have improved significantly, making the experience even more immersive and realistic.

Now, let's switch gears and talk about another popular category in the world of live sex cams - bbw cam models. BBW stands for Big Beautiful Women, and these curvaceous models are gaining popularity in the cam industry. For those who have a preference for fuller figures or just enjoy a bit of extra cushion, BBW cams are the place to be. These models are confident, unapologetic, and know how to work their curves to drive viewers wild. From playful teasing to steamy solo shows, BBW cam models offer a range of performances that cater to the different tastes of viewers.

Active Voice The beauty of live sex cams is that it is an interactive experience. Viewers have the power to interact with the cam models through chat rooms, tipping, and even requesting specific acts or performances. This adds a level of personalization and connection that is lacking in traditional forms of pornography. In turn, this also allows the cam models to establish a loyal fan base and build relationships with their viewers.

Transition If you are new to the world of live sex cams, the overwhelming number of cam sites and categories can be intimidating. However, a good place to start is by choosing a reputable site that offers a variety of cam models, such as Asian cam models and BBW cam models. These sites typically have advanced search filters, allowing you to choose your preferences and narrow down your options.

Moreover, it is important to remember that while live sex cams offer a form of entertainment and sexual gratification, it is still a business. It is essential to respect the boundaries and rules set by the models and the site. Asking for favors or being rude and disrespectful will not be tolerated and may result in a ban from the site. Remember, these models are real people who deserve respect and courtesy, just like anyone else.

In conclusion, live sex cams have revolutionized the way we consume pornography and indulge in our sexual desires. It is a safe and enjoyable way to explore our sexuality and fulfill our fantasies. Whether you are into Asian live sex or BBW cam models, there is something for everyone in this exciting and ever-growing world of live sex cams. So, sit back, relax, and let your fantasies run wild as you embark on this erotic journey.

Add a custom sidebar
Clone this wiki locally