Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly
Appearance settings

pathomas/SQLServer

BranchesTags
Open more actions menu
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

793 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.

About

SQL Server Tools

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • SQLPL 54.5%
  • C# 26.3%
  • PowerShell 17.0%
  • PLSQL 2.2%
Morty Proxy This is a proxified and sanitized view of the page, visit original site.