PIVOT/UNPIVOT Question

Hi , I have a req as follows: My table structure is something like below: TestIDDistinctionFirst…

What is the third 'file' in the database folder.

what is the type of 'file' in the database folder other than .mdf and .ldf files. what is its use. …

Dsiplaying month & year in cross tab report

Hi, How to display both month & year in the format like Oct-12, Dec-2012, Jan-2013 in cross ta…

Max number of user connections available...

hi, Can anyone please advise, what are the maximum number of user connections allowed in each diffe…

Database Backups

Hi, I currently backup my databases everynight and also run a maintenance plan that deletes backup …

DBA Leaver Checklist

Hi, I'm currently working with a client that has had their DBA leave. This person had the "keys to …

Data in Foreign table not reference primary table

Sorry Administrator (My Data is SQL Server 2005, I post in SQL Server 7,2000 :blush:) My Data Error…

SSIS SCENARIO

Hi, Is there any difference between OLEDB Destination and SQL Server Destination in SSIS. Thanks in…

Which one is faster?

please tell me what is wrong with this query run on Northwind

Select Orders.OrderID, 'Order Total', 'order count' from Orders, (SELECT SUM ( [Order Details].…

Created Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server Agent

I created a Proxy to Execute SSIS Package Job worked fine but it does not allow Run AS SQL Server A…

Droping a Maintenance Plan

Is there an easy way to drop a maintenance plan job? when doing it via SMO right clicking & se…

Scale out SSRS for redunduncy

We're looking for redunduncy for our SSRS. We'd like to stand up another instnce of SSRS on a diff…

What is really in sys.dm_tran_database_transactions?

If I restart my local SQL Server instance and run: SELECT DB_NAME(database_id), * FROM sys.dm_tran_…

Migrate 2005 to 2008 or 2012 - Available in-built tools of SQL Server

Hi All, Planning to migrate 2000/2005 databases to either 2008 or 2012. What are the best ways to d…