Lumigent Technologies Introduces Data Auditing Solution for Oracle
Entegra for SQL Server has been available for some time, but Lumigent has recently announced support for Oracle. So if you're in a heterogenous environment...
2004-06-15
6,106 reads
Articles
Extracting a String From Between Two Delimiting Characters
String manipulation in SQL Server or T-SQL can be a challenage. There are multiple ways to accomplish every task and often learning a new one may spark some creativity in yourself or teach you a better way to accomplish an old task. New Author Stephen Lasham brings us his technique for extracting a string that is delimited from within a larger string. Something I'm sure we'll all have use for in the future.
2004-06-14
22,263 reads
SQLCentric Pre Summer Sale!
SQLCentric is a fully functional Web-based MSSQL Centric Network Database Monitoring System which is deployed on your corporate intranet. Now for a limited time, Pearl Knowledge Solutions is running a sale on this product.
2004-06-14
7,033 reads
South Park Unveils Linux Lounge For Guests
This is rich. A hotel sets up Internet access using Linux for guests. But they run SQL Server internally. So much for all the FUD coming from MS.
2004-06-14
3,811 reads
Reducing Round Trips - Working with HTML Checkboxes
Reducing the amount of round trips between a server and client is something that can give you a great boost in performance. David Poole looks at how he solved a problem with HTML checkboxes and the challenges they solve in a programming environment. Without Dynamic SQL!
2004-06-11
9,230 reads
NTL Block SQLServer from their network - UK
A personal article refering to the latest change from NTL broadband stopping port 1433 globally on their network. Users are no longer able to develop Microsoft SQLSever systems using ODBC or Enterprise manager.
2004-06-11
3,769 reads
Webcast: Learn about SQL Server Yukon CLR for the DBA
Learn about SQL Server and the CLR. Join PASS and speaker Michael Otey, Senior Technical Editor for SQL Server Magazine and Windows & .NET Magazine and President of TECA, Inc., for the upcoming WebCast where you'll learn about the new .NET Common Language Runtime integration with SQL Server 2005. Registration Required.
2004-06-11
503 reads
An Introduction to InfoPath 2003
Office 2003 has a new tool: InfoPath 2003, which can work with SQL Server along with numerous other data stores. It's a great way to begin working with XML, Web Services, and many of the newer technologies that are available today. Join Dinesh Askanka on his journey to learn more about InfoPath2003 in the start of another series.
2004-06-10
10,606 reads
New Product Discount: 15% on SQL Server Find
SQL Server Find, a product from Genius@Work, allows you to search your databases for objects based on a variety of criteria.
2004-06-10
495 reads
Which Databases are Being Backed Up - Another Look
Knowing which databases are being backed up is a critical thing for all DBAs to know. After reading an article on this subject, new author Santveer Singh decided to share his own techniques for checking SQL Server databases and their backup status. He shows us how to look for failed backups as well as find those databases which have not been backed up.
2004-06-09
9,499 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
A Guide to SQL Security in Django
Comments posted to this topic are about the item A Guide to SQL Security...
I Need a CS Degree. I Don't Need a CS Degree
Comments posted to this topic are about the item I Need a CS Degree....
Incremental Statistics
Comments posted to this topic are about the item Incremental Statistics
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