2008-11-25
501 reads
Articles
The Numbers Table
Having a table of just numbers can be very handy, and it doesn't necessarily take up much space in your database. New author Brandon Galderisi brings us a short tutorial on setting this up.
2008-11-24
10,803 reads
Are Your Indexes Being Used Effectively?
This article shows how to use the dm_db_index_usage_stats DMV to identify if an Index is being used on not
2008-11-24
6,016 reads
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
2008-11-24
511 reads
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
2008-11-24
776 reads
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
2008-11-24
488 reads
Replication methods: Snapshot, merge or transactional
SQL Server replication methods include snapshot, merge and transactional replication. Learn how to choose a method, set up SQL replication and avoid the 'gotchas.'
2008-11-24
3,673 reads
Exporting MDX queries to SQL Relational Databases using SSIS 2005
Most of the time we move data from an RDBMS to a cube, but there are places where you might want to provide a feedback loop to the RDBMS. Andrew Muyobo shows how SSIS can help you do this.
2008-11-21
11,982 reads
Generate SQL Agent Job Schedule Report
I am trying to come up with a list of Job Schedules so I can make sure that my Jobs are staggered. Is there a way to query the system tables so I do not have to manually keep track of the schedules?
2008-11-21
4,656 reads
SQL Server 2008 Full-Text Search: Internals and Enhancements
This white paper covers in detail the new integrated full-text search architecture, new features, main changes from full-text search in SQL Server 2000 and SQL Server 2005, and limitations and best practices for deploying applications that use SQL Server 2008 full-text search.
2008-11-21
2,826 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Alamat Kantor BCA KCU Wahid Hasyim Telp:0817825533
Hub Via Wa:62817825533 Alamat: Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan...
Alamat Kantor BCA KCU Thamrin Telp:0817825533
Hub Via Wa:62817825533 Alamat: Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng,...
Alamat Kantor BCA KCU Scbd Telp:0817825533
Hub Via Wa:62817825533 Alamat: Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers