Answer Posted / chris fauvel

--crap made a booboo
--corrected code here
--Both use the dateadd function provided by t-sql, I'm sure
oracle and others have similar functions

--this way is a little slower and costlier
select *
FROM sys.tables
where modify_date between dateadd(yy, -5, getdate() ) and
getdate()

--this way is faster and less costly, by not doing the same
--function for every row.
declare @now datetime
, @then datetime
select @now = convert(datetime, convert(varchar, getdate()))
, @then = dateadd(yy, -5, @now)

Select *
from sys.tables
where modify_date between @then and @now

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

2762

---

How do you migrate data from mssql server to azure?

165

---

If a stored procedure is taking a table data type, how it looks?

6449

---

What is the full form of ddl?

926

---

What are the different acid properties?

1066

---

Explain the truncate command? : SQL Server Architecture

1171

---

What is de-normalization and what are some of the examples of it?

976

---

Why truncate is ddl?

1088

---

Define compound operators?

914

---

How do I create an extended event in sql server?

953

---

Explain Geography datatype in SQL Server

1130

---

What is a trace frag?

1085

---

Can an entity have two primary keys?

981

---

Explain some stored procedure creating best practices or guidelines?

937

---

What is used to replicate sessions between instances in coldfusion clusters?

1072

---