Viewing 15 posts - 226 through 240 (of 1,162 total)
hobt=Heap or B-Tree, so I'm guessing some kind of sub-partitioning? Oracle has a composite partitioning feature...
March 8, 2013 at 9:58 am
karthik M (3/8/2013)
is this a secret maintened by microsoft ? 🙂
In the sense that it's proprietary information that they've chosen not to share and SQL Server is a closed source...
March 8, 2013 at 4:22 am
The optimiser is the wrong term for this, it's not the query optimiser that performs sorts.
The Query Engine obviously uses algorithms to perform sorts. Those algorithms are proprietary and...
March 8, 2013 at 2:42 am
Rugby Union is my sport, and the rulebook is a mess, extremely complicated and tweaked pretty much every season.
It's refereed inconsistently, even at the international level and you'll see tactics...
March 7, 2013 at 10:15 am
It could be that the old server had a different number of system buses (NUMA nodes) and this is affecting PLE. I assume you're looking at the Buffer Manager: PLE...
February 28, 2013 at 8:07 am
AWS meaning Amazon Web Services? In an EC2 instance, or through Amazon RDS?
Are you connecting to your work network via VPN, or trying to access directly via the internet?
By...
February 25, 2013 at 4:53 am
SQL_Enthusiast (2/21/2013)
Thank you for the response.
why you think that random cant be unique ? sql server internally generate this 32 bit alphanumeric code.
I didn't mean random like, "What...
February 22, 2013 at 3:16 am
If I'm understanding it, the requirement as specified sounds fundamentally row-by-row as you must know what the previous row in the sequence did in order to process the next row,...
February 12, 2013 at 9:33 am
Jeff Moden (2/11/2013)
HowardW (2/11/2013)
How about the National Climate Data Center:
By Jove! That might be just what the doctor ordered! The files are zipped using Gun-Zip, the directory structure...
February 11, 2013 at 5:52 am
I do mostly agree with Grant and technically, all that data is available in the metadata and shouldn't need to be reflected in the object name.
However, I am quite...
February 11, 2013 at 5:24 am
Only where the fixes listed for that Service Pack need it to. The general aim of a Service Pack is to fix bugs, but not to otherwise alter functionality, so...
February 11, 2013 at 4:05 am
The message is fairly clear...
You have and END without a corresponding BEGIN. Format your code better and it becomes obvious:
BEGIN
DECLARE @FATHER AS INT
...
February 8, 2013 at 10:26 am
graham.allwood (2/6/2013)
So, does that mean all my FK columns should really be indexed?
As a rule of thumb, yes, for the sort of performance issues you've experienced. But as with everything...
February 6, 2013 at 2:22 am
Does another large table reference it with a foreign key?
February 5, 2013 at 9:47 am
Viewing 15 posts - 226 through 240 (of 1,162 total)