During a "difficult period", a developer often sinks from view. When things are going well, suddenly they are the gunslinger, the hotshot. The DBA often looks on wistfully. For him, the "fame trajectory" seems to work in reverse.
One of the most interesting features in SQL Server 2008 is filtered indexes. This article starts with a quick explanation and then digs into the details and results.
SQL Server 2005 resource allocation policies treat all workloads equally, and allocate shared resources as they are requested. It sometimes causes a disproportionate distribution of resources, which in turn results in uneven performance or unexpected slowdowns whereas the new Resource Governor of SQL Server 2008 allows organizations to define resource limits and priorities for different workloads, which enables concurrent workloads to provide consistent performance to the end users.
Recently I posted LinkedIn (part 1) about my efforts to better understand and use it as a networking platform. It ended up generating a lot of good comments, always nice to see, and I'll be addressing some of those here and/or in part 3 coming up...
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
Evaluating risk is something we do every day. Steve Jones talks a bit about using this to make ourselves better.
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
By Steve Jones
I have been experimenting with MCP servers in a few ways, and pressing on...
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Hello experts, An application team has asked us to modify a SQL Agent job....
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Comments posted to this topic are about the item Finding Bad Queries