There must be a better way...

select distinct b.ParameterID,b.ParameterValue,a.ParameterTimestamp

From #Parameters a

Cross apply (select distinct ParameterId from #Parameters) c

Outer Apply (select top 1 * from #Parameters

where ParameterTimestamp <= a.ParameterTimestamp...

I haven't used disk encryption, but when you copy data to other device (flash drive etc...), it is no more secured. While TDE and/or file encryption provides that security.

Definitely Disk...

Please read this article

How much tempDB grows by this query?

What data types? any blobs?

How much sql memory? Min/Max

How much "Memory Manager/Total Server Memory(KB)" from PerfMon?

Also consider size of data in 200K+ rows

You need to specify parameter is nullable or not

CREATE PROCEDURE [dbo].[DR_Premier_PO_O] (@DischargeStartDate DateTime =NULL, @DischargeEndDate DateTime =NULL)

AS

DECLARE @vStartDate as varchar(30), @vEndDate as varchar(30)

SET @DischargeEndDate = DateAdd(mi,-1,@DischargeEndDate)

SET @vStartDate = CONVERT(varchar(30),...

Can you try giving "Log on as a service" permission?

Administrative Tools -> Local Security Policy -> Local Policies -> User Rights Assignment.

Edit the item "Log on as a service"...

100% agree, thanks

What about taking compressed backup over network?

I would say it can be either or both. The possible reasons I can think of are...

- Increase in...

"a" and 'b" are alias

to understand CROSS APPLY check this link[/url]

Use CROSS APPLY

Select b.*

from #ProxyLog_count_2 a

CROSS APPLY (Select ClientUserName, DestHost, count(DestHost) counts

from #ProxyLog_record

where ClientUserName = a.ClientUserName) b

I assume you have more than one server to include in this task

For master database you have to perform CHECKDB on production server

Check this article by Paul

I have setup this...

shahgols (6/20/2012)

---

Hi Grant, I have a question,

I see that sys.dm_exec_cached_plans has a column objtype, and one of the values for this column is "Adhoc". Could this object/column be used...

Mohammed Yousuf (6/19/2012)

---

I can fetch the Object names.

But I want to determine the actual SQL statements SELECT/INSERT/DELETE/UPDATE that are involved in deadlock.

The objects point to SP's and they have many...

create table #tab1(id int,oldId int, InsertedOn datetime)

insert into #tab1 values (99,NULL,getdate()-7)

insert into #tab1 values (17,14,getdate()-9)

insert into #tab1 values (14,12,getdate()-14)

insert into #tab1 values (12,null,getdate()-15)

insert into #tab1 values (20,17,getdate()-8)

select distinct a.id,a.oldId

from...