oops :blush:

I'll try to remember that in the future. 😉

First, I have no idea what article you are refering to here. Second, there are no non-logged operations in SQL Server. The BCP is logged, so if you...

Here is a possible alternative. I haven't compared it to Phil's solution.

create table #temp (

NM_ID char(3)

,STRT_DT date

,END_DT date

);

insert #temp

select 'ABD', '01/10/2010', '01/11/2010' union all

select 'ABD', '01/11/2010', '01/12/2011' union all

select...

Evil Kraig F (8/22/2012)

---

Lynn Pettis (8/22/2012)

---

I'm going to go against the flow a bit here. I think it really depends on what the application is intended to do. ...

I'm going to go against the flow a bit here. I think it really depends on what the application is intended to do. Where I work now I...

I try to pay enough attention that I don't get bit by a bye week for a player, maybe looking for an occasional change if a player isn't performing well...

A partitioned table is a table, in fact starting in SQL Server 2005 all tables are actually partitioned with a single partition. It should have no affect on the...

You could use linked servers and synonyms to access the data from another database in another instance on the same server (doesn't that sound convoluted). I personally don't see...

Stefan Krzywicki (8/22/2012)

---

Brandie Tarvin (8/22/2012)

---

Allow me to correct myself.

ChrisM@Work (8/22/2012)

---

Brandie Tarvin (8/22/2012)

---

President Bill Clinton once said "Define intercourse" ... or maybe "define sex"... in an interview about a sex...

aostanley (8/21/2012)

---

I want to express my sincere gratitude to all of you for the valuable help you have offered me here.

Thanks to your help, I have a solution...

With no execution plan to see what is going on, here is one possible idea for you to try:

ALTER PROCEDURE [dbo].[usp_tbl_staff_assisted_getbyuser]

@col_staff_username CHAR(20),

@usertype...

You are welcome. Now, try and tell us how we accomplished the task. If you can't explain it, you shouldn't use it in production as you are the...

Others beat me, but I didn't give it just as the OP asked.

create table #testtab1(ID int, Status int);

insert into #testtab1 (ID, Status)

values (1,0),(2,1),(3,0),(4,1),(5,1),(6,1),(7,1),(8,1),(9,0),(10,1),(11,1),(12,1);

go

With BaseData as (

select

ID,

...

MegaDBA (8/21/2012)

---

I would increase the time you take a log backup to let's say every 30 mins. And as Scott said, you should set the tLogs to grow in MB...

Minnesota - Viking (8/21/2012)

---

durai nagarajan (8/21/2012)

---

In that case he has not scheduled Tlog backup from 6:00PM to 10:00PM which in turn might leave him in data loss incase of...