Viewing 15 posts - 1,711 through 1,725 (of 8,416 total)
We use Fusion-io storage on extremely large sets of financial data. We are aware of the technical reasons to rebuild indexes (larger IOs, space usage, and so on) but...
September 13, 2011 at 6:19 pm
I've seen this done both ways successfully.
My personal favourite, in many circumstances (and assuming Enterprise Edition) is same database with sensible partitioning/file group/SAN arrangements. Proper configuration can make development...
September 13, 2011 at 6:11 pm
Tom.Thomson (9/8/2011)
But the behaviour still seems bizarre to me. Why should the loop join hint be taken to imply the (Force Order) option - if I...
September 8, 2011 at 11:17 am
Toreador (9/8/2011)
September 8, 2011 at 2:13 am
rob mcnicol (9/7/2011)
September 8, 2011 at 2:07 am
mtillman-921105 (9/7/2011)
SQLkiwi (9/7/2011)
Stefan Krzywicki (9/7/2011)
Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest day of the year?
Talking...
September 7, 2011 at 1:47 pm
GilaMonster (9/7/2011)
SQLkiwi (9/7/2011)
Stefan Krzywicki (9/7/2011)
Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest day of the year?
Talking...
September 7, 2011 at 1:25 pm
Stefan Krzywicki (9/7/2011)
Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest day of the year?
Talking of birthday...
September 7, 2011 at 1:06 pm
R.P.Rozema (9/7/2011)
September 7, 2011 at 1:00 pm
Stefan Krzywicki (9/7/2011)
OK, who had 9/7/2011 in the end of the world pool?
Hmm. Where's the incentive to win?
September 7, 2011 at 11:08 am
jcrawf02 (9/7/2011)
September 7, 2011 at 10:54 am
Interesting T-shirts. I just used their custom facility to design a T-shirt with my favourite parallel execution plan on.
September 7, 2011 at 10:37 am
elogen (9/7/2011)
September 7, 2011 at 6:15 am
Hi,
You can avoid concurrency issues by using UPDLOCK and READPAST inside a transaction, and not using a cursor. The following code illustrates the technique:
USE tempdb
GO
CREATE TABLE dbo.QueueStatus
(
status_idINTEGER NOT NULL
CONSTRAINT...
September 7, 2011 at 3:53 am
rob mcnicol (9/7/2011)
when i use a join hint to specify the hash join, the query runs in 1 second.
Depends how you are specifying the hash join: OPTION (HASH JOIN) or...
September 7, 2011 at 1:48 am
Viewing 15 posts - 1,711 through 1,725 (of 8,416 total)