There are lots of free CMS you can use like DotNetNuke, WordPress etc.

If you want to build your own you might want to look at a WYSIWYG editor like CKEditor,...

I've never cared much for the new syntax, but you can also use:

SELECT ID,

NAME,

pvt.Home,

pvt.Office

FROM PivotTable

PIVOT(

MAX(PhoneNumber)

FOR [TYPE] IN([Home],[Office])

) AS pvt

How about this:

SELECT ID,

NAME,

MAX(CASE WHEN type='Home' THEN PhoneNumber ELSE NULL END) AS [home],

MAX(CASE WHEN type='Office' THEN PhoneNumber ELSE NULL END) AS [Office]

FROM PivotTable

GROUP BY ID,Name

Hope this helps,

David

PS

If you have an existing system you are using to track DDL events, it should be easy to import the history into this tool providing you have the original XML...

Dev (11/18/2011)

---

Actually "It depends"

Also, some tables are likely to have high volumes of inserts/updates which could be possible candidates...

It's worth noting that even in OLTP systems, the read to write ratio is normally biased towards reads. Also, some tables are likely to have high volumes of inserts/updates...

Evil Kraig F (11/17/2011)

---

MyDoggieJessie (11/17/2011)

---

I've always been curious about which value should be set as a fillfactor and why as well...clearly there's different reasons for it when it's a clustered...

As it's an identity column, the values inserted are always increasing in value so they are inserted at the end of the index. Lowering the fill factor won't improve...

Size will depend very much on the individual environment, but you should try to avoid the need for auto-grow.

Tempdb can be critical to your database server performance and you...

Does the stored procedure have any parameters? Check the compile value for the parameters in the execution plan on dev/production. It's possible that it's a parameter sniffing issue....

Jayanth_Kurup (6/15/2011)

---

I cant think of any severe issues with filling drives to capacity esp if they are not going to grow and no index rebuild etc are gonna happen, and...

The host file is used to provide host name resolution - to convert a name into an IP address. This is a simple text file that you can edit...

I've found that adding an entry in the host file (c:\windows\system32\drivers\etc) of your client machine for the remote server can help with this issue. You would also need to...

The CLR code we are using is very simple:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

<Serializable()> _

<Microsoft.SqlServer.Server.SqlUserDefinedAggregate(Format.Native, _

IsInvariantToDuplicates:=True, IsInvariantToNulls:=True, IsInvariantToOrder:=True)> _

Public Structure BitMaskOR

Dim val As SqlInt32

...

The server is configured to use 56GB (57344MB MAX server memory) of it's 64GB. Min Server Memory is 0. The service account has the lock pages in memory...