David takes us through why he believes trying to run SQL and IIS on the same box is a bad idea. It's a common notion that it IS a bad thing to do, but you have real justification? Read this and you will!
2003-06-20
14,561 reads
Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.
2003-06-19
1,922 reads
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,267 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,955 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,992 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,876 reads
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Comments posted to this topic are about the item Pushing the Limits of AGs
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers