Viewing 15 posts - 1,846 through 1,860 (of 6,036 total)
Kristen-173977 (11/2/2015)
Sergiy (11/1/2015)
As for database backups - I don't think there is a place for it in the current world.How do you handle a fraud investigation with no backups?
Logs, I'd...
_____________
Code for TallyGenerator
November 2, 2015 at 1:35 pm
Gail, I'm talking from experience.
I went through a "whole site" disaster.
Not quite a "fire in the room", but with the same consequences - everything is down and non-recoverable.
Yes, backups were...
_____________
Code for TallyGenerator
November 1, 2015 at 9:51 pm
GilaMonster (11/1/2015)
Why?Why keep data that we don't need to keep in detail and only need to keep in an aggregated form?
What kind of data we don't need?
Health history?
Credit history?
Criminal records?
The...
_____________
Code for TallyGenerator
November 1, 2015 at 8:14 pm
I mean - you do not need to delete those 20 million rows.
You may leave them where they are - their presence is not gonna affect queries against the sets...
_____________
Code for TallyGenerator
November 1, 2015 at 7:49 pm
GilaMonster (11/1/2015)
Also fast data loads, fast deletes, aka the sliding window.
The thing is - correct cluster index eliminates the necessity for a sliding window altogether.
_____________
Code for TallyGenerator
November 1, 2015 at 6:20 pm
Not to mention another "little" problem with partitioning:
Msg 7736, Level 16, State 1, Line 2
Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition of...
_____________
Code for TallyGenerator
November 1, 2015 at 2:18 pm
Jeff Moden (11/1/2015)[hrAh... how soon I forgot the problem with the double-quotes in the CSV file. If you loaded the data without modifying the delimiter in the BULK INSERT...
_____________
Code for TallyGenerator
November 1, 2015 at 1:36 pm
Jeff Moden (10/31/2015)
Not to mention, that's a really nice machine you've got there, Sergiy.
It's not a nice machine, it's an empty recordset returned.
Which is actually a very good test...
_____________
Code for TallyGenerator
November 1, 2015 at 5:42 am
OK, populated 2 tables from the scripts.
Here is the outcome:
set statistics time on
Select REF_AGE , COUNT(*)
from Partitiontest123.dbo.partitionedtbl
where ref_age between '27' and '30'
group by REF_AGE
set statistics time off
SQL...
_____________
Code for TallyGenerator
October 31, 2015 at 7:56 pm
ScottPletcher (10/28/2015)
_____________
Code for TallyGenerator
October 30, 2015 at 9:14 pm
Real life example?
Tax invoice.
Tax amount usually is calculated as percentage value, and usually needs to be rounded.
Those rounded values are what is paid and shown in reports.
When you aggregate...
_____________
Code for TallyGenerator
October 29, 2015 at 11:16 pm
happygeek (10/4/2015)
why store rounded values; you have the value, use whatever report generator you use to round or format the output.
It depends.
You may need to consider those rounded values...
_____________
Code for TallyGenerator
October 29, 2015 at 8:57 pm
I would strongly recommend not to run sending emails or any other kind of external operations from a trigger.
And glitch in the functionality beyond SQL Server control may cause total...
_____________
Code for TallyGenerator
October 27, 2015 at 11:01 pm
Jayanth_Kurup (10/23/2015)
Mainly trying to highlight the difference between an allocation scan and traversing the b tree.
Once again:
Can you show how a query for an age group for ages between @m...
_____________
Code for TallyGenerator
October 23, 2015 at 4:07 am
Jayanth_Kurup (10/23/2015)
More than happy to demo the concept if it helps , Also the sample script and data are shared on google drive have you tried it?
I built a whole...
_____________
Code for TallyGenerator
October 23, 2015 at 3:58 am
Viewing 15 posts - 1,846 through 1,860 (of 6,036 total)