Additional Articles


Technical Article

MDX in Analysis Services: Mastering Time: Period - to - Date Aggregati

In this article, we began with a discussion of general business needs as related to the concept of relative time. We then undertook a practical, multi-step exercise, based upon a hypothetical business need, to illustrate a potential solution for a stated requirement.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-26

992 reads

Technical Article

Foreign keys chain in a view. It may be useful.

I made this view because I had to generate a sql server database from  an Oracle database and I had to knew the order in which I import tables.This view, which may be improved, contains the foreign key, the primary and detail table, the column and it's position and may be useful in  many situations

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-25 (first published: )

135 reads

Technical Article

MDX in Analysis Services: Mastering Time: Change across Periods

In this article and others subsequent to it, we will focus on time considerations in our MDX queries., and how we can successfully report change over time, as well as to accumulate those changes to present the precise snapshots, trends and other time-based metrics so dearly appreciated in business.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-25

1,221 reads

Technical Article

Into Fantasy Football? Join the SQLServerCentral.com League.

If you're into fantasy football, come waste some time with us and join our free league at Yahoo. Read the below instructions on how to join. Space is limitted in the first league to 12 teams so join quickly and the draft starts Tuesday! If it's popular, we'll create other leagues.


In order to join the league, just go to http://football.fantasysports.yahoo.com/f1,
click the "Sign Up Now" or "Get Another Team" button and
follow the links to "Join a Custom League". When prompted,
enter the League ID# and password below.

League ID#: 525071

Password: ssc

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-20

204 reads

Technical Article

Search for a string in a procedure, trigger or fun

This is an extension of two previous scripts, this one will produce a list of ojects that contain the first parameter and not the second. The function works as a table so if the user wants to list only functions, query as: select * from fn_sys_searchobject('text1','text2') where object_type = 'function'

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-08-19 (first published: )

135 reads

Blogs

Dazzling Stuff in Databricks (SQL) – Qualify

By

Once upon a time I had a series about some cool stuff in Snowflake:...

Advice I Like: Overnight Success

By

“Most overnight successes – in fact any significant successes – take at least 5...

T-SQL Tuesday #204: Are tech blogs dead?

By

This is my late response to T-SQL Tuesday #204. I almost always forget about...

Read the latest Blogs

Forums

Why Successful SQL Server Backups Are Not Enough

By Almighty

Comments posted to this topic are about the item Why Successful SQL Server Backups...

Adding Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Bits II

An Unlimited Token Budget

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unlimited Token Budget

Visit the forum

Question of the Day

Adding Bits II

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, true)
GO

See possible answers