Undocumented Routines: Forbidden fruit.
Phil wonders whether it is time to come up with clear 'best practice' guidelines to cover the use of undocumented routines, and ends up deciding it is a gray area.
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.
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers