|
|
|
|
Browse by Tags
All Tags » SQL Server 2008 (RSS)
-
I am just taking a quick show of hands; and maybe some information, if you are willing. (And if this hasn't happened to you, I apologize for taking up your time.) I have had various problems on multiple installations of Books Online throughout the entire Read More...
|
-
For those of you who connect to database servers where you are not in full control over all databases, or where some of your databases are ever offline (or auto-closed), the new version of Management Studio that is shipping with SQL Server 2008 is going Read More...
|
-
SQL Server's new logo has been published: Courtesy of Wesley . And I have taken a screen shot of the new splash screen for Management Studio: Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More...
|
-
As you may know, I have been heavily involved in testing a lot of the new features in SQL Server 2008, and am likely as excited as anybody about its release. Since I work at a fairly progressive company, I spoke with two of my superiors today - independently Read More...
|
-
Currently, the plans for IntelliSense are to support SQL Server 2008 *ONLY*... since it works against SQL Server 2005 in the February CTP, I was very surprised to learn that it is being dropped by RTM (and possibly by RC0). This is mainly because of the Read More...
|
-
A frequently asked question that surfaced again today is, "how do I see when my data has been accessed last?" SQL Server does not track this information for you. SELECT triggers still do not exist. Third party tools are expensive and can incur unexpected Read More...
|
-
As you may already know, I am not a big fan of the MONEY data type, because of its inflexibility, accuracy problems, and the expectations the name of the type evokes in new users. If I had my way, MONEY would become a synonym for DECIMAL in SQL Server Read More...
|
-
While playing with the new Policy-Based Management (PBM) features of SQL Server 2008 the other day, I came across a really annoying syntax implementation that is going to trip up a lot of people unless it is fixed. We all know how DATEADD works: SELECT Read More...
|
-
It is 2008. Not 1992. Why are we still intentionally creating filenames that conform to the limitations of ancient DOS and Windows 3.1 naming standards? This came up today in one of the SQL Server newsgroups, where a user was trying to find the data file Read More...
|
-
No, this is not a "funny funny, ha ha!" April Fool's Day post (though I do find those entertaining, and considered posting one myself). This is for real, and it almost made me tingle a little. I saw this comment from Eric Kang in a Connect item yesterday Read More...
|
-
I read a comment in a Connect suggestion today that implied that implementing their suggestion would allow SQL Server to " keep up with MySql ." Regardless of the actual suggestion, that made me laugh out loud... and since I was on the train, that got Read More...
|
-
For some, the answer is easy. Since Tibor reminded me several months ago that <> == standard and != <> standard (and yes, I used that notation on purpose), I have been making a conscious effort to use only <> going forward. Similarly, Read More...
|
-
I am still on the fence about whether this is a good thing or a bad thing. However, in the next build of SQL Server 2008 you will be able to get your hands on, you will find that some element limits have changed, just a bit. With the introduction of sparse Read More...
|
-
Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008 ; previously, I had noticed that a few of the existing DMVs from 2005 had changed slightly. So, Denis sparked my curiosity, and I ran the following query on a recent build of SQL Server Read More...
|
-
The SQL team seems to have been quite busy recently, commenting on and closing out many bugs and suggestions that have been raised, I suppose as they close out work on the SQL Server 2008 codebase. Some (like Buck Woody and Bill Ramos, among others) have Read More...
|
|
|
|
|
|