Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or...
2012-01-09
563 reads
Blog Posts
Morning Checks - Forewarned is forearmed
It’s always handy to know if there any problems with your servers before you get into work in the morning....
2012-01-09
670 reads
Revised: Difference between collation SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS
This is a revised post of an original article that I first published in December. Even though I thought that...
2012-01-09
259,967 reads
S3OLV update and Reminder
We are now just a few days away from our first meeting of 2012. We have some good content lined up. Check it out here. I am looking forward...
2012-01-09
9 reads
S3OLV update and Reminder
We are now just a few days away from our first meeting of 2012. We have some good content lined...
2012-01-09
641 reads
SQL Server –WRITELOG and how to reduce it
SQL Server Books online defines the wait type WRITELOG as “Occurs while waiting for a log flush to complete. Common...
2012-01-09
1,274 reads
Surrogate Keys
When building a data warehouse, it is important that primary keys of dimension tables remain stable. To accomplish this, it...
2012-01-09
3,972 reads
What I Will Do For You in 2012
Many of you have first hand experience of our phenomenal sql community (affectionately labelled the #sqlfamily).
Your first encounter with it...
2012-01-09
602 reads
SQL Server - Global temporary tables
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as well. Global...
2012-01-07
48,476 reads
SQL Server - Local temporary table
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user's session...
2012-01-07
8,725 reads
Blogs
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Accessing the Data API Builder MCP Server from VS Code
By Steve Jones
I recently started playing with the MCP Server for SQL Server, which is a...
From DBA or Data Engineer to AI Engineer: A Realistic Path
If you spend your days tuning queries, managing pipelines, or keeping a production database...
Forums
BIT_COUNT() V
Comments posted to this topic are about the item BIT_COUNT() V
How We Reduced SQL Server Infrastructure Costs by 33% on AWS: Lessons From a Database Operations Manager
Comments posted to this topic are about the item How We Reduced SQL Server...
An Eventual Consistency Scam
Comments posted to this topic are about the item An Eventual Consistency Scam
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers