JNK

yes, you know? Or yes, it locks?

morning Paul

listen I have a fondness for XML in SQL Server :P

wow what was he trying to do

Yeah I'm the worst, sorry

I'm boring every day

@202_accepted it can matter, depending on your use case...if the fragmentation leads to splits etc you are doing a lot more IO than strictly necessary to pull your data

also if you use SSDs it won't matter much anyways

Fragmentation doesn't necessarily matter for all applications

@202_accepted yeah that may be good, could be overkill unless this is for a data warehouse

b/c if youre gonna do it may as well break out stuff like day of week, day of month, month number, day of year, etc etc

look up one so you get the important stuff

and calendar tables are pretty easy

your join criteria is the same

for your query you just need the COUNT(RangeTest.RangeID) instead of the conditional

could also do a SUM(CASE ... THEN 1 ELSE 0 END) for the same check

that's what my count gives you

yeah you could but what do you need from rangetest

not sure on join criteria there tho

SELECT DateCol, DATEADD(day, 60, Datecol), COUNT(CASE WHEN SomeDate BETWEEN DateCol AND DATEADD(day, 60, Datecol)) FROM CalendarTable ct

well the calendar table would work for your first day

if you need to iterate over a series of days it's a calendar table or a loop of some sort

sooooper easy to do

yeah calendar table

where do you get the range start and end values

people don't seem to get less confused over time do they?

@Zane I had some recently on like 6 year old answers.

...or the automatic typing in powershell

@PaulWhite that's like some Javascript logic

"Oh I can just do a PS script for that!"

they all look like nails :)

definitely a golden hammer issue though

once you're competent there's very few things you can't bang out in an hour or two to see if it works

it's very easy to prototype stuff in

well being able to write .NET code without a compiler is SUPER HANDY

you don't want to cut your hair with the little scissors in a SA knife but you can use them in a pinch

I describe it to people like a swiss army knife. It can do almost anything but it's not the best tool for any specific task usually

@PaulWhite yes to all

:)

so Erik if you get stuck on PS again ping me

it's almost always faster than cmdlets

if you feel fancy you can also use .NET classes for this stuff

powershell is fantastic but there's wayyyyyyyyy too many tools in the toolbox

<themoreyouknow.gif>

technet.microsoft.com/en-us/library/ee156791.aspx

@sp_BlitzErik have you not heard of add-content ?

@PaulWhite I heard about that! Everyone's talking about it.

I'm the accidental DBA who can keep things running but I'm not gonna do a migration or anything

but my skillset is more with powershell and TSQL than with administration

Well now I know that!