Duplicated post.

See : http://www.sqlservercentral.com/Forums/Topic1234678-391-1.aspx

Check this :

http://msdn.microsoft.com/en-us/library/ms191250.aspx

A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant,...

1. What kind of backup do you have today ?

Do you use :

- differential backups

- compressed backup (if your SQL Server is Enterprise Edition on sql 2008 or Standard...

Sometimes page split can lead to duplicate rows.

Have a look at this article :

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx

I'm not sure this is possible.

Why don't you just apply an xsl transformation ?

Here is an article to do it inside SQL Server :

http://www.sqlservercentral.com/articles/MDS/75932/

Have a look at this :

http://epmframework.codeplex.com/

SCOM

Here it is :

param ( [string]$ComputerName = "." )

Get-WmiObject -computername "$ComputerName" Win32_LogicalDisk -filter "DriveType=3" | foreach {

add-member -in $_ -membertype noteproperty UsageDT $((Get-Date).ToString("yyyy-MM-dd"))

add-member -in $_ -membertype noteproperty...

Sure you can, but you have a little work to do.

This query lists users per database :

sp_MSForeachdb '

USE ?

select

db_name() as dbname

, sp.name as login

, dp.name as

from sys.database_principals...

GilaMonster (1/11/2012)

---

In that case, how would you...

none of those 🙂

I would use the 3rd one (EXISTS) at the beginning and get the ID with SCOPE_IDENTITY at the end !

Dev (1/11/2012)

---

I don’t prefer Windows Authentication based database servers for Web Application. It’s better if user login with Application (Web) Login Name and Application Server translate its credentials...

Storage Top 10 Best Practices :

http://technet.microsoft.com/en-us/library/cc966534.aspx

Maybe there are no sensitive data in tempdb but you don't want your instance to shut down !

Querying the plan cache will do the trick ! Good idea !

Thanks a lot Grant and Gail.

What kind of replication do you want to use ?