Viewing 15 posts - 556 through 570 (of 1,034 total)
calvo (6/10/2011)
mtassin, I believe Bob is quoting BOL in that paragraph.
Yah, it just didn't seem as obvious a quote as it should have I guess... and I didn't read that...
June 10, 2011 at 7:58 am
GilaMonster (6/10/2011)
calvo (6/10/2011)
I'd like to know if anyone here utilizes this feature of splitting physical CPUs for the purpose of creating soft-NUMA nodes for multiple lazy writer threads.
You get a...
June 10, 2011 at 7:13 am
Finally came up with a fix...
wrapped the whole thing in
IIF(ISERROR(originalcalculation),measurevalue,originalcalculation)
It works... not as nicely as I believe it should... but it works.
June 7, 2011 at 2:34 pm
forsqlserver (6/7/2011)
I am getting output:7B6A0544-E2A0-4984-921E-BE50EED041C7
8BF68496-1DC4-4C47-850E-7000FAA8FF23
D0662128-5ED0-4002-ADED-149176F78CF0
C031E61D-F269-4396-B435-B4C0A27A0E2B
0062D0A0-9D78-49AB-92FB-74C6E3897E4A
3B140F69-EC2C-4408-B964-05191269CC7F
...
Yup....
and I get
57D19CCA-E5EC-4113-9C21-B7D557153D8A
3BF757D0-9CE3-47FA-8B24-7819CAEE4772
D6DD8650-355C-47DD-B0EC-B73D71F2CCD4
F1C256C0-1315-4618-BFFB-D878F71D4B08
DDEA508A-79FA-4E69-ABDD-39C4AE6C65C6
B64E95E7-B1CE-465D-91D5-534D1139C1BE
1F517EBD-3507-4789-BAC0-7CD0F907D424
FEC71A44-7F5A-4563-823B-110E7736F1DE
D285394C-3E8A-4FEE-B6D4-E73885808AD6
8A9F1516-32BC-465C-B586-CD8A52ED0E02
13440CC2-9B39-46B4-916E-C4FEC34FD944
ED4ABEF3-5C79-45A2-AF74-B1DFF4961047
19BB1EF9-6D19-4544-AAA1-2D7B7F507E30
B214E5A6-1B71-4C25-8AFE-DC39EB81F1D8
B8DE2D3C-3A65-4BE1-A51A-4E2D1120E8D3
B6CB1FE7-0EF3-44CA-A4CD-0DB491544E32
1362F656-BE8D-4935-9CED-2EBD86158B15
5AC7C5AE-E84C-4AC4-90A7-6C74749F011B
EACB4288-8285-4E50-8802-BAF4D5710AD7
0A1BB3F8-4AD2-4F75-A62A-11789C2F9DC0
65B3D555-7820-4AF2-BE5A-5643FDA6147A
199A7B68-71F3-481F-B61E-E1E1FCE52CB1
9BDDAFA1-73E8-47F1-976F-79C1F690C403
F88D4438-DD13-4E8D-9166-6B92AF67D2DE
D6A4505E-A5F7-4700-B59B-A8575BFA76C9
9815A0DE-3A30-4ABB-A8A4-116E66551C3C
DC72501F-2462-4F91-B1B1-1B2576CBEECE
17860D7F-986C-4D5C-9FAA-F53CECF2E5EC
212345A2-2C8C-4257-A7C1-241A37B5F4A8
8104DB58-C04A-4B66-AE42-03C20A423ABE
FF2A93D8-E7E5-4C30-AB5D-A858AEAE29C7
C81C60BE-9625-4CBE-AB30-936A9B98E633
A4171D1F-FD3B-4E20-991A-9B572BBF1A31
2976821B-36D3-4A2C-A3E3-8D8BF78BE6E0
E63D93D0-F18C-4FBF-B5DB-5D141E9A61E3
C7F0B6C6-F71B-4B70-A0E5-29FE405BC684
3C9A6FB3-C6E1-43CA-8F08-32CAD9952B43
67D5FEC0-37A8-4F97-AE1A-C4A414714E99
850814F5-A85D-4EA0-B5FB-793C8A356C6E
7EBBD950-9B79-4184-B16F-8C08BF02CF6C
B7219EED-0ABA-4304-9CA9-CAAD36814FA4
4C2A3947-D101-4889-AB63-840218575446
B7A85EC7-1B2A-4E3C-BD20-682405E38369
EE277A7D-B821-4D82-80AA-172161348D92
58B3BA94-28A1-4FC6-8E91-238A5A65394E
621C2183-8C81-4B29-8EF5-B56AF14B6551
67BA4D34-F111-4605-BD62-2BFC4E6955C9
75FD300A-863D-4878-BDBC-8F27DBAB7032
CF9B2B6D-39C6-40AD-84D0-C00682A01125
45AE83DC-2C34-4BE1-B4E4-C1DE44ABEDA7
It was obvious the question was written incorrectly and needed to have count(*) instead of * or one of the answers should...
June 7, 2011 at 7:41 am
Mhlewis (5/27/2011)
May 31, 2011 at 8:51 am
Richard Warr (5/11/2011)
May 11, 2011 at 8:49 am
Chris Houghton (5/6/2011)
Good question. I rushed it and misread "data" compression as "backup compression" so I selected that it would succeed. Haste makes waste.
Same here... ah well
May 6, 2011 at 7:28 am
got this one wrong.
Reading the Microsoft Article it seems you could actually configure mirroring on the distribution server, but that it wouldn't work if you failed over.
So technically I think...
May 5, 2011 at 7:16 am
WayneS (5/3/2011)
Actually, I had expected the Perm table to beat the memory one.It did stabilize in relative terms to the memory one, but significantly higher.
And confounded all of us....
May 3, 2011 at 2:42 pm
Nadrek (5/3/2011)
Craig Farrell (5/3/2011)
B'narg! Whaaaa? After a point I'd have expected the Perm table to stabilize more to the memory build.
Wow.
Try one of the two double-CTE versions I...
May 3, 2011 at 12:50 pm
Craig Farrell (5/3/2011)
WayneS (5/3/2011)
Here's the results that I have. The "DemilitedSplit8Kpt" is the new DelimitedSplit8K function, with a permanent tally table.10 to 20 Characters per Element:
B'narg! Whaaaa? After...
May 3, 2011 at 12:25 pm
WayneS (5/3/2011)
ChrisM@home (5/3/2011)
Jeff, please please please write a book, without changing your style. Give us all an opportunity to repay you for what you've done for us.
+10!
Yes, please do write...
May 3, 2011 at 9:52 am
Since we're sharing our Date Dimensions...
I did my latest incarnation of it mostly using derived columns. So far performance seems to have improved over when I was using...
May 3, 2011 at 8:07 am
WayneS (5/2/2011)
Mark, the only possible explanation that I can give is the elimination of the disk IO. When I ran this test, I fully expected the physical tally table to...
May 2, 2011 at 10:07 am
WayneS (5/2/2011)
May 2, 2011 at 9:55 am
Viewing 15 posts - 556 through 570 (of 1,034 total)