myLittleTools.net is pleased to announce the release of its web-based MS SQL and MSDE database administration tool. Several tools have been added, including "BackUp and Restore database" tools, "CSV Import" tool, "Generate INSERT scripts" tool, "Detach/attach database" tool. Several toys have also been added, including the possibility to display database space used with SVG graph, or a new skin.
2003-11-05
1,734 reads
2003-11-04
179 reads
Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.
2003-11-04
1,286 reads
Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.
2003-11-03
5,199 reads
Microsoft is soliciting input on email functionality in Yukon. Follow the link to complete the survey. You can also discuss it here on the site:
http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17739&FORUM_ID=9&CAT_ID=1&Topic_Title=SQL+Mail+and+Yukon%2C+what+do+you+want+to+see%2E%2E%2E&Forum_Title=General
2003-11-03
524 reads
2003-11-03
3,335 reads
New Author! This is a great article, seems like it covers almost every question you might have about installing and using the 64 bit version of SQL2K.
2003-10-31
9,993 reads
New Author! This is a great walkthrough that starts out with a description of the problem and goes all the way to the solution - all using TSQL.
2003-10-30
12,145 reads
This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of these new features, to inspect a given spid, and display the currently executing line/query
2003-10-30
56 reads
New Author! Ramesh talks a little about database theory, using the ERD, and how you can put it to work.
2003-10-28
22,494 reads
I’ve been thinking a lot lately about what it actually takes to make an...
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
I’ve uploaded the slides for my Techorama session Microsoft Fabric for Dummies and my...
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Comments posted to this topic are about the item Finish the quote
Comments posted to this topic are about the item Everything I Needed to Know...
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers