Current date without the timestamp
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-07 (first published: 2004-12-28)
387 reads
Scripts
Date without the time
This script will get you the current date minus the time. It will display all zeros instead.
2005-01-06 (first published: 2004-12-28)
200 reads
Get the Value of a BitMask
This function will take a 64 bitmask string and return the value of bitmask. If you need 128, 256, etc simply change the length of the parameter, being careful to remember you may need to change the return type of int to BigInt if you get too long.
2005-01-04 (first published: 2004-12-30)
256 reads
Simpler First/Last Day of Months
Script uses simpler Dateadd function ensuring additions/substractions are based from 1st of month.
2005-01-03 (first published: 2004-12-02)
145 reads
Row Counts of Tables for a databse
I wanted to know which tables contains the most populated records in db. So I wrote this script.
2005-01-02 (first published: 2004-11-18)
105 reads
Generating sequential numbers - the fast way
It is often necessary to generate a table with sequential numbers, up to a specified upper limit N. For small N, a simple INSERT in a WHILE loop will do. But, for large N, that solution becomes too slow. This script presents a different approach. It generates sequential numbers from the binary representation of N, […]
2004-12-30 (first published: 2003-11-24)
644 reads
Function Number of Week Days between Two Dates
This function will calculate the number of weekdays between two dates passed. This allows for accurate tracking of "business days" for metrics in many different views.
2004-12-28 (first published: 2004-12-16)
277 reads
Collect Database Properties
To examine all the properties of a database is time consuming. The following script gives you a quick overview of the most important properties of all the databases on your SQL Server.
2004-12-27 (first published: 2004-12-10)
663 reads
Number of Weekdays between two dates - Set Based
Inspired by a post here at SQLServerCentral, I wrote this function to calculate the number of days between two dates that are weekdays. In order to achieve this I used a common SQL table that contains a sequence of number for 1 to X. This was used as an input to the datediff function, and […]
2004-12-24 (first published: 2004-12-07)
319 reads
Retrieving all indexes of the Database.
The Script outputs all the indexes in the Database.I have used the sp_helpIndex system stored procedure here to retrieve all the indexes available for the Table . This is extremely useful in identifying all the indexes in a database in a single query
2004-12-22 (first published: 2004-11-18)
341 reads
Blogs
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
TRY_PARSE Limitations: #SQLNewBlogger
By Steve Jones
I got a notification from a question I’d posted at SQL Server Central: Getting...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers