Viewing 15 posts - 11,641 through 11,655 (of 49,552 total)
TempDB.
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
September 19, 2013 at 11:21 am
davehegwood (9/19/2013)
To get the Tables Altered, you can useSELECT name, create_date, modify_date
FROM sys.objects
WHERE modify_date >= GETDATE()-n
Won't work on SQL 2000.
3 year old...
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
September 19, 2013 at 10:35 am
Partitioning isn't about performance anyway. It's about maintainability, fast loads, etc. You may need to change nonclustered indexes, or you may not. Can't tell without a lot more information.
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
September 19, 2013 at 6:20 am
Ah, no.
That said, sounds like you might want to re-do the partitioning on the table and instead partition on date rather than supplier. Then you have your fast load and...
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
September 19, 2013 at 4:56 am
What do you mean by 'sub partitions'? What are you looking to do?
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
September 19, 2013 at 4:25 am
Please note: 3 year old thread.
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
September 19, 2013 at 4:23 am
IO stats from STATISTICS IO are correct, they're the actual number of reads done.
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
September 19, 2013 at 4:22 am
Please note: 3 year old thread.
The error in the OP is not one you get when the log chain has been broken. That case gets you an error either like...
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
September 19, 2013 at 4:21 am
It means they are ad-hoc queries, nothing more.
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
September 19, 2013 at 4:19 am
Stefan Krzywicki (9/18/2013)
GilaMonster (9/18/2013)
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you mean the SELECT * INTO, unfortunately that's allowed. I've...
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
September 18, 2013 at 6:31 pm
L' Eomot Inversé (9/18/2013)
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
September 18, 2013 at 6:29 pm
L' Eomot Inversé (9/18/2013)
Don't need to is surely an understatement: you are not allowed to, I think?
If you mean the SELECT * INTO, unfortunately that's allowed. I've cleaned so many...
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
September 18, 2013 at 6:06 pm
Yes, a new thread would have been better...
The installation DVDs contain both x86 and x64 versions. If you downloaded an iso from MSDN, then depending on version, you may 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
September 18, 2013 at 4:31 pm
defyant_2004 (9/18/2013)
What would be some of the first issues I should address as I take over the responsibility of these databases?
Backups. Integrity Checks. Backups. Restores. Backups. Backups. Backups.
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
September 18, 2013 at 2:31 pm
SELECT <column list> FROM <damaged table> WHERE <clustered index key column> BETWEEN <some lower boundary that works> AND <some upper boundary that works>
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
September 18, 2013 at 2:25 pm
Viewing 15 posts - 11,641 through 11,655 (of 49,552 total)