UDF's are useful if somewhat tricky. Dinesh uses a common scenario where you have a self referencing table (the common example is an employees table where each employee has a managerid that links to another employee in the same table) to illustrate how a UDF can make querying easier, how to use it as the basis of a computed column, and how to index that column.
2003-06-18
12,284 reads
myLittleTools.net is pleased to announce the release of myLittleAdmin, the most advanced and robuste web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager.
2003-06-17
1,164 reads
How do you deal with problems in the real world? What steps should you follow? A new series looking at actual experiences at work. This one looks at a weeklong adventure in troubleshooting SQL Server applications.
2003-06-16
4,959 reads
LockwoodTech has released a new sql tool that analyzes the SQL Server transaction log to passively audit a SQL Server database. You can track inserts, updates, deletes and full row level detail of past transactions (even before the tool was installed). Client supports powerful filtering, grouping and sorting of audit data.
2003-06-16
37 reads
2003-06-12
4,994 reads
This is a performance analysis and tuning application. Visit the site to get to more info, they also have a free book on performance tuning (registration required). (Not reviewed)
2003-06-12
786 reads
Bundle SQL Deploy when you distribute a new version of your application to clients and all your database changes will happen automatically. Simply save database changes from Enterprise Manager, SQL Analyser or Visual Studio .NET as scripts (as most developers already do) and this utility enables automatic data version upgrades. Designed for Winforms, Webforms, VB, ASP and Access applications (and more), SSW SQL Deploy means you never have to worry when deploying applications again!
2003-06-11
45 reads
Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers.
2003-06-10
12,880 reads
Integrate high performance index- and search functionality in your SQL database.
Essentially, IMP Index Manager is a set of tools (search engine, administrative interface, etc.) to make it very easy to add search engine capabilities to SQL Server 2000. Easy to implement, and lightening fast performance. (Not Reviewed)
2003-06-10
1,529 reads
Vicktor has a bunch of scripts he uses to monitor performance, he explains why he built them and how to use them. Good coverage of the different reasons for slow performance.
2003-06-09
16,421 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers