I am going to try SQL 2012 to see if it is a new feature.

Here is my exact query, I am havving difficulty getting one row for each attribute.

select 'cost', [2009], [2010], [2011]

from (select year, cost, price from table1) as source

PIVOT

(avg(cost)

for year in ([2009],[2010],[2011]))...

Hi Mark,

In your post, you mentioned that for file based subscriptions you can simply include @TimeStamp in the file name field. I am trying to include a parameter in the...

Hey Josh,

This works for email subscriptions, but for some reason, does not work for Windows File Share subscriptions. I am using SQL Server 2008 r2 Standard. Perhaps this is an...

I can and will rebuild more frequently than they prescribed. . Thank you all for your help!

Thank you both very much for your help. Unfortunately, I cannot control indexes or queries as they are part of the software and if I changed them, future updates to...

One thing I notice is that no matter how much RAM I allocate to this vMachine, SQL Server utilizes all of it. Even when the server is under no load,...

Autogrowth is set to %10 and it has only grown once in the past 9 months. Indexes are rebuilt quartely and are maintained by the software vendor who created the...

These articles look great for looking at specific queries, but my trouble is with the entire DB running slow. Simple operations that were not slow a couple months ago are...

Thank you for your help Lowell. This was a combination of me needing a linked server and the user that SQL Agent was using did not have permissions on the...

Okay, I have the linked server created, now I get this error when trying to do a DB integrity check remotely using the maintenance plan.

"Executed as user: USER. Microsoft (R)...

Hi Lowell, That box is checked and I am able to connect via SMSS from the 2005 enterprise box.

I know there are probably quite a few variables here, but...

Yes, exactly. There is a small number of predetermined contact types. Thank you for the hint on the proper search terms!

Hi Ron,

I follow your logic perfectly and expect the same results. Could this issue have to do with the fact that I am querying a view? In the origional table,...

There was only the default instance. One wierd thing though, at the SSMS login screen, there were two identically named options to connect to. Neither worked. And no, I could...