The answers to your questions really depend on how long it will take to run the maintenance processes, and that will depend on the speed of the server.

I doubt that...

So what did you answer?

What do you think the answer is?

I think the diversity of opinions on this thread show that "Big Data" is just another magic marketing word that means whatever you want:

"Buy our server to support Big Data"

"Buy...

Jeff Moden (1/9/2013)

---

AndrewSQLDBA (1/8/2013)

---

Hello Everyone

Happy New Year!!!

I am fooling around with some code, and was wondering if there is a really great function to calculate the birthdate of a person....

paul.j.kemna (1/7/2013)

---

Other than issues with sorting and MAX, are there any potential issues with using something like CONVERT([varchar](10), datetimefield, 101) which yields a mm/dd/yyyy varchar value.

That is, the WHERE >...

You should probably do some IO performance testing with SQLIO to verify that the IO performance of the VMs is better than the IO performance of the old machines.

Sean Lange (1/8/2013)

---

Actually I think that a negative age has some real value if you think of age not as only the age of a person. What you are calculating...

The key to finding age is to find the birthday for the current year, and subtract 1 from the difference in years if the current date is before the birthday...

This is probably the best definition that I have read:

http://en.wikipedia.org/wiki/Big_data

In general though, "Big Data" is more commonly used as a marketing BS term, as in "We support Big Data".

I am not a fan of direct-to-tape database backups using the Veritas, ArcServer or other SQL Server backup agents for several reasons:

1. The tape drive is usually a shared resource,...

If you are doing index rebuilds, you will need enough free space for the largest index you are going to rebuild. Usually, it with be the largest table with...

Do DBAs handle the OS support for non-clustered servers? If not, then I don't see any reason for the DBAs to have responsibility for the Windows cluster.

In reality, both...

10e5x (1/3/2013)

---

Michael Valentine Jones (1/3/2013)

---

There is no DATE datatype in SQL Server 2005, but it is available in SQL Server 2008 and above, so if upgrading is an option, that...

There is no DATE datatype in SQL Server 2005, but it is available in SQL Server 2008 and above, so if upgrading is an option, that is one way to...

I think this method with the nested DATEADD/DATEDIFF is simple and has the advantage of eliminating the time part.

select

a.DT,

[LastDayOfPriorMonth] =

dateadd(mm,datediff(mm,-1,a.DT)-1,-1),

[LastDayOfPriorYear] =

dateadd(yy,datediff(yy,-1,a.DT)-1,-1)

from

( -- Test Dates

select top 32

DT = getdate()-1+

row_number() over...