Tag Archives: SQLNewBlogger

April Blogger Challenge 4–Filtered Index Limitations

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on. Filtered Index Limits I ran across a limitation recently with filtered indexes and was surprised. … Continue reading

Posted in Blog | Tagged , , , , | 1 Comment

The May Blogger Challenge–Continuing On

Last month I participated in Ed Leighton-Dick’s April Challenge. My four posts were tagged the April Challenge, and this month I plan to continue, and hopefully get a few more people to up their blogging. Building on April To make … Continue reading

Posted in Blog | Tagged , , , | Comments Off on The May Blogger Challenge–Continuing On

April Blogger Challenge 3 – Filtered Indexes

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on. Why Filtered Indexes I haven’t used filtered indexes much in my career as they didn’t … Continue reading

Posted in Blog | Tagged , , | 3 Comments

April Blogging Challenge 2 – Primary Key in CREATE TABLE

The April Blogger Challenge is from Ed Leighton-Dick and aimed at new bloggers, but anyone is welcome. I’m trying to motivate and cheer people on. Designating a Primary Key at Design Time In the first post on this subject, I … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments