Improve System Performance in Your Indexing Scheme Using Asynchronous
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
2001-10-10
1,911 reads
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
2001-10-10
1,911 reads
This paper examines performance in transactional replication and demonstrates ways in which you can improve the performance of your applications. (30 printed pages)
2001-10-08
1,868 reads
This 80-page reference article presents guidelines for designing, building, and deploying COM+ applications, with an emphasis on Visual Basic.
2001-10-05
879 reads
Pre-sliced peanut butter is on its way to U.S. store shelves in test markets - fact or fiction??
2001-10-02
758 reads
Download the source code today for a great method for SQL Server live monitoring.
2001-10-01
62 reads
Learn how to take advantage of AWE memory to boost the performance of SQL Server 2000.
2001-09-27
1,009 reads
2001-09-26
3,387 reads
You already know how to use SQL Server to manage your core business data, now learn how to leverage this knowledge to manage your "spatial" data.
DATE: September 25, 2001
TIME: 2:00pm ET, 6:00pm GMT
DURATION: 40 minutes, including questions & answers at the end
With SpatialWare for SQLServer, you now have the ability to manipulate spatial objects and store them inside of SQL Server allowing you to share information across the enterprise.
2001-09-24
52 reads
Learn how to secure your data by implementing SQL Server security best practices.
2001-09-20
3,675 reads
This is a broad overview of the DBCC SQLPERF command primarily for version 7 and 2000.
2001-09-17
1,927 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers