Name		Name	Last commit message	Last commit date
Latest commit History 792 Commits
2012		2012
Admin Tools		Admin Tools
Admin-Tools		Admin-Tools
AppTools		AppTools
Automated		Automated
C# Example		C# Example
DT		DT
ETL		ETL
Fitness		Fitness
Inflation Info		Inflation Info
Medical		Medical
Savings Info		Savings Info
Source Control Example		Source Control Example
Statistics Info		Statistics Info
StockAnalysis		StockAnalysis
Teaching Examples (For SQL Server Classes)		Teaching Examples (For SQL Server Classes)
Testing		Testing
.gitignore		.gitignore
AddressingBlocking.sql		AddressingBlocking.sql
AddressingHackers.sql		AddressingHackers.sql
CASEWHENForMonths.sql		CASEWHENForMonths.sql
CASEWHENForSeasonsandQuarters.sql		CASEWHENForSeasonsandQuarters.sql
CheckExistence.sql		CheckExistence.sql
ColumnNamesDataTypesandLengths.sql		ColumnNamesDataTypesandLengths.sql
DayoftheYear.sql		DayoftheYear.sql
DirtyReadingandPrevention.sql		DirtyReadingandPrevention.sql
FindColumnTypes.sql		FindColumnTypes.sql
FindTableWithThreeColumns.sql		FindTableWithThreeColumns.sql
FindTablesAndRowCounts.sql		FindTablesAndRowCounts.sql
FindandRemoveDuplicates.sql		FindandRemoveDuplicates.sql
GrowthMonitoring.sql		GrowthMonitoring.sql
IDStringTable.sql		IDStringTable.sql
InsertAuditTrigger.sql		InsertAuditTrigger.sql
InvoiceExample.sql		InvoiceExample.sql
NonParameterDMVsDMFs.sql		NonParameterDMVsDMFs.sql
PopulateRandomDate.sql		PopulateRandomDate.sql
PopulateUniqueRandomNumbers.sql		PopulateUniqueRandomNumbers.sql
ProcToTempTable.sql		ProcToTempTable.sql
ProcsObjectIDs.sql		ProcsObjectIDs.sql
README.md		README.md
RateCalculator.sql		RateCalculator.sql
RebuildIndexes.sql		RebuildIndexes.sql
SaferDelete.sql		SaferDelete.sql
SaferUpdate.sql		SaferUpdate.sql
SentimentAutoGraphBuilder.sql		SentimentAutoGraphBuilder.sql
TSQLBinaryFeedback.sql		TSQLBinaryFeedback.sql
TSQLFunctions.sql		TSQLFunctions.sql
TSQLIdentityInsertandIdentityValues.sql		TSQLIdentityInsertandIdentityValues.sql
TSQLKeywordSearchTool.sql		TSQLKeywordSearchTool.sql
TSQLMerge.sql		TSQLMerge.sql
TSQLMode.sql		TSQLMode.sql
TSQLRemoveDuplicatesWithLeftOuterJoin.sql		TSQLRemoveDuplicatesWithLeftOuterJoin.sql
TSQLWhileLogic.sql		TSQLWhileLogic.sql
TestTableAndTestData.sql		TestTableAndTestData.sql
TriggerAudit.sql		TriggerAudit.sql
memoryissues.sql		memoryissues.sql
picture.cs		picture.cs
searchprocedures.sql		searchprocedures.sql
tagparsing.sql		tagparsing.sql
unixconvert.sql		unixconvert.sql
webinar_0807.txt		webinar_0807.txt

Repository files navigation

SQL Server Tools

These are various SQL Server files that have useful code to solve various problems, formatting, or mystery-helping. These would be useful for data scientists, developers and those with an interest in SQLServer.

These files also include folders that I use in SQL Server classes to teach data science.

pchnet/SQLServer

Folders and files

Latest commit

History

Repository files navigation

SQL Server Tools

About

Resources

Stars

Watchers

Forks

Languages