A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.
2006-08-03
2,271 reads
In Part 2 of this series, Wes Dumey talks about some of the key tables in a data warehousing scenario. He covers fact tables, dimensions and some of the other tables you'll see in a data warehouse. Free registration required.
2006-08-02
2,444 reads
There are two UDF's included here.The first one will return the number of Years, Months and Days between a Start and End date.The second one will return either Years, Months or Days which makes it much easier to include in a select.If you know of or find a better/faster way to do this, then please […]
2006-08-01 (first published: 2004-09-23)
178 reads
In Part 1 of this extensive series, Wes Dumey starts some of the core concepts of data warehousing. In this video he covers what a data warehouse is, why companies use them and what are some of the key components.
2006-07-31
2,785 reads
In this video series, Wes Dumey shows you some of the core basics of data warehousing. Free registration required.
2006-07-28
2,329 reads
One of the responsibilities of the Microsoft.com operations team is to manage the infrastructure that supports the Windows Update and Microsoft Update services, which have client bases in the hundreds of millions and growing. The Windows Update site provides critical updates, security fixes, software downloads, and device drivers for Windows operating systems. Microsoft Update is the service that brings you all the features and benefits of Windows Update.
2006-07-28
1,321 reads
Every DBA needs to know how to do their work under pressure, while facing crisis after crisis. Our most important contribution is to keep the database running. It's an on-call function; you never know what might happen
2006-07-27
3,942 reads
After agreeing on our design goals we began looking for technologies to support them. It turned out that SQL Server™ Service Broker offered the asynchronous messaging support we needed and, since the message-queuing infrastructure is tightly integrated with the SQL Server database engine, our existing database backup, administration, and failover procedures could cover our messaging solution as well.
2006-07-26
1,736 reads
Part 28 of SQL Server 2005 Integration Services series covers the remaining security features intended to protect the confidentiality and integrity of your packages
2006-07-25
1,889 reads
An in-depth, fully explained case study on how to design and create a data access layer for your .NET applications.
2006-07-24
4,124 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Layanan bantuan QLola BRI via WhatsApp 08136035412 hadir untuk memberikan pengalaman support yang cepat,...
Segera hubungi WhatsApp 08136035412 untuk bantuan QLola BRI. Dapatkan solusi cepat tanpa harus menunggu...
Segera hubungi WhatsApp 08136035412 untuk bantuan QLola BRI. Dapatkan solusi cepat tanpa harus menunggu...
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