I'll take a wild punt on $Params = "/FILE " => $Params = " /FILE " perhaps?

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at one point so I did my...

I blame Schrodinger.

patrickmcginnis59 10839 (8/2/2016)

---

Doctor Who 2 (7/24/2016)

---

I finally got my SQL Server database uploaded into Azure SQL! I posted a blog post about it. Rather than repeat what I did I'll...

Going to try and test it, but postulating that column stats are a property of the columns themselves rather than the table?

Edit: nope, there's no further Statistics property under columns....

I'm seeing similar behaviour scripting through SSMS. There the stats option has 3 values:

Do not script statistics - no stats

Script Statistics - stats for indexes only

Script statistics and histograms -...

I've used ceiling (and more frequently, floor) in some remove-time-part-from-datetime operations, pre SQL 2008.

This any good to you? Looks like scripting statistics is a valid option.

https://www.simple-talk.com/sql/database-administration/automated-script-generation-with-powershell-and-smo/

Jeff Moden (9/16/2016)

---

Alan.B (9/15/2016)

---

Gazareth (9/15/2016)

---

Also SUM with OVER()

DECLARE @table TABLE (stateName varchar(20), Count1 int, TotalChargeOffAmount int);

INSERT @table

VALUES

('Alabama',5,1000),

('Arizona',2,4000),

('Arkansas',3,5000);

SELECT

stateName,

Count1,

TotalChargeOffAmount,

100.0*Count1...

Also SUM with OVER()

DECLARE @table TABLE (stateName varchar(20), Count1 int, TotalChargeOffAmount int);

INSERT @table

VALUES

('Alabama',5,1000),

('Arizona',2,4000),

('Arkansas',3,5000);

SELECT

stateName,

Count1,

TotalChargeOffAmount,

100.0*Count1 / SUM(t1.[Count1]) OVER ()...

Nice idea, but Columnstore indexes are an Enterprise-only feature. A periodically refreshed persisted table with appropriate B-tree indexes may still be a valid approach though.

You can also use the Get-Content cmdlet in powershell to read out just a set number of lines from the start or end rather than the whole file.

What have I started here?! Haha

drew.allen (9/9/2016)

---

Jacob Wilkins (9/9/2016)

---

The Dixie Flatline (9/9/2016)

---

Okay.... although I'm not going back into the divide by zero thread.

Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF will...

Definitely do this first though.