|
|
|
|
Browse by Tags
All Tags » bug (RSS)
-
What happens when NUMA affinity meets query parallelism? It gets no respect!
SQL Server allows you to affinitize a TCP port to a specific NUMA node or a group of NUMA nodes. Books Online has an article on How to: Map TCP/IP ports to NUMA Nodes. And this BOL article discusses various NUMA affinity scenarios.
Recently, I have been playing with ...
-
We (I found the issue, Chris created the repro) detected a possible bug using DirectSlice and MeasureExpression.We just posted it here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=455732 The issue could be very dangerous resulting in wrong query results on cells affected by DirectSlice property and ...
-
Maybe I should change the topic to ''Do you know?''. ''Did you know'' seems to imply that _I_ actually know the answer. It seems very tricky to know for sure if a bug has been fixed, unless you have an actual bug number from Microsoft. If you have a bug numnber, you can check the list of fixes in the KB article that contains the list of ...
-
Someone had a problem with 8 year old procs which started to fail after moving to SQL Server 2008Of course he should have used ints, but let's see what happens
Run this code on SQL Server 2005 and 2000
DECLARE @num_Passed Numeric(2, 0);
SET @num_Passed = -1;
SELECT @num_Passed
IF (@num_Passed = 0)
PRINT 'True';
No problem ...
-
I was writing a query and managed to mistype INTERSECT, I typed INTERCEPT and to my surprise the query ran, it returned 2 result set just as if INTERCEPT wasn't there at all Try it yourself
CREATE TABLE testnulls (ID INT) INSERT INTO testnulls VALUES (1) INSERT INTO testnulls VALUES (2) INSERT INTO testnulls VALUES (null)
CREATE TABLE testjoin ...
-
No, I'm not talking about US dollars, which are not worth much at all these days. I'm talking about the $ used in a particular construct in SQL Server 2005 to get information about a partition definition. There is a construct called $PARTITION which the BOL actually refers to as a function, but it doesn't act like any other function in the ...
-
In the last months, I got the infamous ''it's by design'' answer for many bugs/issues/irrational behaviors I posted to Microsoft. For most of them I used the Connect web site, in a couple of cases I opened a formal incident to Microsoft support.
There are a lot of story (in and outside Microsoft) about the ''it's by design'' excuse and most of ...
|
|
|
|
|