10. Plug-in model for SSMS. SSMS 2005 also had a plug-in model, but it was not published, so the few developers that braved that environment were flying blind. Apparently for 2008, the plug-in model will be published and a thousand add-ins will bloom.
9. Inline variable assignment. I often wondered why, as a language, SQL languishes behind the times. I mean, it has barely any modern syntactic sugar. Well, in this version, they are at least scratching the the tip of the iceberg.
Instead of:
DECLARE @myVar int SET @myVar = 5
you can do it in one line:
DECLARE @myVar int = 5
Sweet.
8. C like math syntax. SET @i += 5. Enough said. They finally let a C# developer on the SQL team.
7. Auditing. It’s a 10 dollar word for storing changes to your data for later review, debugging or in response to regulatory laws. It’s a thankless and a mundane task and no one is ever excited by the prospect of writing triggers to handle it. SQL Server 2008 introduces automatic auditing, so we can now check one thing off our to do list.
6. Compression. You may think that this feature is a waste of time, but it’s not what it sounds like. The release will offer row-level and page-level compression. The compression mostly takes place on the metadata. For instance, page compression will store common data for affected rows in a single place.
The metadata storage for variable length fields is going to be completely crazy: they are pushing things into bits (instead of bytes). For instance, length of the varchar will be stored in 3 bits.
Anyway, I don’t really care about space savings – storage is cheap. What I do care about is that the feature promised (key word here “promises”) to reduce I/O and RAM utilization, while increasing CPU utilization. Every single performance problem I ever dealt with had to do with I/O overloading. Will see how this plays out. I am skeptical until I see some real world production benchmarks.
5. Filtered Indexes. This is another feature that sounds great – will have to see how it plays out. Anyway, it allows you to create an index while specifying what rows are not to be in the index. For example, index all rows where Status != null. Theoretically, it’ll get rid of all the dead weight in the index, allowing for faster queries.
4. Resource governor. All I can say is FINALLY. Sybase has had it since version 12 (that’s last millennium, people). Basically it allows the DBA to specify how much resources (e.g. CPU/RAM) each user is entitled to. At the very least, it’ll prevent people, with sparse SQL knowledge from shooting off a query with a Cartesian product and bringing down the box.
Actually Sybase is still ahead of MS on this feature. Its ASE server allows you to prioritize one user over another – a feature that I found immensely useful.
3. Plan freezing. This is a solution to my personal pet peeve. Sometimes SQL Server decides to change its plan on you (in response to data changes, etc…). If you’ve achieved your optimal query plan, now you can stick with it. Yeah, I know, hints are evil, but there are situations when you want to take a hammer to SQL Server – well, this is the chill pill.
2. Processing of delimited strings. This is awesome and I could have used this feature…well, always. Currently, we pass in delimited strings in the following manner:
exec sp_MySproc 'murphy,35;galen,31;samuels,27;colton,42'
Then the stored proc needs to parse the string into a usable form – a mindless task.
In 2008, Microsoft introduced Table Value Parameters (TVP).
CREATE TYPE PeepsType AS TABLE (Name varchar(20), Age int) DECLARE @myPeeps PeepsType INSERT @myPeeps SELECT 'murphy', 35 INSERT @myPeeps SELECT 'galen', 31 INSERT @myPeeps SELECT 'samuels', 27 INSERT @myPeeps SELECT 'colton', 42exec sp_MySproc2 @myPeeps
And the sproc would look like this:
CREATE PROCEDURE sp_MySproc2(@myPeeps PeepsType READONLY) ...
The advantage here is that you can treat the Table Type as a regular table, use it in joins, etc. Say goodbye to all those string parsing routines.
1. Intellisense in the SQL Server Management Studio (SSMS). This has been previously possible in SQL Server 2000 and 2005 with use of 3rd party add-ins like SQL Prompt ($195). But these tools are a horrible hack at best (e.g. they hook into the editor window and try to interpret what the application is doing).
Built-in intellisense is huge – it means new people can easily learn the database schema as they go.
Thank you, I’ve just been searching for info about this subject
for a long time and yours is the best I have came upon till now.
However, what about the conclusion? Are you sure concerning the source?
I pay a visit everyday some web sites and information sites to read posts, except
this weblog offers quality based writing.
When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time
a comment is added I get several emails with the same comment.
Is there any way you can remove me from that service? Thank you!
You’ve made some good points there. I checked on the web for additional information about the issue and
found most individuals will go along with your views on this web site.
It has already been told that aesthetic dentistry plays a pivotal
role in enhancing the appearance of your teeth. Orthodontist
assistants work with patients at all stages of an orthodontic procedure as an aide to the orthodontist,
and may also carry out some minor procedures alone. Acquiring
a fabulous dentist by using Norway can be certainly venturing be trustworthy concerning problem of they’ve teeth crucial.
This is very interesting, You’re a very skilled blogger.
I have joined your feed and look forward to seeking more of
your wonderful post. Also, I’ve shared your web site in my social networks!
At this time it appears like Expression Engine is the top blogging platform available right now.
(from what I’ve read) Is that what you’re using on your blog?
s a lot of sunlight being absorbed and heating your home.
These are the major causes responsible for damaging the roofing system.
Sure you may be able to do a little stargazing from
the comfort of your living room recliner, but I think most would agree that a hole
in the roof is very high priority on temporary repair lists.
You should begin checking the hassle inside the house.
Time will always come that the roof repair job isn’t sufficient.
 If your roof leak repair needs to be made where two surfaces
meet, such as, at a chimney or vent then you need to look for breaks in the
caulking or flashing.
True, there are comedians that cuss a lot, but you got to earn that right before you do that.
For more information on my Workshops, Writing Mastermind Groups and private coaching, please go to my
website listed below and feel free to call me any time.
He represented his homeland in four Olympics and is
a three-time indoor world champ in the 1500 meters.
hi!,I really like your writing very a lot! percentage we be in contact more approximately your article
on AOL? I require a specialist in this area to unravel my problem.
Maybe that’s you! Taking a look forward to see you.
Woah! I’m really loving the template/theme of this site. It’s simple,
yet effective. A lot of times it’s hard to get that “perfect balance” between user friendliness and appearance.
I must say you have done a fantastic job with this.
In addition, the blog loads very quick for me on Opera.
Superb Blog!