The better server

Question

Post reply

The better server

stangman5l

SSC Enthusiast

Points: 129
More actions
January 22, 2009 at 5:53 pm

#199098

Thank you for your participation!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 1

Share with us why you want to know, please. And what do you define as "better"?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

stangman5l SSC Enthusiast Points: 129 More actions · Answer 2

Better in terms of usage, performance, and reliability. In my experience, I've notice that 2008 has a more user friendly UI and some better performance on certain tasking. However, I am having trouble getting the Report Server to come online. I have everything set up correctly in the config using my local service as the "Service Account". IE keeps shooting an "Unauthorized User or a Provider type not found" message. I just set it up last night so I haven't dug into it yet.

Any thoughts?

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

Agreed on most... but that doesn't tell us why you feel the need to take a survey on it. Are you trying to justify moving from 2k5 to 2k8?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

stangman5l SSC Enthusiast Points: 129 More actions · Answer 4

stangman5l

SSC Enthusiast

Points: 129

January 24, 2009 at 3:00 pm

#932289

Yes.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 5

Gosh... there's a thousand reasons. Here's some of the biggest reasons for me...

Server Audits

Database Audits

Performance Data Collection

Resource Governor Improvements

SQL Server Change Tracking (above and beyond Database Audits)

PARTITION TABLE Parallelism

Data Compression

File Stream handling

Backup Compression

PARTITION TABLE Switch Enhancement

MERGE Statement

Improvements to Analysis Services (I might finally start using it because of this)

... and a whole bunch of other stuff...

Transparent Data Encryption

Think user passwords in a Global environment

Add CPUs on the fly while the (VM) machine is up and running - Think "Month End" and "Year End" crunches

Improved database mirroring for offsite mirror

Policy based management

New Temporal, Geographic, and Hierarchical Data Types - Reduces storage needs for "Date Only"

Enhancements to XML

Sparse Column

Reduces storage needs when many NULLS are present

Greatly improved indexing (filtering) - Reduces storage needs on targeted sections of tables.

Enhanced SMS has some great new tools for Developers.

Pass Table Variables as parameters (heard it's not so good, though)

I recommend a good study of the "What's new" section of Books Online... should only take a couple of hours. Surveys lie...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions