crossword

Technical Article

RE: Query test for just date of smalldatetime

  • Reply

You can put the Convert into the join expression to evaluate simply based on the day instead of the day-time initiallly represented by a smalldatetime value... Declare @Dateparm smalldatetime Set @dateparm = '1/2/2005'Select @dateparm ---versus Select Convert(char(10), @dateparm, 101) 

2005-04-01

Technical Article

RE: Expanding disk in cluster

  • Reply

Thanks for the reply KIK....we currently have this in place with one LUN for data and another for backups -- just wanted to make it a bit easier to manage. Adding another LUN would basically make it two drives for data -- nothing wrong with that, just managing it becomes a pain. Pretty much everything […]

2003-05-09

1 reads

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

TUYỆT CHIÊU CHẲM SÓC MAI VÀNG THÁNG 7 tới 10 ÂM LỊCH

By tt140411

TUYỆT CHIÊU CHẲM SÓC MAI VÀNG THÁNG 7 tới 10 ÂM LỊCH những chậu...

Dumps With Pin :: Track 1 2 Shop Online

By dumpshop

WELCOME DEAR CUSTOMERS! Let us introduce you our dumps service Great Dumps Providing Dumps...

DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers