This what you are looking for?

DECLARE @Today datetime

SELECT @Today = getdate()

SELECT idx,

CASE

--1 or more days

WHEN DATEDIFF(mi,crtDte, @Today) >= 1440 THEN CONVERT(varchar(15), DATEDIFF(mi,crtDte, @Today) / 1440 ) +' days...

If I am understanding your question properly, you might want to look here:

https://technet.microsoft.com/en-us/library/aa337169(v=sql.100).aspx]

The link discusses how to setup dependent parameters in SSRS.

I think this might help you...

https://social.msdn.microsoft.com/Forums/en-US/fcf0a1ed-b11f-4724-817d-0e4324200a6e/sysdmosperformancecounters-empty?forum=sqldatabaseengine

CU1 for SQL Server 2012 SP2 is out too.

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

CU6 for SQL 2012 SP1 is out.

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

Before you start installing SP1, you should read this:

https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1#tabs

You may want to be aware of this major problem in SP1.

https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1#tabs

Generally speaking I have found in the past that OPENXML is faster if you need all the XML. XQuery is faster when searching for a value within the XML...

The biggest disadvantage in my opinion is the data in the DMVs is reset upon SQL restart. So if you are trying to do trending type of reports, you'll...

The answer to this depends on many factors.

1. What are your bottlenecks now? Memory? CPU? Blocking? Other?

2. What's your budget?

3. How much control...

Without more detail it's hard to say, but if I had to guess... Is there a query with a sub-optimal execution plan against a table that is either growing...

Could you post an exact copy of the error?

Lookup BACKUP DATABASE in books online and then execute a BACKUP command

Copy / Paste .bak file

nagkarjun1 (7/24/2012)

---

And...

In VS go to the menu -- Tools >> Options >> Database Tools >> Transact-SQL Editor >> Query Execution >> ANSI

Here you will find the SET QUOTED_IDENTIFIER option...

One way would be to hi the sys.partitions table. Here's an example of a query that returns row counts for every table in the msdb database. You could...