645 reputation
715
bio website
location Europe & Asia
age
visits member for 3 years, 2 months
seen Aug 14 at 9:07

Aug
26
awarded  Notable Question
Aug
22
awarded  Popular Question
Jul
28
comment Page compression not working?
Based on your information I had a look and things look like this: Partition 45 Size with current compression settings 54642000 KB Size with requested compression settings 29561320 KB page_count 6792353 compressed_page_count 6354979 So I would expect SQL Server 2012 to compress these pages, but for some reasons it doesn't do it. This behaviour will cost me around 10-15 TB disk space wasted (since the db runs in an Avalability Group with 3 nodes). :(
Jul
25
asked Page compression not working?
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jul
1
awarded  Yearling
Jun
25
answered Cube processing either takes too long or fails
Jun
23
asked Best Practice in storage allocation for compressed and partitioned tables
Jun
19
awarded  Popular Question
Jun
3
awarded  Popular Question
May
28
comment How to get usage based optimization working on SSAS?
I created the table under dbo, however the SSAS is still logging to the table under service account schema, and the wizard is telling me the table in the dbo schema is obviously empty.
May
27
asked How to get usage based optimization working on SSAS?
May
8
awarded  Popular Question
Apr
4
awarded  Notable Question
Feb
25
comment Partitioning a table state
Since the value set of the state column is defined ahead I was hoping to tell it "AL","AK","AZ","OTHER" but fear was that it is really not possible with SQL Server. The idea is to provide different data buckets so I can speed up my imports, but then likely it is better to make different tables i guess. Thanks!
Feb
25
accepted What is the fastest way to insert large numbers of rows?
Feb
25
asked Partitioning a table state
Feb
19
comment What is the fastest way to insert large numbers of rows?
@Kin had a look at the guide but it seems outdated, "The SQL Server destination is the fastest way to bulk load data from an Integration Services data flow to SQL Server. This destination supports all the bulk load options of SQL Server – except ROWS_PER_BATCH." and in SSIS 2012 they recommend the OLE DB destination for better performance.
Feb
19
comment What is the fastest way to insert large numbers of rows?
@Aaron yes, per month one filegroup, 12 san lun's attached so all jan go on one lun etc. Not sure how many disks per lun but should be plenty.