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.
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.
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!
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.
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)
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.
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.
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!
What is Denormalization?
Chris Kempster brings us a basic look at the database design topic of denormalization.
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.
Blogs
When It’s Still Viable
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
T-SQL Tuesday #179: The Detective’s Toolkit
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Forums
case statement with and like operators
Hello, I'm trying to remove results from this sql statement where the custid like...
update error. Subquery returned more than 1 value
Hi friends. how can i fix that? ;with cte as (select distinct(e.Id ) from...
THE CSV PROBLEM
Hello everyone, First of all, thank you very much for this great community. I...
Question of the Day
Data Migration Assistant Targets
In the current (2024) version of the Data Migration Assistant, which on-premises targets are available?
See possible answers