ajay.g (6/30/2015)

---

In Database Mirroring, when automatic failover happens through Witness Server, User connection would be automatically re-directed to Mirror Server (from Principal Server which is Live for applications).

At Application level,...

Code to start a job on a remote server:

sqlcmd -SDBSERVER -E -Q"EXEC msdb..sp_start_job @job_name = 'Run RestoreDB'"

Code to check if the remote job has finished:

sqlcmd -SDBSERVER -E -i D:\Scripts\CHECK_Finished.sql

Contents of...

When using sp_startjob its an asynchronus call, so it wont wait till the job is finished. The way I get round this when only using a SQL...

I can't take credit for the function. I had that in useful scripts stored on my machine. But its definitely from a blog online.

The rest was me though...

I think this should do it, it also addresses the point Jeff made about gaps in the sequence.

CREATE FUNCTION [dbo].[CalculateNumberOFWorkDays] (@StartDate datetime, @EndDate datetime)

RETURNS int

AS

BEGIN

...

outdoor001.forum (6/20/2015)

---

Hello SQL Master!

I would like to seek for your advise please. Recently I passed the 70-432 SQL Server 2008, Implementation and Maintenance.

I would like to know what...

How about this:

SELECTnewer.MRN,

newer.EncDTTM,

newer.Sequence,

DATEDIFF(day,older.EncDTTM, newer.EncDTTM) as DaysApart

FROM TEST as newer

LEFT JOIN TEST As older

on newer.MRN = older.MRN

and newer.sequence = older.sequence + 1

ORDER BY newer.MRN, newer.EncDTTM DESC

Here is some good guidance on how to emulate job activity monitor programmatically:

http://www.sqlmatters.com/Articles/Checking%20the%20status%20of%20SQL%20Server%20Agent%20jobs.aspx

The undocumented procedure xp_sqlagent_enum_jobs can give you out the result set that you can manipulate.

A few questions:

1. Ballpark how many transaction log backups are you restoring to get your database up to date?

2. How big are these transaction log backup files?

3. ...

To give you a start here is one way to do it when storing in a table:

-- Create a table to store your fragmentation details

USE TEMPDB

GO

IF NOT EXISTS (SELECT TOP...

As mentioned already save the results in a table, but add a time stamp column for when the measurement was captured, you can then compare the rows based on the...

How about like this with a formatted table embedded in the body of the email:

DECLARE @ResponseAddress nvarchar(100),

@htmltext nvarchar(max),

@title nvarchar(256)

SET @ResponseAddress = 'email@email.com'

-- Create the HTML Text for the body of...

Its all covered here in msdn:

https://msdn.microsoft.com/en-us/library/ms188281.aspx

tcronin 95651 (5/5/2015)

---

Research has shown me this is like arguing religion, for a 128 GIG 48 core SQL 2008 R2 Enterprise edition, with maxdop set to 8, would you change...

Not really, you can run the other DBCC commands that make up DBCC CHECKDB independently though, overall it wouldn't save you any time:

https://msdn.microsoft.com/en-us/library/ms176064.aspx