Viewing 15 posts - 11,971 through 11,985 (of 49,552 total)
Red Gate's SQLCompare and SQLDataCompare?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 4:14 pm
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 2:52 pm
Heap or index?
How are they getting that fragmentation?
Any shrinks running?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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'.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2013 at 9:39 am
Viewing 15 posts - 11,971 through 11,985 (of 49,552 total)