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
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
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.'
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.
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?
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.
E-Discovery and Data Retention
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
Investigating the new Spatial Types in SQL Server 2008 - Part 2
This is the second article in the series on the new spatial data types in SQL Server 2008
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA Finance Batam Layanan Mobil & Motor Call Cs: (+62 821°3111°179
Unnamed Road, Sungai Panas, Kec. Batam Kota, Kota Batam, Kepulauan Riau 29444
BCA KCP Daan Mogot Baru Tlp.cs 087878229292
By Buffalo's Best Roofing Company LLC
Wa 087878229292 Rukan Pusat Bisnis, Jl. Daan Mogot Baru No.9 & 10 Blok KJF,...
BCA Finance Belitung Layanan Mobil Call Cs: (+62 821°3111°179
Jl. Jend. Sudirman, RT.016/RW.006, Pangkal Lalang, Kec. Tj. Pandan, Kabupaten Belitung, Kepulauan Bangka Belitung...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers