External Article

SQL Server 2005 System Tables and Views

When a SQL Server object is created, its properties are called metadata. The metadata is stored in special System Tables. For example, in SQL 2000, when a new column was created, the column name and data type could be found in an internal System Table called syscolumns. All SQL objects produce metadata. Every time SQL 2000 Enterprise Manager or SQL 2005 SQL Server Management Studio is browsed, the information displayed about database, tables, and all objects, comes from this metadata.

SQLServerCentral Article

Suggestions for Datatypes

SQL Server 2000 does a lot of things for the DBA, tuning, updating statistics, scheduling tasks, wizards and more. But one thing that it does not help with is choosing the correct data type for your data. New author Amit Lohia brings us a technique and some code that will examine your existing data and suggest places where another data type might be a better choice.

Technical Article

Using ANSI SQL as a Conceptual Hierarchical Data Modeling

This paper will explain and show how standard ANSI SQL processors can naturally model and automatically process complex multi-leg hierarchical data structures at a full conceptual hierarchical level. This also means the query user does not need to have structure knowledge of the hierarchical structures involved. The data modeling capability includes dynamically combining logical hierarchical relational and physical XML data structures at a full hierarchical level. This also includes the ability to link below the root of the lower level structure intuitively forming a valid unified hierarchical structure. As will be shown, ANSI SQL’s high level hierarchical data processing allows the flexible conceptual control of hierarchical node promotion, fragment processing, structure transformation, and variable structure creation.

External Article

Using CROSS APPLY in SQL Server 2005

My interest in writing this article was started by an MSDN article titled SQL Server 2005: The CLR Enters the Relational Stage. The article shows how to write a function that returns the top three countries per category. That's always been something that was difficult to do in SQL so I was curious about the approach. The article started out well but I was very unhappy by the end. It's just soooo much easier to do this in SQL Server 2005 using the new CROSS APPLY clause in Transact-SQL. So I'm going to write a query to return the top 3 orders for each customer and I'm going to do it in about 10 lines of SQL. (UPDATE: An alert reader found an even better approach!)

SQLServerCentral Article

Turbo for SQL Server

Searching data is an essential part of SQL Server applications, especially text searching. While Full Text Search in SQL Server 2000 works, it lacks some important features that Turbo for SQL Server can handle. Read this review of the product and see if this is a way you can enhance the search functions in your application.

Blogs

Finding fields used in a Power BI report in PBIR format with Semantic Link Labs

By

Have you ever wondered where a certain field is used in a report? Or...

Adding Test data to msdb.sysjobhistory

By

One of our internal people was looking to test some process in (I assume)...

Microsoft Ignite Announcements Nov 2024

By

Announced at Microsoft Ignite last week were some new product features related to the...

Read the latest Blogs

Forums

A Strange Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Strange Query

Primary and Secondary Filegroup

By nshete

Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...

Import data from json file with special characters

By don075

I am using the following script to import data from a json file. This...

Visit the forum

Question of the Day

A Strange Query

What does this return? 

SELECT x=1 
WHERE (SELECT 1) IN ( 1, 2, 3)

See possible answers