Viewing 15 posts - 11,971 through 11,985 (of 49,562 total)
Might be able to hack something out with enough work and fiddling that might allow for repair to throw data away, but restore from backup should be one of the...
August 23, 2013 at 4:01 pm
Restore from backup.
Deferred transactions - transactions that can't be rolled forward/back because of an offline file/filegroup. I would guess you have one or more files in the offline state (or...
August 23, 2013 at 3:54 pm
pdanes (8/23/2013)
How are they getting that fragmentation?
I suppose during the import process. This table is not copied - it's part of a design change, and is newly generated from several...
August 23, 2013 at 3:30 pm
Heaps you can't defrag (well, there's alter table rebuild, but...), and fragmentation means something very different on a heap vs a table. The other one, it's honestly far too small...
August 23, 2013 at 3:27 pm
The rough guideline is somewhere in the vicinity of 1000 pages (8MB data). It's not a hard number (defrag at 1001, ignore at 999), just a rough figure about where...
August 23, 2013 at 2:52 pm
Heap or index?
How are they getting that fragmentation?
Any shrinks running?
August 23, 2013 at 2:44 pm
Check with your SAN admin as to whether the SAN has any defrag software. If it does, use that if you have to. Some SANs intentionally fragment files for performance...
August 23, 2013 at 11:38 am
AndrewSQLDBA (8/23/2013)
Why would I not want too? They are taking up memory and cpu
An idle thread consumes no CPU. It'll have a 2MB thread stack (or 4MB, can't recall), no...
August 23, 2013 at 11:26 am
No, it's not a bug. The client app ran out of memory probably due to the 'several selects for each insert'.
August 23, 2013 at 10:54 am
Once more with feeling...
Full backups DO NOT break the log chain.
Therefore, to re-initialise the secondary after the drill, take a full backup of the primary, copy it, restore it, restart...
August 23, 2013 at 10:47 am
Ray K (8/23/2013)
I default them both to null in the stored proc. In my code, I set them to 1/1/1900 and getdate(), respectively.
And that's your problem right there.
http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/
If you're...
August 23, 2013 at 10:20 am
AndrewSQLDBA (8/23/2013)
Hey GilaThe application is not closing them. I need to kill them if they are a couple days old.
Why? What problem are they causing? What effect will it have...
August 23, 2013 at 9:54 am
Eugene Elutin (8/23/2013)
SET ANSI_NULLS OFF;
IF 'x' <> NULL PRINT 'Well, it is known, sometimes... '
In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that...
August 23, 2013 at 9:44 am
Parameter sniffing, or possibly lack thereof would be my first guess, but really need to see the procedure to say for sure.
August 23, 2013 at 9:39 am
Viewing 15 posts - 11,971 through 11,985 (of 49,562 total)