A Welcome Break
I’m not working, though I have checked some email and kept an eye on a few things while I’m in...
2011-06-06
499 reads
Blog Posts
Column order can matter
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,179 reads
Great white paper: Microsoft EDW Architecture, Guidance and Deployment Best Practices
A fantastic white paper just released: Microsoft EDW Architecture, Guidance and Deployment Best Practices.
It’s a must read if you are...
2011-06-06
1,104 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million....
2011-06-06
515 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a
daily feeding of around 9 million. It is split into 10, roughly equal,
partitions. I...
2011-06-06
14 reads
Improved partition loading
We have a table that contains just over 1.7 billion records and requires a daily feeding of around 9 million. It is split into 10, roughly equal, partitions. I...
2011-06-06
4 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time
OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds...
2011-06-06
462 reads
June 2011 S3OLV Meeting
It’s Grillin’ Time OK, so we won’t be grilling inside the meeting – or even at the meeting. But it sure sounds good. There will likely be Pizza and...
2011-06-06
3 reads
June Monthly SQL Server Checklist
I’ve thought about doing this for a while now and it seems to be about that time. It’ll be a...
2011-06-06
664 reads
Meme 2 - A Quick Meme Monday Post.....
Well, ok. I'll jump on the bandwagon again.
Power has been restored to Mr. LaRock's Residence, just in time for meme Monday.
(And really,...
2011-06-06
1,158 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691
BCA Multifinance Cabang Kedoya Hub.0851•8812•0691 Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West...
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691
BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691 Ruko Mall Of Indonesia Blok B 32-33,...
BCA Finance - Depok Hub.0851•8812•0691
BCA Finance - Depok Hub.0851•8812•0691 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl....
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers