It's a nonclustered index. Haven't tried a rebuild yet (I'm restoring a copy on my development instance to test).

Would a rebuild help? The page in question is no longer allocated.

It's always the same error, reporting the same page. The job is failing on the same index, trying to do a reorg.

Sorry I should have said that the instance is SQL Server 2012 SP2 CU2.

The link you send is the issue but only applies to SQL Server 2008 (R2).

Yep:-

Msg 2760, Level 16, State 1, Line 1

The specified...

Idera have a tool called SQL Virtual Database, I think that should give you what you need.

It's not free but you can start a free trial https://www.idera.com/productssolutions/sqlserver/sqlvirtualdatabase

(I don't work for...

Have a look in the detailed description section here:-

https://technet.microsoft.com/en-us/library/hh849793.aspx

Copy-item allows you to rename an item by using the destination parameter

So I've used the following powershell script to copy the latest backup file from one folder to another:-

$H = (dir \\<SOURCE FILEPATH> *bak | sort -prop LastWriteTime | select...

What version of SQL are you running? I've seen a KB article which describes what you're seeing http://support.microsoft.com/en-us/kb/2545989

I don't think OR is supported in filtered indexes WHERE clause. Have a look at Aaron Bertrand's answer here:-

http://stackoverflow.com/questions/20912892/sql-server-2012-filtered-index-is-the-where-clause-too-complex

As far as I'm aware the extensions of the files should not matter. Mdf, ndf and ldf are just the standard naming conventions that Microsoft recommend. https://technet.microsoft.com/en-us/library/aa174545%28v=sql.80%29.aspx

The only way to...

Sorry for the late response, it's been St Paddy's Day weekend over here (not to mention the rugby)!

The reason that the script returns null for the boundary_id is that value...

Here's the script I use to analyse partitions, hope it helps

SELECT

t.name AS TableName, i.name AS IndexName, p.partition_number, p.partition_id,

i.data_space_id, f.function_id, f.type_desc, fg.name AS [filegroup], r.boundary_id, r.value AS BoundaryValue, p.rows,

r.*

FROM...

What about this:-

CREATE TABLE dbo.UserNames

(UserID INT IDENTITY(1,1) PRIMARY KEY,

UserName SYSNAME);

INSERT INTO dbo.UserNames

SELECT 'User1'

UNION

SELECT 'User2'

--etc

SELECT 'CREATE LOGIN ' + UserName + ' FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[English]'

FROM dbo.UserNames

It's a bit...

Ville-Pekka Vahteala (1/27/2015)

---

DBA From The Cold (1/27/2015)

---

It's all about how big the columns will be, from MSDN:-

https://msdn.microsoft.com/en-ie/library/ms186939.aspx

The storage size, in bytes, is two times the actual length of data...

EDITED:- As was originally incorrect.

It's all about how big the columns will be, from MSDN:-

https://msdn.microsoft.com/en-ie/library/ms186939.aspx

The storage size, in bytes, is two times the actual length of data entered +...