You have to ask the Query Optimizer 😛

For small tables (like 100 rows), it may decide it's quicker & cheaper to scan the whole table

For big tables, depending on the...

Me agree, there is a problem with your SQL Server 2005 installation (no, 8GB is not the minimum memory either)

I would try to investigate that instead of trying to go...

Good start

http://sqlserverpedia.com/wiki/Reversing_Log_Shipping_Roles_(SQL_Server_2005)

Add a job step to check DB status (whether Online or Recovery/Mirror), then only start if it's Online

I seem to remember you can use Maint. Plans in Mirror Servers (or...

As far as I know and remember, SSRS doesn't support multiple datasets joining

so I always join them in the Dataset T-SQL query, so it appears as 1 dataset to SSRS

You...

Can you right-click and generate the script for the job for us to check?

Otherwise I'd remove the schedule, re-add it back to see if it still happens

It could a be...

Occasionally I see SQL Server using "Local System" credentials, to show up as DOMAIN\ServerName$

(the $ sign is a hint)

Check if any service is not run under a Domain\User account (which...

You need some SSRS 101 articles and Google!

You pick the Report Server project, use a Wizard to create a Report (or manually)

then in the Dataset section, use a T-SQL text...

nelsonj (12/4/2008)

---

Two great articles with handy tools. I happen to be looking for a disk partitioning tool (cheap but not Partition Magic since I can't find a "server" version)...

This one deserves some thinking through/ahead

What's the rationale behind this swap? What if you have to swap back in the future?

Will it be easier to split them into a FirstName,...

That's the MS SQL installation files, not just the system databases (master, msdb, model, resources)

Only way I know how is to uninstall and re-install

xSQL has some free tools too

http://www.xsqlsoftware.com/Product/Index.aspx

xSQL Object

FREE LITE EDITION

Compare and Synchronize SQL Server Database Schemas

generates SQL scripts too, closest to RedGate SQL Compare IMO

xSQL Script Executor ...

I think Transaction Replication with Update Subscription or Merge Replication would work if you will need to...

It's a never ending journey, but you being here curious on SSC is a good start!

Keep working hard at it and enjoy it

I agree, I wouldn't want [BUILTIN\Administrators] in my new SQL Servers either

It's one thing to control AD security, another for SQL

It does prove to be painful at times, sometimes nobody...