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…

Report Parameter In Different Reports Rendering Differently

Hi, I've been trying to analyse why the same multi-value string parameter is rendering differently …

In which situation OPTION RECOMPILE is required in SProcedure's Definition?

[font="Verdana"]SQL Server tries best to maintain execution plans of objects as to maximum extent p…

Profiler blocking the application????

Hello, I'm trying to generate a trace (tuning template) with Profiler regarding a .NET application …

SQL Server 2008 R2 File/Filegroup Restores

Our production DB has 4 total files associated with it: 1 File_A - Primary File Group- 15 GB 2 Fil…