Sean is assuming that these constraints are defined as such. If they are not, it just takes a lot of testing... One of my favorite things to do with an...

Come on... That's like saying a column can accept...

Looks like if the parameter is omitted the sp still runs and assumes an empty table. I would have the set pass a row with some indicators to detect...

I have not worked with table valued parameters, but it seems easy enough to test by passing a null to the parameter or an empty set and see what happens.

Also note that a unique column can contain 1 null:

USE test;

GO

CREATE TABLE pktest (id int primary key clustered, somestuff varchar(250) unique);

GO

INSERT INTO pktest (id, somestuff)

VALUES(NULL, '1 null is not okay...

Was this backup the first one created by your maintenance plan? It is possible that compression is default on your server and this was created as a compressed backup whereas...

Yes, by altering the partition function and splitting the range. http://msdn.microsoft.com/en-us/library/ms186307.aspx

DiverKas (5/23/2012)

---

Besides the WTF'ery about the ORDER BY... the lack of indices is more troublesome.

A clustered index should really be considered mandatory, and then supporting indexes as necessary by the...

drew.georgopulos (5/23/2012)

---

not so good...there are business analysts interposed between the report requestor and developers, so developers rarely speak to the end user.

My feeling is that GSquared's suggestion hits the nail...

I believe that partition elimination does not guarantee any performance enhancement. Sure, it "might," but it might not. What if the other partitions are empty? What if the amount...

Hmm... My guess, at this point, is that it has something to do with your view definition. Can you post DDL for the view and any tables referenced within...

In this case, you would have multiple files. Personally, I would then schedule another job or within the same job write code to delete old ones .

In my previous company, the DBA's were also the SQL developers...

Do something like this:

DECLARE @diskPath VARCHAR(150)

SET @diskPath = 'C:\TransactionLog\Production_Log'+ CAST(YEAR(GETDATE()) AS CHAR(4)) + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + CAST(DAY(GETDATE()) AS VARCHAR(2)) + '.trn'

--PRINT @diskPath

BACKUP LOG production

TO DISK = @diskPath

WITH RETAINDAYS=1,

DESCRIPTION =...

andersg98 (5/23/2012)

---

The OP asked if his plan to partition the table could improve performance and I stated a fact about what he was proposing. Was I wrong?

...