L'actualité technique MS SQL Server en France (et ailleurs)

Jeff Moden

GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]

18 septembre 2023 dans Sites anglophones étiqueté bulk logged / Data Generation / Database Performance / GENERATE_SERIES() / Jeff Moden / Minimal Logging / software testing / t-sql / T-SQL Programming / Test Data / Transact SQL par sqlservercentral.com

How to Format Dates in SQL Server (Hint: Don’t Use ...

Introduction First of all, I agree with most of the heavy hitters in saying that you should avoid […]

5 août 2022 dans Sites anglophones étiqueté Convert / DATENAME / Dates / Datetime conversions / fnTally / format / Jeff Moden / mm/dd/yyyy date format / Performance / performance testing / RBAR / Uncategorized par sqlservercentral.com

How to Find the Start and End Dates for the ...
tl:dr See the attached dbo.WeekDates function. You don’t know what you’re missing, though. Prologue Thanks to some really […]

13 juillet 2022 dans Sites anglophones étiqueté @@DATEFIRST / Advanced SQL / business logic / calendar / Calendar Function / Calendar Table / cross apply / date / Date Calculations / Date computation / date conversion / Date Difference / Date Functions / DATEADD / DATEDIFF / DATEPART / Dates / Datetime conversions / Datetime Functions / Jeff Moden / Tips and tricks / WEEK / Weeks par sqlservercentral.com