Service Pack 1 for SQLCentric v.1.2.3 Now Available
This service pack contains bug fixed, plus enhancements including test email button, sorting, and drill down.
2003-12-08
653 reads
Articles
Sequential Numbering
Needing to number rows with a sequential id is a pretty common request. Sometimes it's because the user hasn't made the transition to 'set based' thinking, sometimes it really is a valid request (more or less!). Greg provides several different techniques to help you achieve sequential numbering.
2003-12-05
11,080 reads
Store Key - Storing Misc Data
This article proposes a system where extra data is stored in a simple row based table and retrieved using the 'store key'. It's not a new concept of course, but the author explains how and why he chose to implement. Feedback should be interesting!
2003-12-04
4,195 reads
Scaling Out
Kumar discusses the differences between scale up and scale out, then does a very good walk through of how to build a scale out solution.
2003-12-03
7,631 reads
New JDBC Driver for SQL
This is one of the vendors we met at PASS 2003. Their new driver is supposed to be faster than the driver provided by Microsoft AND supports NT authentication. Link takes you to a comparision chart of features. (Not Reviewed)
2003-12-03
1,622 reads
Indexed Views
Most of us know what it is, or do we? Chris works on a good definition and along with that, gets into a good look at the problems denormalization creates and talks about a pretty common form of it - the indexed view.
2003-12-02
12,291 reads
Notes about PASS 2003 and Other Stuff
Andy wrote up some notes about the recent PASS Community Summit, plans for next year, people we met, and much more.
2003-12-01
2,653 reads
Parameterizing Views
Views dont parameters, but sometimes you need them to act as if they do. Andy discusses views and how they encapsulate code and then offers an idea about how to alter the behavior of views on the fly. Controversial? Probably!
2003-12-01
8,569 reads
What is Denormalization?
Chris Kempster brings us a basic look at the database design topic of denormalization.
2003-12-01
17,811 reads
Lockwood Tech is now ApexSQL!
The name has changed, but the owner and the upgrade policies remain the same! Follow the link to see the press release that explains the name change.
2003-12-01
672 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers