I agree, it ought to work unless they are repositioning SQL Server away from Enterprise use and moving more towards Home use 😀

I cannot think of a reason why that would be a problem for the database engines but you may run into issues with some of the shared services depending on...

Phil Parkin (4/9/2013)

---

opc.three (4/8/2013)

---

How are your C# or VB.net skills? I am thinking pre-processing the file might be one way. You could use a Script Task to read the file...

I am happily running SQL 2012 Dev Edition on Windows 8 Pro and oddly enough Windows 8 Enterprise is not listed as a supported OS here.

I am thinking initially it could be blocking but it truly could be any number of things. When they run it on the laptop I assume it's just the one...

Tutorial:...

USE [master]

GO

EXEC sys.sp_addlinkedserver

@server = N'Production',

@srvproduct = N'',

@provider = N'SQLNCLI',

@datasrc = N'127.0.0.1,1713'; -- fix...

How are your C# or VB.net skills? I am thinking pre-processing the file might be one way. You could use a Script Task to read the file in reverse order...

Sergiy (4/8/2013)

---

opc.three (4/8/2013)

---

Yep, I remember that thread well...it's not the leaf level of the index that becomes fragmented, it's the mid-level pages because the clustering key is stored there. You...

Sergiy (4/8/2013)

---

I reread your comment 5 times more - it does not say...

peacesells (4/8/2013)

---

WHERE SS.[Key]='A'

AND SO.[type]='X_P'

AND vu.[Status]=1

AND 1= CASE WHEN @CreateDateDatTime > vu.LastRunDate

...

Duplicate post. Direct replies here: http://www.sqlservercentral.com/Forums/Topic1440114-391-1.aspx

Pretty much. Non-filtered indexes will have an entry for every row in the table, sorted per the...

Yep, I remember that thread well...it's not the leaf level of the index that becomes fragmented, it's the mid-level pages because the clustering key is stored there. You were wrong...

No, you do not need the original Solution or Project file. You can export the Package using SSMS or dtutil.exe and modify it on your local machine. You can also...