Are you interested in a raise? Asif Sayed got one from a well written report. This time he brings us a beginners' looks at Reporting Services 2005 using a smart client for testing.
2006-09-05
11,600 reads
In this article, we examine some of the best new features and characteristics available in the 2005 version.
2006-09-04
1,994 reads
Andy Warren brings us an introduction the the Report Builder in SQL Server 2005. It's the less often used tool for developing and customizing reports that you can give to end users and lower the number of requests your developers receive.
2006-08-28
7,926 reads
Reporting Services is quickly becoming one of the most popular parts of SQL Server and new author Jonathan Spink brings us an interesting use of this subsystem. He explains how Reporting Services can do more than just display data; it can also provide an easy interactive way to make changes without the overhead of a complete .NET application.
2006-08-09
6,927 reads
Reporting Services has proven itself to be an amazing platform on which to develop all types of reports. Author Asif Sayed brings us some .NET code for using Reporting Services to return data recursively in a report.
2006-07-12
14,704 reads
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
2006-07-07
1,421 reads
Use Linked Reports to provide multiple "versions" of a single source report, as a mechanism for restricting consumer groups to their respective data in accordance with a "need to know."
2006-06-28
2,200 reads
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.
2006-06-01
25,740 reads
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
By ReviewMyDB
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages....
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Telp/Wa 62 821-8200-233 Jl. Raya Cilandak KKO No.9, RT.1/RW.5, Ragunan, Ps. Minggu, Kota Jakarta...
Telp/Wa 62 821-8200-203 Gedung Perkantoran Hijau Arkadia, Tower C - Ground Floor, unit C103,...
Telp/Wa 62 821-8200-174 Menara Karya, Jl. H. R. Rasuna Said Ground floor, RT.1/RW.2, Kuningan,...
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers