+1

Create a "updatedDateTime" with DATETIME type, with default GETDATE() (or GETUTCDATE())

Timestamp is a binary type to track of changes, confusing name yes

Note: ONLY Applicable on SQL 2008 (as in you need SSMS 2008, and it only works if server is SQL 2008)

If I have Red Gate SQL Prompt installed, I don't...

I agree, the question was confusing as the term "data" was not clearly defined

I picked MDW since I just tested this feature last week

As far as I am concerned, it...

Login triggers if you want to only do it for SA?

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

http://www.simple-talk.com/sql/sql-server-2005/logon-triggers/

http://www.sqlservercentral.com/articles/SQLServerCentral.com/sqlserver2005logontriggers/2366/

Although 'sa' account should be disabled on any SQL Server, unless you mean 'sysadmin'...

Just for fun

I REBUILD (not REORGANIZE) 5 indexes on a 0.5 million table, on SQL 2008 RTM, 5GB RAM (limit to 3GB for SQL though), 4 CPU

1 Clustered (8% fragment)

3...

Steve Jones - Editor (9/26/2008)

---

When you click reply, there is a "Last 10 Posts" section below the edit box and reply options. It is closed by default, but you can...

Wow, that is LONG

How much was the fragmentation %? I wonder if REBUILD (instead of REORGANIZE) would've been quicker

Was this tested in other environments to estimate the hours first?

We used TFS 2008 Beta, that didn't go so well as there was no official Microsoft Upgrade Path from TFS 2008 Beta to RTM

SQL 2008 we tested RC0 and was...

LOOKUP_BI (9/25/2008)

---

I solved it using this

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110841%5B/quote%5D

He meant this 😛 (saves you guys a click)

How to: Upload Files with FTP

Gladly never had this problem

Could SET QUOTED_IDENTIFIER fix it?

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

http://msdn.microsoft.com/en-us/library/ms187928(SQL.90).aspx

108 or 114 seem to do it

SELECT CONVERT(nvarchar(30), GETDATE(), 108)

16:10:04

SELECT CONVERT(nvarchar(30), GETDATE(), 114)

16:10:04:510

unless you are using SQL 2008, you can CAST datetime to 'time' type

SELECT CAST(GETDATE() AS TIME)

16:10:49.9630000

I know SQL 2005 has Performance Dashboard reports you can import

SQL 2008 has them built-in as Standard Report (right-click on server -> reports -> standard report)

Some monitoring tools (like RedGate...

http://technet.microsoft.com/en-us/magazine/cc434691.aspx

In this article, I'll give you an overview of the most important changes you'll find in store for SQL Server® 2008 security. One of the first things you might notice...

Thanks Kevin

That answered my imaginary question 🙂

RedGate SQL Response

some monitoring tool

or there are couple articles in SQL Central on collecting info from multiple DB servers as a job etc...

Unless they happen frequently, I would say reactive...