Upgrade your knowledge about sql 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Upgrade your knowledge about sql 2005

Author

Topic

willow_mimi
Starting Member

14 Posts

Posted - 2008-07-26 : 05:26:24

hi all ,
Want to know about sql server administration (tips n new features) ??
read this:
[url]http://myblog-sql.blogspot.com[/url]

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-26 : 09:16:01

Any questions???

willow_mimi
Starting Member

14 Posts

Posted - 2008-07-26 : 11:20:08

have u ever tried SQL 2008?what are the enhancements?
thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-26 : 13:54:42

Never tried.My company doesn't use it so not interested.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-26 : 14:11:19

quote:
Originally posted by willow_mimi

have u ever tried SQL 2008?what are the enhancements?
thanks

Have started using it. Some of enhancements include MERGE statement,date datatype,intellisense in management studio,grouping sets. still exploring other new features.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-26 : 21:06:17

I tested backup with compress, works well and like it.

willow_mimi
Starting Member

14 Posts

Posted - 2008-07-26 : 21:27:38

To:rmiao
what is the special things with backup with compress? is it faster that backup in sql 2000/2005?
To:visakh16
what about date datatype? would you explain it more detail?
thanks :)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-26 : 22:14:09

Backup with compress is faster and backup file is much smaller.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-27 : 02:02:59

quote:
Originally posted by willow_mimi

To:rmiao
what is the special things with backup with compress? is it faster that backup in sql 2000/2005?
To:visakh16
what about date datatype? would you explain it more detail?
thanks :)

here's an article in this forums which explains about date datatype

http://www.sqlteam.com/article/using-the-date-data-type-in-sql-server-2008

willow_mimi
Starting Member

14 Posts

Posted - 2008-07-27 : 02:54:38

thanks for your posting :)hmm just curious about intellisense?

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-27 : 09:28:52

i found it quite annoying at first but now quite like it. i find it most useful for functions. i.e. not having to remember what order to put in parameters etc

quote:
Originally posted by willow_mimi

thanks for your posting :)hmm just curious about intellisense?

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-07-27 : 11:22:32

At found it quite annoying at 1st, 2nd, and 3rd. At 4th I uninstalled it.
I have no problem with the concept, I do not think it was implemented well for SQL. Maybe future versions will be better.

e4 d5 xd5 Nf6

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-27 : 13:53:30

quote:
Originally posted by blindman

At found it quite annoying at 1st, 2nd, and 3rd. At 4th I uninstalled it.
I have no problem with the concept, I do not think it was implemented well for SQL. Maybe future versions will be better.

e4 d5 xd5 Nf6

Me too have the same experience

i felt it as making job lot more difficult and i too stopped using it.

willow_mimi
Starting Member

14 Posts

Posted - 2008-07-28 : 05:29:20

oh really? hmm dont you think that migrate to sql 2008 is too fast??
i still enjoy with sql 2005 thought :)

Murni Lim,MCTS,MCITP
http://myblog-sql.blogspot.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources