Yes it is possible , depends on what you want to track :-

Database objects can be tracked by using a server tigger for DDL keywords such as create , drop...

where do you go to find best practice advice?

Peers , BOL , anywhere i can . Do I implement them ? not always , as you mentioned there is no...

select * from live table

union

select * from history table

would also have worked

Union all will give back repeated data, union will not.

Automatic fail over is possible only with Clustering and database mirroring , replication will not meet any kind of DR requirement. Replication is only meant to scale out a...

Could you please post the execution plan for the above query

Do you know which executable in particular contained the reference .

I know for a fact that Analysis services has bug where a data view can be modified but the...

try going thru this lms

http://www.sqlservercentral.com/Forums/Topic159966-54-1.aspx

Grant update = edit permission , if you need to add new rows use grant insert

domain is the network name , say for example your company is amazon and...

CREATE LOGIN [Domain\Username] FROM WINDOWS WITH DEFAULT_DATABASE=[SomeDB], DEFAULT_LANGUAGE=[us_english]

GO

USE [SomeDB]

GO

CREATE USER [SomeUSer] FOR LOGIN [Domain\Username] WITH DEFAULT_SCHEMA=[dbo]

GO

GRANT SELECT ON [OBJECT] TO SOMEUSER

GRANT UPDATE ON [OBJECT] TO SOMEUSER

Perform the above steps then...

Do you have ANSI padding on ?

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

Gianluca Sartori (6/24/2011)

So, this means you're human, after all. 🙂

Enjoy your vacation, Gail: I'm sure you deserve...

Why not let SQL manage the memory on its own, are you using a 64 bit implementation ?

At worst you might need enable the 3 gb switch in boot.ini and...

worktables use the collation as specified for the database in which the operation is being performed. So I dont think you would see any additional performance impact other than what...

are you inserting into multiple linked servers or do you have just one ?

selects would show up if the time stamp of last index seek or scan are closer to today