Here are some examples I used to finally get my head around framing:
if object_id('tempdb..#DinnerParties') is not null
begin
drop table #DinnerParties
end
GO
CREATE TABLE...

I had to stop a second because the partition size is the set of rows for a given team while the Rows/Range clause determines the frame size which is used...

One thing that really effects me is support for ongoing education. I've worked at places where the employees brag about not having read another book since college and it was...

I always change the port, the instance name and the name of the sa account. I also create a bogus sa account. Although each of these only adds a little...

Interestingly, if you examine Information Schema Columns, the table only has 3 columns.

There has been a lot of research into learning styles and teaching styles. Joe Hill did work on the impact of mismatched styles. Personally, I'm an auditory analogous learner. Tell...

For the past couple of years I have tried to make at least one if not all three of the SQL Saturdays in Jacksonville (180 mi), Orlando (250 mi) and...

Depends if you're talking about the EXEC() function or the EXEC abbreviated version of EXECUTE. As I recall the EXEC() function can't see any variables declared in the calling session...

I understand controlling costs but let's also remember that the employer can deduct those expenses for insurance from their taxes while you can't deduct the portion you pay.

Sadly, what I'm not seeing companies embrace is the need for proper data architecture and administration. I laugh when I hear "data scientists" moan about how 80% of their time...

ZZartin (12/21/2015)

TomThomson (12/21/2015)

roger.plowman (12/21/2015)

I disagree with them, you can only get two of the three,...

TomThomson (12/21/2015)

roger.plowman (12/21/2015)

I wish. Good and fast (delivered) isn't cheap, good and...

The same way Roman engineers did. Put your entire family underneath and march an army across the...

I've been watching this debate for 40 years now. There are components of the computing industry that are true engineers but that is largely because they evolved out of broader...