The Curious Consultant
Menu Close
  • Home
  • Here’s everything!
    • C#
    • SQL
    • General
    • Code
      • C# Code
      • JavaScript/TypeScript Code
      • SQL Code
    • Tips and Techniques
      • C# Tips and Techniques
      • Nintex Tips and Techniques
  • About Dave
  • My Blogs
  • Contact Me Anytime!

SQL Code

0

Massive SQL Date Time Cheat Sheet

Posted on May 22, 2021 by David Lozinski
SQL Code

Massive SQL Date Time Cheat Sheet Anyone who has been involved in SQL will undoubtedly tell you wargames they played when they had to manipulate date time data via SQL.   Here are code snippets to multiple Date and Time… Continue Reading →

SQL Code DATEADD, DATEDIFF, DAY, GETDATE, sql
2

SQL: get max length of values in every table column

Posted on July 11, 2017 by David Lozinski
SQL Code

SQL to get max length of values in every table column I had an issue to resolve once upon a time where data could not be loaded into a table because “string or binary data would be truncated”. The target… Continue Reading →

Code, SQL Code max length, sql
0

SQL: “Watchdog” loop to start and monitor SQL Agent Jobs

Posted on January 16, 2017 by David Lozinski
SQL Code

SQL “Watchdog” loop to start and monitor SQL Agent Jobs This runs an SQL “Watchdog” loop to start and monitor SQL Agent Jobs. There are just a few configurable items that you can adjust to suit your needs: The “Wait… Continue Reading →

Code, SQL Code agent job, sql, watchdog
1

SQL: Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server

Posted on September 12, 2016 by David Lozinski
SQL Code

SQL to Rebuild Indexes, Update Statistics, and Shrink Databases Here is SQL to Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server. This code works on SQL Server 2008 – 2016. It should help keeping your databases running at… Continue Reading →

Code, SQL Code Indexes, Shrink Database, sql, statistics

Subscribe to be notified of new posts:

Loading

Most Popular Last 30 Days

  • SQL: Fastest way to insert new records where one… (977)
  • C# .Net: Fastest Way to Read Text Files (670)
  • SQL: Fastest way to compare multiple column values (298)
  • C# .Net: Fastest Way to check if a string occurs… (284)
  • Fastest Way to Compare Strings in C# .Net (252)

Categories

Latest Comments:

  • Utkarsh Kapadia on C#: Dictionary Vs ConcurrentDictionary
  • Mike H on C#: Dictionary Vs ConcurrentDictionary
  • Utkarsh Kapadia on C#: Dictionary Vs ConcurrentDictionary
  • danzar on Length Vs Count Vs Initialized Variable in C#
  • 5Arete23 on Fastest Collection for String Lookups in C# .Net

Recent Posts

  • How to show attachments on NWC/NAC Cloud Task Forms
  • Does How You Access Class Properties Make A Difference?
  • Things I do to increase Windows drive performance
  • Massive SQL Date Time Cheat Sheet
  • Division Vs Multiplication Equivalent

Everything Else!

Here's Everything if you're trying to find a post, missed some, or just want to see, well, everything. :-)
© 2023 The Curious Consultant. All rights reserved.
Hiero by aThemes