This is a very broad question that depends on your business, resources, staff, infrastructure, etc.

This link might help:

http://www.mssqltips.com/sqlservertip/3248/choosing-between-sql-server-2012-and-sql-server-2014/

I'm not sure how you can avoid creating a function/procedure or template.

I suggest using INFORMATION_SCHEMA views to generate the dynamic SQL.

Here's some sample SQL, but you'll probably need to...

Does the Open column only go to the nearest Day, and not include time?

If not, it looks like you need a way to rank the Status.

For James Turner, what's telling...

About a year ago, I was introduced to a new project using the catalog model, and my personal transition has been difficult. My final verdict, is that there's no...

Here's a quick query using system tables and reference:

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

Database Object Views: http://msdn.microsoft.com/en-us/library/ms189783.aspx

SELECT

table_name = t.name

,table_rowcnt = SUM(p.rows)

FROM sys.tables t

INNER JOIN sys.partitions p on...

Thanks, I'll take a look.

Realized my sample data was bad. The PK will be in increasing order, which might help, but it'll have same gaps, like the...

True, date conversions get tricky depending on context. But taking into account students, and school system, I'm guessing that level of accuracy isn't necessary.

Your example introduces division by floats...

You'll want to look into DATEDIFF function: http://msdn.microsoft.com/en-us/library/ms186724.aspx

Try this:

DECLARE @birthday_list TABLE(

date_of_birth datetime

)

INSERT @birthday_list(

date_of_birth

)

VALUES('1980-05-03')

,('1999-11-23')

,('2010-04-14')

,('2000-09-29')

SELECT

date_of_birth

,age = DATEDIFF(YEAR, date_of_birth, GETDATE())

FROM @birthday_list

--RESULT:

--date_of_birth ...

Not that this necessarily helps, but I'm running into similar behavior but reversed. IE's broken but firefox/chrome are OK.

Mine's definitely related to parameters in my report. My customer...

I'm afraid not. I ended up using the ActiveX task. We'll have to revisit this problem once SQL 2008 is more prevalent since ActiveX will be phased out.

We...

I'm unsure of the exact circumstances, but here's the KB article:

http://support.microsoft.com/kb/291332

Sometimes querying for 'NumLicenses' will sometimes come back as null, and 'LicenseType' as DISABLED.  Going to the Control Panel...

During this load, I'm putting the database in SIMPLE and 'trunc. log on chkpt.' to true.

I thought the solution was to keep a row count in a loop, but I...

Thanks for all the input. As I mentioned, the log backups have been failing for weeks, and after making enough room, only the next transaction log was "oversized." ...

I've inherited some servers that are doing periodic transaction log backups. They've been failing for weeks because there's no more diskspace. I decide to cut my losses, and...

It's related to indexes but I'm not querying the tables directly.  I'm trying to create a comprehensive index report.  I've seen readymade queries here, but I'm trying to avoid querying...