Whether you are building SQL Server 2000 applications or getting ready for the new features in SQL Server 2005, there are many fundamental database design principals that should be followed. New author Ranga Narasimhan brings us a look at how he handles reference tables when designing a database..
2005-09-27
29,031 reads
We all know the "TOP" clause returns the first n number of rows or percentage of rows thereby limiting the number of resulting rows displayed when we are selecting rows in a table.
SQL Server 2005 is packed with new features and enhancements. One of the enhancements in SQL 2005 that we are going to see is the clause, "TOP." The "TOP" clause will now allow us to do Data Manipulation and also allow similar criteria results to be displayed by using the TIES option.
2005-09-27
3,710 reads
SQL Server 2000 has a great set of administrative and development tools, one of the most heavily used of which is Enterprise Manager. Sushila Iyer brings us a fantastic article with some tricks in using this tool to create and manipulate tables.
2005-09-26
16,287 reads
Long anticipated, the arrival of radically restructured database architectures is now finally at hand.
2005-09-26
4,166 reads
Continuing with the humanization of the amazing team hard at work on SQL Server, Steve Jones takes a few minutes with Donald Farmer, BI guru.
2005-09-23
6,253 reads
Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.
2005-09-23 (first published: 2004-05-03)
40,352 reads
Richard Hundhausen is the author of Building Web Applications with ADO.NET and XML Web Services and Programming ADO.NET, both from Wiley, as well as the upcoming Working with Microsoft Visual Studio 2005 Team System from Microsoft Press. He is also a trainer, teaching numerous courses and speaking at conferences such as VSLive and Tech Ed.
2005-09-23
1,676 reads
Have you been burned by sysdepends at some point in your SQL Server DBA career? Steve Jones has many times, but a FREE new utility ends all that.
2005-09-22
9,879 reads
How many of you using SQL Server 2000 have the need to send email from SQL Server? How many of you hate Outlook? Here is a software package that can send not only HTML, but PDF as well and through SMTP. Read Hugh Scott's review and thoughts on this product.
2005-09-22
7,454 reads
Tried at TechEd and manned by the SQLServerCentral.com crew, this was a great idea. It's going to be at PASS and hosted by James Luetkehoelter.
2005-09-21
2,941 reads
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers