SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
2009-09-14
2,313 reads
Articles
A Function Gotcha with the Use of an Asterisk
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
2009-09-11 (first published: 2008-04-30)
18,716 reads
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
2009-09-11
622 reads
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
2009-09-11
557 reads
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
2009-09-11
571 reads
Service Broker: Performance and Scalability Techniques
SQL Server Service Broker provides support for building asynchronous messaging and queuing applications with the SQL Server Database Engine. This paper describes a large scale customer scenario and the techniques employed in scaling Service Broker to process tens of thousands of messages per second on one server.
2009-09-11
2,807 reads
Ten Common SQL Programming Mistakes
It is not always easy to spot "antipatterns" in your SQL, especially in more complex queries. In this article, Plamen demonstrates some of the most common SQL coding errors that he encounters, explains their root cause, and illustrates potential solutions.
2009-09-11
8,634 reads
Writing a Technical Article – Where to Publish
This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-09-11
1,604 reads
Less Than a Week - PASS 2009 Summit
A last push for the 2009 PASS Summit before registration goes up.
2009-09-10
19 reads
Managing Free Space
A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.
2009-09-10
5,605 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers