2005-01-18
23 reads
Basics
A Survey of Microsoft SQL Server 2000 XML Features
An oldy, but good basic look at XML and how it fits into SQL Server 2000.
2004-09-23
3,008 reads
Handling Simple XML Using T-SQL
SQL Server 2000 integrates a number of features to work with XML data and SQL Server 2005 should expand upon that. However the SQL Server 2000 extensions for working with XML data in T-SQL are not that mature. New author Eli Leiba looks at how he can traverse an XML file using T-SQL code.
2004-09-20
12,940 reads
Lookup Table Design
Designing a SQL Server database is a challenging task. Making decisions about how to build tables, their relations, etc. can be a full time job for any DBA helping to build an application. Lookup tables are a part of just about every application that you work with or build a back end for. Leo Peysakhovich brings us an article on database design that deals specifically with lookup tables.
2004-07-27
27,870 reads
Reducing Round Trips Part 4
The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one!
2004-04-23
8,973 reads
2004-03-23
RE: Small WHERE clause problem
Yes, you're right about NULL. I just tried the use of a boolean bitUseDateSelection (which defaults to 0 unless both dates aren't NULL).The result would be something like: SELECT * FROM invoice WHERE @bitUseDateSelection = 0 OR [date] BETWEEN @DateFrom AND @DateUntil Thanks for your reply.Gerry
2004-03-19
RE: sp_resetstatus
What did you get after running the command? Look at both SQL Server errorlog and eventlogs to see what is the cause.
2003-12-16
Worst Practices - Not Using Primary Keys and Clustered Indexes
Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!
2008-05-09 (first published: 2003-11-10)
66,278 reads
2008-01-04 (first published: 2003-09-26)
184,979 reads
Blogs
Our Contributions Towards a Stronger Open Source Future
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
Rebuilding a SQL Server Database Transaction Log
“Could you help me, we deleted the database’s transaction log file and now that...
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers