Sign In
MSDN Blogs
Microsoft Blog Images
More ...
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Common Tasks
Email Blog Author
About
RSS for posts
Atom
Archives
Archives
May 2012
(3)
April 2012
(2)
March 2012
(2)
February 2012
(8)
January 2012
(8)
December 2011
(14)
November 2011
(7)
October 2011
(5)
September 2011
(3)
August 2010
(1)
July 2010
(3)
June 2010
(4)
May 2010
(4)
May 2008
(1)
February 2008
(6)
January 2008
(3)
December 2007
(25)
November 2007
(14)
Visitors log
Where you folks come from?
Blog - Title
May, 2010
MSDN Blogs
>
La bodeguita de Nacho
>
May, 2010
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
La bodeguita de Nacho
Reason why the SLOTS XECustomizableAttribute of package0.synchronous_bucketizer & package0.asynchronous_bucketizer seem to be interpreted incorrectly?
Posted
over 2 years ago
by
Nacho Alonso Portillo
0
Comments
Some friends of mine and I were trying to build some monitoring leveraging the XE bucketizer targets. During the exercise, we encountered that the value we were specifying in the SLOTS attribute was not exactly what was being used in the end. For example...
La bodeguita de Nacho
How to tell from ShowPlan output if (optimize for (unknown)) was used?
Posted
over 2 years ago
by
Nacho Alonso Portillo
0
Comments
This one question someone asked me recently. In SQL Server 2005, 2008, and 2008 R2 there’s no difference between the ParameterList node generated for a parameterized query optimized for the parameter’s runtime value and the ParameterList node generated...
La bodeguita de Nacho
Weird behavior of transaction log growth in SQL Server 2005, 2008, and R2
Posted
over 2 years ago
by
Nacho Alonso Portillo
0
Comments
Guys, just so that you are aware. There is a bug in the in the code of the function that grows the file so that whenever the difference between the new size and the current size is a multiple number of pages of any value between 0x80000 and 0x8001F the...
La bodeguita de Nacho
Starting with SQL Server 2008 DBCC PAGE displays INVALID COLUMN VALUE where it used to display the quiet not a number string representation (-1.#QNANs) in previous versions
Posted
over 2 years ago
by
Nacho Alonso Portillo
0
Comments
Until 2005 (included) the function used by DBCC PAGE to print a column’s content, converted the column’s value into the string that was finally printed out, without previously checking whether it was a valid value or not. Beginning with 2008, the validness...
Page 1 of 1 (4 items)