The LEVEL_NUMBER Member Property
BI Architect Bill Pearson introduces the LEVEL_NUMBER intrinsic member property, supported by SQL Server 2005 Analysis Services, and leads a hands-on exercise providing sample uses.
You thought SQL Server ate up memory…
Often I tell clients better to much memory than too little. This can be applied to any database engine essentially. If your data set is growing over time you will end up using any memory that is not consumed today.
Large Analysis Database Migration
large Analysis Database migration (hundreds of gigabytes, hundreds of users and thousands of user MDX queries)
Shapes in the Clouds
Continuing on with his week in the clouds, Steve Jones looks at how SQL Server might appear in the cloud world.
Auto generate change scripts in SQL Server Management Studio (SSMS) for tables
This tip shows you an option that exists within SSMS to automatically generate scripts for all table changes when using the table designer.
Becoming a Google Earth
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
Becoming a Google Earth
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
Becoming a Google Earth
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
The challenges of SQL Server consolidation
Despite the benefits of SQL Server consolidation, some IT pros are still reluctant to make the move. Learn which scenarios could pose a challenge to those looking to consolidate.
Service Pack 1 - Database Weekly (Apr 13, 2009)
This past week saw the release of Service Pack 1 for SQL Server 2008, and some interesting changes with it. Steve Jones comments.
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 Pondok Timur CSTelpon : 0853-73737551
Jl. Pd. Timur Indah Kompleks Perumahan Taman Nirwana No.8, RT.005/RW.019, Pengasinan, Kec. Rawalumbu, Kota...
BCA KCP Telepon Kota TLP/WA 08216366654
Jl. Ps. Pagi Raya No.9, Roa Malaka, Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Cikarang Central City CSTelpon : 0853-73737551
CSTelpon : 0853-73737551 Ruko Cikarang Central City, Jl. Raya Cibarusah KM 10. 88 Blok...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers