Dear Users [and fellow IT guys], We, the tech people, understand that you just want technology to work so you can get your jobs done. We really, really understand that. When your technology doesn’t work, you turn to us so we’ll make it behave. We like making technology behave – we got into this field […]
Category: sqlserverpedia-syndication
Create a clustered index and a primary key on existing tables
It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes on existing tables is one that newish DBAs tend to trip up on, and so (like I do), I shall blog about it so there’s a nice, clear, explicit reference available. Yes, Virginia, you most […]
Just an idea: Bare Bones SQL
I’m reading Andy Warren’s excellent essay “Thoughts on raising funds and spending funds for PASS chapters”, and it’s bringing together a bunch of long-stewed thoughts. Simply: What if there’s room for “Bare Bones” SQL user groups? The bare bones basics of Bare Bones SQL For those who don’t want to read a huge essay, the […]