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
13,046 reads
A short piece on indexing using multiple columns. For those of you that have 10 single column indexes, read a little about why you might choose to index on multiple columns.
2004-09-20
2,877 reads
A service oriented architecture seeks to decouple some of the tight connections normally built between systems and components. Here's a great overview on how messaging between systems can be setup from MSDN.
2004-09-20
1,216 reads
Renaming a server can be a mystery in SQL Server. The symtoms that SQL Server displays after you rename a server makes it look like you made a bad mistake.
2004-09-17 (first published: 2001-04-11)
63,285 reads
We've grown much faster and further than we expected and so the time has come to move. To a new collocation facility this weekend. We'll be down for a few hours Saturday and hopefully after that you won't notice a thing.
2004-09-17
2,838 reads
2004-09-17
4,502 reads
Another great article from David Poole looking at more user stereo types that the IT world must deal with. Read on for smile and a little fun.
2004-09-16
10,654 reads
The first article looking at the new BI scorecard technology from Microsoft. This allows you to quickly deploy some easy reports on your OLAP system. From datawarehouse.com.
2004-09-16
1,121 reads
What happens to SQL Server 2000 indexes over time? Fragmentation is one of the effects and Steve Jones looks at how you can work with and identity fragmentation.
2004-09-15
16,201 reads
Have you ever wanted to run DTS on a workstation or server that doesn't have SQL installed? Here's the items you need to move to make it happen.
2004-09-15
1,549 reads
By Zikato
A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...
Say you need outside help. You’ve exhausted all the things that you could do...
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
WA:08218154393 Jl. Khp Hasan Mustopa No.108, Padasuka, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat...
WA:08218154393 Jl. Ir. H. Juanda No.118, Lebakgede, Kecamatan Coblong, Kota Bandung, Jawa Barat 40132
Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server
In SQL Server 2025, I run this code:
select bit_count(-1)What is returned? See possible answers