SQL University: Advanced Indexing – Indexing Strategies
Right, I know it’s Friday and everyone’s tired and looking forward to the weekend, but I do need to finish...
2011-11-11
1,582 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
SQL University: Advanced Indexing – Filtered Indexes
Welcome back to day 2 of Advanced Indexing. Today we’re going to look at a feature that was added in...
2011-11-09
1,929 reads
SQL University: Advanced indexing – Sorting and Grouping
Good day everyone and welcome to another week of SQL University. I know we’re getting close to the end of...
2011-11-07
2,675 reads
24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
749 reads
Compiles and recompiles
I want to spend some time over the next few months looking at query compilation and the plan cache, and...
2011-08-16
3,426 reads
All about Execution Plans
Coming to the PASS Summit in October this year? Excellent!
I say excellent, because Grant (blog|twitter) and I are presenting a...
2011-08-09
766 reads
SQLSkills Immersion training in London
Just short of the winter solstice, I bailed out of a freezing cold Johannesburg for warmer climates; well, actually for...
2011-07-22
1,247 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,602 reads
Are all updates split into delete-insert?
This should be another quick one.
Earlier I saw a forum post where someone asserted that SQL always executes an update...
2011-06-21
4,795 reads
T-SQL Tuesday: Disasters don’t just come in huge
So we’re supposed to talk about disasters we’ve had or discuss disaster recovery technologies. I’m going to take a slightly...
2011-06-14
728 reads
Blogs
KDA: Echoes of Deception - Onboarding
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
Kusto Detective Agency - Intro
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
The Book of Redgate: Customer Quotes
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Forums
How to take a backup as a .bak file while omitting some tables?
Hi Guys, I'm not sure if this is possible or not, but let me...
Life Moves Pretty Fast
Comments posted to this topic are about the item Life Moves Pretty Fast
Parse XML data from SQL table using temp tables and variables
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers