Viewing 15 posts - 11,641 through 11,655 (of 49,562 total)
TempDB.
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...
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.
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...
September 19, 2013 at 4:56 am
What do you mean by 'sub partitions'? What are you looking to do?
September 19, 2013 at 4:25 am
Please note: 3 year old thread.
September 19, 2013 at 4:23 am
IO stats from STATISTICS IO are correct, they're the actual number of reads done.
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...
September 19, 2013 at 4:21 am
It means they are ad-hoc queries, nothing more.
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...
September 18, 2013 at 6:31 pm
L' Eomot Inversé (9/18/2013)
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...
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...
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.
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>
September 18, 2013 at 2:25 pm
Viewing 15 posts - 11,641 through 11,655 (of 49,562 total)