• Interests: SQL Server, of course!

Technical Article

Reindex Procedure with a Twist (or two)

We’ve all seen reindex procedures that rebuild all indexes in a database or all indexes in a database which have less than a specified ScanDensity. This one goes a few steps further. First, the DBA can specify a ScanDensity_Threshold (a min value for ScanDensity), plus a Limit (qty or %). If you specify a ScanDensity_Threshold […]

5 (1)

You rated this post out of 5. Change rating

2005-06-14 (first published: )

1,837 reads

Technical Article

Julian and Gregorian Conversion Functions

After seeing a thread in the forums about converting a Julian date to Gregorian, I decided to write these functions. There are two functions in the script, getJulian and getGregorian. getJulian accepts a datetime parameter and returns the Julian date as an integer. getGregorian accepts an integer and returns the Gregorian date as datetime. A […]

You rated this post out of 5. Change rating

2004-10-18 (first published: )

1,082 reads

Blogs

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

Read the latest Blogs

Forums

How to change font size in Query window

By MurraySobol

I am running SQL Server 20.2. When I copy a query into the query...

is the ssrs auto refresh without its faults

By stan

Hi, i considered power bi with embedded for this.    Not a big fan...

Random Execute SQL Task(s) keeps hanging when I try to run it in parallel

By water490

Hi everyone I am trying to implement parallelism in my SSIS package.  There are...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers