Understanding Scans And Seeks
Whether a query uses Scan or Seek can have a big impact on the cost of excuting that query. This article examines when each is used and which is optimal.
2009-09-10
6,054 reads
Articles
Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).
2009-09-10
4,815 reads
Returning full error details from SQL Server Agent jobs
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
2009-09-09
42,491 reads
EVA Partition Alignment
Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?
2009-09-09
2,968 reads
Finding Passwords
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
2009-09-09
480 reads
Finding Passwords
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
2009-09-09
711 reads
Finding Passwords
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
2009-09-09
500 reads
Transact-SQL Formatting Standards
How should SQL code be formatted? What sort of indentation should you use? Should keywords be in upper case? How should lists be lined up? SQL is one of those languages that will execute however you treat whitespace and capitalization. However, the way SQL is laid out will effect its readability and the time taken to review and understand it. Standardisation of code layout is an important issue, but what standard should you adopt? Rob avoids a direct answer, but tells you the sort of answers you'll need to decide upon when creating a strategy for formatting SQL code.
2009-09-09
4,890 reads
Enforcing Data Quality while using Surrogate Keys
Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.
2009-09-08
7,779 reads
Options for hiding SQL Server code
I am aware of the WITH ENCRYPTION clause that is used to encrypt the code for objects like views, stored procedures and functions. It sort of fulfills my purpose and is easy to implement, but it does not cover all SQL Server objects. In this tip we look at another option to restrict users from viewing the definition/code of any SQL Server object.
2009-09-08
5,538 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers