|
|
|
|
Got a SQL Server question that needs answering? SQLblog now has a SQL Server forum that can be found at http://sqlblog.com/forums/57/ShowForum.aspx.
Latest Blog Posts
-
|
Now public on Erland Sommarskog's website. Enjoy! Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!...
|
-
|
Every year I put out resolutions, but this year is a little different. I will post my SQL only blog resolutions here, and my personal ones here . Every year I find my ability to put out stuff is limited by my desire for sleep and fun, and this year...
|
-
|
First, an up front apology to Mosha - this is half in jest, half real. MDX is a powerful and useful language, but I find that its very existence has made my life very difficult when it comes to developing a solid Analysis Services solution. That's not...
|
-
|
Although the best known deadlock scenario involves two connections modifying two tables in different order, there are also other deadlock scenarios involving only one table. Besides, in some scenarios each connection needs to issue only one statement,...
|
-
|
During SQL PASS 2008 summit , I gave full day preconference seminar “ Deep Dive to MDX ”. The evaluation forms now have arrived, and the scores for the content, relevance and depth portion of the seminar are very good. The scores are not as high, however,...
|
-
|
Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog last year Here we are with another fascinating collection of links, some of them are chosen for their content and some of them for the great comments....
|
-
|
Last year on December 31 I posted part of a larger monitoring script that I had been working on for a few months . I received lots of great feedback on the little script in both the comments and from people I was working with, and over the course of the...
|
-
|
Danny Gould has a new (beta) version of his Internals Viewer, that you can download from Codeplex at http://www.codeplex.com/InternalsViewer I've just started playing around with it, and the coolest thing is that it integrates right with your Management...
|
-
|
A script to fragment a test file Well, this post won't cover any actual test results and is not specific to SAN. But in the spirit of full disclosure, I've attached the script I used to control the fragmentation level of the test files mentioned in this...
|
-
|
Disclaimer: I'm not an infrastructure DBA.Probably everything below is just bullshit. Recently our talented IT guys destroyed disk on a virtual machine. They chose the disk carefully - it was the one with master database. How do you restore master db...
|
-
|
In case this is your first visit to SQLBlog.com, Linchi Shea does very methodical analysis of the performance and behaviour of disk arrays. His most recent listings specifically explore file fragmentation and its affects on performance on storage. The...
|
-
|
SQL Server workloads So far, the discussions in all the previous posts ( 1 , 2 , 3 , and 4 ) on the performance impact of file fragmentation on a drive presented from a high-end enterprise-class disk array are related to disk I/O workloads. Ultimately,...
|
-
|
I was catching up on my blog reading and came across a very nice post on Ward Pond's blog ; he gives us some TSQL code that produces a holiday message. It's a few days late, but it's the thought that counts, right? I did have a few problems with the code...
|
-
|
Kevin Kline recently posted , wondering about the directions for LINQ. When people refer to LINQ, they're often referring to "LINQ to SQL" instead. LINQ as a language enhancement is pretty cool. It provides a way to easy navigate enumerable objects. The...
|
-
|
As promised, upon return from a trip to the frozen tundra of Northern Ontario, I am posting the latest updates from last week's release of SQL Server 2005 Service Pack 3. For those who have been waiting to test the service pack until the post-SP3 cumulative...
|
-
|
There’s been a lot of positive press for LINQ, such as the article about LINQ by Mike Otey at http://www.sqlmag.com/Article/ArticleID/48759/sql_server_48759.html . You can also find lots of glowing reviews and info about LINQ by Troy Magennis at http://blog.aspiring-technology.com/...
|
-
|
Some of you are aware that I am writing an (almost) weekly commentary for a SQL Server Magazine e-newsletter called SQL Server Magazine UPDATE . I was told that I could write about anything related to SQL Server, but that turned out not to be true. There...
|
-
|
Lies, damned lies, and statistics! If you have read my three previous posts ( 1 , 2 , 3 ), you may walk away with an impression that on a drive presented from a high-end enterprise class disk array, Windows file fragmentation does not have a significant...
|
-
|
I frequently do calculations against decimal values. In some cases casting decimal values to float ASAP, prior to any calculations, yields better accuracy. For example, in the following script both expressions should return 12100.0: SELECT POWER ( POWER...
|
-
|
You know about page splits... if a table has a clustered index, any new row has to be inserted into the appropriate page, based on the clustered index key order. However, if the page where the new row belongs is full, SQL Server will split the page into...
|
There are
317 guest(s) online.
Currently there are no online users.
|
|
|
|
|