by Justin Gunther As queries become more complex, temporary tables are used more and more. While temporary table may sometimes be unavoidable, they can often be sidestepped by using derived tables instead. In brief, a derived table is the result of using another SELECT statement in the FROM cla

By Sean Vaccariello With ADO.Net it has never been easier to parameterize data from a SQL database. This article focuses on retrieving selective data from a SQL database using ADO.Net. There's not much more to say, so let's get started.

IMHO, the best feature of MS Access is the TRANSFORM statement, used to create cross-tabs/pivot tables. It does all of the work of dynamically generating the cross-tabulation and the summary calculations. T-SQL unfortunately doesn't have this statement, so you're stuck using complicated SQL

The industry break-thru eData Usage AnalyzerTM, Zero Impact Service Level MonitorTM, Zero Impact Top N Sql AnalyzerTM, and Zero Impact Sql MonitorTM products from Sql Power Tools. See what they offer.

Author Rick DobsonThis book concentrates on the use of Access 2000 projects with MSDE and SQL Server engines and will highlight the ease with which sophisticated, scalable database solutions may be constructed. Since the delivery of data over the Internet is becoming crucial, this book will also

Author, Rob Vieira<br>SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and da

From SQL Team, Garth is back with another article. This one talks about building a comma-separated value string for use in HTML SELECT tags. It's also handy anytime you need to turn multiple records into a CSV field. It's a little longer and has some HTML but a good read.

SQL Connections is SQL Server Magazine Live and features over 40 non-stop SQL Server 2000 & SQL Server 7.0 sessions at the beautiful Hyatt Grand Cypress Resort. Come hear Microsoft's Ryan Trout, Swynk.com's Steve Wynkoop, and many other SQL Server experts reveal the latest SQL Server secr

From Sqlmag, by Michael Otey Coming on the heels of Oracle's latest $1 million challenge, the recent Transaction Processing Performance Council (TPC) Web site reorganization seems to be further evidence that Oracle is more worried about Microsoft and SQL Server 2000 than you might expect. I

If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes. But this article is not about them. This article is about whether or not the SQL Server Query Optimizer will use your carefully crafted indexes. You may