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
659 reads
Blog Posts
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
258,963 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
640 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
6 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,271 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,965 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
600 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,467 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,719 reads
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we...
2012-01-07
9,415 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Talavera CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar.,...
BCA KCP Kemang CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta...
BCA KCP Panglima Polim Raya CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers