Viewing 15 posts - 1,066 through 1,080 (of 5,685 total)
As far as I know (and quickly poked around to see if I was horribly wrong) there's no hard-coded limit. There's obviously a point where the memory ends up...
October 9, 2012 at 5:59 pm
Hey Alan,
I'm not entirely sure what you're trying to do here. I keep thinking I get the gist then realize I don't.
If you take a look at the first...
October 9, 2012 at 5:40 pm
YarHad (10/9/2012)
GilaMonster (10/9/2012)
October 9, 2012 at 5:36 pm
Well said. To address a few of your points:
ian_bauer (10/9/2012)
October 9, 2012 at 5:30 pm
You need more space for your logs, you probably added the index to a huge table. If you're not in simple recovery mode, you need to do a log...
October 9, 2012 at 4:41 pm
ian_bauer (10/9/2012)
thanks for pointing me in the right direction.
still would appreciate help, its a tough...
October 9, 2012 at 4:39 pm
As Rory mentioned above, this seems like homework. You want to inspect SELECT DISTINCT, GROUP BY, COUNT(*) and HAVING clauses for select statements. If you tell us what...
October 9, 2012 at 4:37 pm
n00bDBA (10/9/2012)
October 9, 2012 at 4:34 pm
jeremyisaacs (10/9/2012)
October 9, 2012 at 4:04 pm
jeremyisaacs (10/9/2012)
A quick note. My connection strings are dynamic so I cannot use shared datasources. They must be embedded.
I don't have a workaround to the specific...
October 9, 2012 at 3:08 pm
mmontgo2 (10/9/2012)
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...
October 9, 2012 at 2:40 pm
n00bDBA (10/9/2012)
So apart from creating non-clusterd unique indexes on all there primary keys.. which from what i gather is pretty wierd...
No, clustering all your PKs is actually what's usually...
October 9, 2012 at 2:14 pm
wnarretto (10/8/2012)
1. when the ssis package has completed, does it cut off the connection to the spocs that were called for the other iterations?
Unless you're preserving your connection in...
October 9, 2012 at 2:05 pm
Yes, it's the same. It's also dangerous if you're unfamiliar with the pitfalls of uncommitted data access. Your best bet is RCSI instead. The links that Sean...
October 9, 2012 at 2:03 pm
More information as to what you're trying to do, please. That's rather vague.
October 9, 2012 at 2:00 pm
Viewing 15 posts - 1,066 through 1,080 (of 5,685 total)