Upgrading from Erwin to Embarcadero?
Embarcadero is offering a 40% discount off the retail price if you upgrade from Erwin before Sep 30, 2003. Follow the link for details (subject to change!).
Full-Text Indexing Tips
This article by Jon Winer offers some tips to help you get the most of SQL Full Text Search.
Free SQL Functions & Stuff!
Wingenious is offering a free download of some add-in code you may find very useful! It's a subset of their DBAction product (which they you'll look at as well), but the free code is worth a look.
Using sp_addalias
SP_addalias isn't a well known stored procedure to most DBA's - do you know what it does? In what situations you might use it? This short article gives very quick and clean answers to both of those questions.
Where Do I Want To Go Today? - From the Field 2
Where should SQL Server go in the future? What enhancements are needed? Steve Jones takes another break from his wishes to include some more feedback from users who have some wishes of their own. Read about what real users of SQL Server would like to see included in future versions.
Best of SQLServerCentral.com 2002 Launch
We've had a soft launch under way for the past week, but now we'd like to sell the rest of the books stacked up at Andy's house! $15 plus shipping will get you a book that you'll be proud to put on your bookshelf. Read this to get latest pricing and answers to the most recent questions we've gotten.
Build a lot of DSN's in a hurry!
This article by Andy Warren offers a free utility that will generate DSN's for all or just a subset of the databases on a server in seconds.
Problem Solving With Information Schema Columns
Directly accessing system tables is discouraged - so what's the alternative? Using the Information Schema should allow you to create code that survives upgrades. Beyond that, what can you do with it? Joe has four great examples to get you started.
SQL and Java Go on a Date
Chris discusses some issues he had trying to use SQL dates from within Java. Interesting stuff and brings up the point that if you have dates stored in local time, having users in multiple time zones can be a large headache.
Where Do I Want To Go Today? - Included Indexes
Where should SQL Server go in the future? What enhancements are needed? Steve Jones continues to explore his wish list for future versions of SQL Server.
Blogs
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
2024 PASS Data Community Summit Prep
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
A New Word: Bye-over
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
Forums
PASS Summit Time
Comments posted to this topic are about the item PASS Summit Time
database restore chain
I have a backup of full, differential and transaction log setup for our database....
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers