Haven't seen it yet, but what @@version are you on ?

SQL2008 ? sp?

SQL2008R2 CU?

don't use xp_cmdshell from within a sqlagent job !

SQLagent jobs can have job steps that execute dos commands.

Create a doscmd jobstep and provide the needed windows auth for the sqlagent...

put the previous sugestion in a single transaction, so others cannot insert invalid data.

SQLkiwi (12/21/2010)

---

There's not much new at all in SP4, compared to the previously released cumulative updates for SP3.

Are people excited about this primarily because Service Packs are perceived as being...

Apparently I'm hitting a "Don't" advise of MS: http://support.microsoft.com/kb/961638

after applying SP4 :crying:

Thank you for correcting that !

There is indeed nice info at e.g. http://www.ocztechnologyforum.com/forum/content.php?306-SSD-ABC-Guide

( it also points to Alignment in its do's and don't section )

just my 2ct.

With regards to a log shipped db, connections will have to be modified at switch time !

With regards to a mirrored db solution, you prepare all connections...

I'm not a disk numbers specialist, but I just got this poster today and wanted to pass it on:

"Free Poster – SQL Server Perfmon Counters of Interest"

http://www.mssqltips.com/whitepaper.asp?id=17

Ewan Hampson (12/20/2010)

---

What's with the change since the CTP?

CTP: "Supported Operating Systems:Windows 7;Windows Server 2003;Windows Server 2008;Windows Vista"

RTM: "Supported Operating Systems:Windows 7;Windows Server 2008;Windows Server 2008 R2;Windows Vista"

The...

Apparently, on a side by side client install it breaks SQL2008 SSMS project stuff.

- New project on a new folder generates "creating project failed"

- opening an existing sql2008 project generates...

There are some articles at SSC and it the SSC fora.

e.g. http://www.sqlservercentral.com/articles/SQL+Server+2008/67066/

Search at SSC on "upgrade SQL2008" or "migrate SQL2008"

Here's a resource you should certainly have a look at because...

Since you cannot afford gaps, you cannot rely on transactions that may still be rolled back.

( for reasons over which you have no control ) there can be multiple ways,...

So you cannot afford gaps in this sequence number.

IMO that calls for a processing model that only operates on committed rows or sets.

Meaning, log your action and process the sequence...

I stick with my first advise on this one.

Keep it simple and code regular joins.

The column level nested selects will only give you benefits if cardinality meets a treshhold.

I certainly...

How about me just routing you to Paul Randals series of sqlserver myths:

This one on checkpoints:http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281530%29-checkpoint-only-writes-pages-from-committed-transactions.aspx