Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
2007-09-22 (first published: 2003-06-05)
30,048 reads
2003-06-04
1 reads
Shotgun approach: Put indexes on columns of tables referenced by in the join clause. Index columns which are selective and referenced in the where clause. Use Graphical Show Plan: (Highlight your query & ctrl-L) go after the higher % tasks and add indexes where neccessary. Remember the SQL optimizer will often ignore indexes that it […]
2003-06-04
1 reads
Thinking about it, I think it's a hoax. How will I get my geeky looking cap? Cheers, Crispin
2003-06-04
1 reads
These guys have a nice app. http://www.xpressapps.com I have been using it on and off for a couple months now. The version I have is still Beta but there are very few bugs. Non of them are critical though. Brian (I think) was going to review it. Not seen it yet. It's a cool product […]
2003-06-03
As a developer, I was pretty exicted with the version of SQL Server that allowed me to create an 8000 byte field instead of using a text field. Little did I know that I could only have one 8000 byte field per table. Maybe your developers aren't aware of the 8060 record limit. Educate them! […]
2003-06-03
1 reads
Have you consider using log shipping instead of transactional replication?
2003-06-03
Why is the same named object required in modern dbs? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-03
1 reads
2003-06-03
Hi amelvin, quote: Perhaps the site owners could make a feature of favourite books, when I'm buying from Amazon (or almost anywhere online) I always check out reviews and pick out the most recommended things. Perhaps a place like this could develop such a facility rather than a simple, occasional review. take a look at […]
2003-06-03
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers