I dunno

I've been looking at some of the queries, and many of them join on RWA_ID which is an application wide field used as a primary key, but not actually specified...

I used to do something like:

Script out the "Drop publication" command

Script out the "create publication" command

Run just the part of the drop having to do with your table to remove...

That what we'll be doing for...

Greg is correct. Take a backup of FLB_UAT before you do the data refresh. You need to hold onto the 10-31 production backup and not let it get automatically deleted...

Ninja's_RGR'us (11/13/2008)

---

Hi, I'm with a client today and he asked me if we could use a virtual machine for the sql server. The intent here is that if case...

Not a good idea in a...

Idera's Diagnostic Manager has a lot of useful features. i used it at my last place to track down long running queries and a whole pile of statistics for troubleshooting....

Mike Levan (11/12/2008)

---

Many DBa's say that shrinking is a bad idea, but that is what we do to gain disk space every time.

is there any alternative we can do for...

Phil Auer (11/12/2008)

---

I am looking at third party backup solutions specifically to get backup file compression. I'm pretty sure I can't run concurrent transaction log backup schemes because the...

Sounds like it's going to a backup device with "append" instead of "overwrite".

I prefer creating indiviual .BAK files and keeping a few days worth on hand in case they're needed.

Most people try to take full backups during off hours. This minimizes impact on users and gives a clean point in time to begin a restore if needed. Then take...

yulichka (11/12/2008)

---

Thank you for your help, I don't have mobile users. I would need to compare two servers staging and production, if there is any changes with data in production,...

Redgate makes tools to compare the databases, but I don't know if it will also apply the changes. How about using replication to keep them in sync ?

[font="Courier New"]SELECT Job.[name], Hst.[sql_message_id], Hst.[message] , Hst.[run_date], Hst.[run_time], run_duration

FROM [msdb].dbo.sysjobhistory Hst

INNER JOIN [msdb].dbo.sysjobs Job ON Hst.[job_id] = Job.[job_id]

where convert(varchar(8), GETDATE()-1,112)= Hst.[run_date]

and name not...