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...
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...
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...
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...
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.
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...
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...
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...
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...
October 31, 2015 at 7:56 pm
ScottPletcher (10/28/2015)
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...
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...
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...
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...
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...
October 23, 2015 at 3:58 am
Viewing 15 posts - 1,846 through 1,860 (of 6,036 total)