Ed.Carden@Westdale.com

  • Interests: SQL Server, VB (old & .Net both)

Technical Article

Build DATELOOKUP table

This script creates a table named DATELOOKUP which is used for looking up date related values. Each record represents date related info about the date in the column dtDate. For example the iMonth column stores the integer value of the month of dtDate and sShortMonth stores the abbreviated name of that same month. Use this […]

5 (1)

You rated this post out of 5. Change rating

2004-12-13 (first published: )

206 reads

Blogs

A New Word: Immerensis

By

immerensis – n.  the maddening inability to understand the reasons why someone loves you...

Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault

By

In this post, I will guide you on how to deploy a dockerized simple...

Using a Local Large Language Model (LLM): Running Ollama on Your Laptop

By

You can now run powerful LLMs like Llama 3.1 directly on your laptop using...

Read the latest Blogs

Forums

SQL Server is terminating in response to a 'stop' request from Service error

By naga.rohitkumar

Dear All, In one of the server its repeatedly restarting sqlserver services and not...

Understanding CROSS APPLY and OUTER APPLY in SQL Server

By Noman072

Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...

Database Files on Shares I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Database Files on Shares I

Visit the forum

Question of the Day

Database Files on Shares I

I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?

See possible answers