The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
The December 2008 Energy Update
Steve Jones gives one last update on energy issues in the US in 2008 with a look at the construction and building industries.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
Changing Taxonomy
Steve Jones is considering changes to SQLServerCentral and presents a few ideas today.
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
SSIS and Stored procedures using temp tables
SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.
Finding a better candidate for your clustered indexes
When creating tables it is difficult to determine exactly how the data will be accessed. Therefore when clustered indexes are chosen they are often just the ID column that makes the row unique. This may be a good choice, but once the application has been used and data access statistics are available you may need to go back and make some adjustments to your tables to ensure your clustered indexes are providing a benefit and not a drain on your applications.
How Would You Rate This? - Database Weekly (Dec 29, 2008)
Steve Jones wonders if Microsoft is doing a good job with their efforts to patch SQL Server security issues?
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers