Vedran Kesegic (3/14/2012)

---

"The last update should not succeed" - why?

In your example there is no update that would not succeed.

And there is no command that inserts "ABCD".

First INSERT sets "A",...

Snapshots are a really useful feature, but there are some things you should be aware of:

They reduce the write I/O performance of your database as changed database pages get copied...

Our production SQL Server 2005 instance has 256GB memory - We upgraded our database servers a while ago and went from 64GB to 256GB.

There isn't really anything different to note...

This is what the schema changes report is running on my system, which you might be able to use as a starting point:

exec sp_executesql @stmt=N'begin try

declare @enable int

select top 1...

The information is available in the default trace and you can access it via the "Schema Changes History" SSMS report. The information captured is limited and it the trace...

This is a simple but incorrect solution:

WHEN REPLACE(REPLACE(REPLACE(SRC.Definition,' ',''),CHAR(13),''),CHAR(10),'')

<> REPLACE(REPLACE(REPLACE(Dest.Definition,' ',''),CHAR(13),''),CHAR(10),'') THEN 'Definition Mismatch'

It will remove spaces and new line characters - you might also need to...

This is a duplicate of this post:

http://www.sqlservercentral.com/Forums/Topic1246826-1550-1.aspx

Shrink file does not cause any data loss. If you specify 1MB, it will shrink only to the smallest possible size. As...

The shrink file will only be able to remove the unallocated space from your data files - it won't help much here. I'd suggest running an index rebuild on...

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...