Development

Creating a Basic SSAS Cube

  • Article

In this video demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube. Free registration required.

2006-07-12

1,597 reads

Data Driven Subscriptions

  • Article

Reporting Services is a great subsystem for SQL Server that fulfills quite a few needs. However just like SQL Server, there are some features that are limited to the Enterprise Editions, something that not every user can afford to implement. New author Jason Selburg brings us a way to implement subscriptions to reports using Standard edition.

5 (6)

2006-06-01

23,312 reads

Load 1TB in less than 1 hour

  • Article

This project was done using SQL Server 2005 Enterprise Edition (with SP1 beta) using the BULK INSERT command with 60 parallel input files, each of approximately 16.67 GB. The best time I got was 50 minutes. Hewlett Packard was kind enough to loan me some time one night on the machine they use to do the TPC-H tests. It is an Itanium2 Superdome with 64 1.6GHZ 9M (Madison) CPUs. For the insert tests the system was equipped with 256GB of RAM. The HP SAN configuration is rated at 14GB per second throughput.

2006-05-30

2,290 reads

Blogs

Getting Started with Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

How SQL Server stores data types: DATETIMEOFFSET

By

If you’d like to check out the previous instalment in this series on storing...

Daily Coping 16 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Inventory toolkit issues

By mtz676

Anybody has run into MAPS assessment toolkit installation issues for sql server 2019/2017.Also maps...

Have an emergency. Prod is down.

By ALearningDBA

Our prod server is down. I was applying a security patch on our secondary...

Help with Boolean check box combinations

By Hogie503

Hi SQL Experts, I have a Store Procedure with snippets of code listed below....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers