jasona.work (4/15/2013)

---

You want to use "With NoRecovery" not "With Standby."

Standby will roll back any uncommited transactions and put the DB in read-only. NoRecovery basically tells SQL Server that there's...

Robert-378556 (4/15/2013)

---

Lynn Pettis (4/15/2013)

---

I think you are thinking of BLOB - Binary Large OBject or CLOB - Complex Large OBject.

I have used the term LOB - Line Of Business for...

It also depends if the Fiscal Months/quarters/year will map to actual months/quarters/year. Most of the companies I have worked for the fiscal year/quarters/months may not have been the calendar...

I'm not exactly sure what you are looking for here. Are you trying to display aggregate values for YTD/QTD/MTD side by side, are you attempting to return separate result...

Michael Valentine Jones (4/15/2013)

---

Lynn Pettis (4/15/2013)

---

Robert-378556 (4/15/2013)

---

First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an...

ashuthinks (4/15/2013)

---

I'm working on SSRS reports there is on column i.e Holding period where we actually calculate for

how many days the company is hold in our database (we compare with...

It is difficult to provide correct answers to questions when we can't see what you see.

Please read the first article I reference below in my signature block. It will...

Robert-378556 (4/15/2013)

---

First choice with such questions is in most cases google, then wiki, then forums, just because you have a high probability to get an accurate answer immediately.

OLTP = On-line...

Well, I won't be at Pass this year, but I will sure try to make it to PASS in 2014.

iiit.raju (4/14/2013)

---

I have a table

create table accounts

(

accname varchar(100),

recstatus bit

)

and records are as follows:

Insert into accounts values ('Pepsi Co',0)

Insert into accounts values ('Pepsi Co',0)

Insert into accounts values ('Prudential',1)

Insert into accounts values...

I don't know if I should take this as a joke or an insult.

Jeff Moden (4/13/2013)

---

Yes, but they're probably not viable for your situation. My recommendations would all start with "Get rid of..." and "Replace the..." and end with "...

I'll be honest, you will get much better answers if you could provide us with the more detail regarding your environment and what you are trying to accomplish. Please...

If by...

eseosaoregie (4/13/2013)

---

Hi Jeff, thanks for your reply. I will give this a go when i am back at the office. Just one question for future reference. What is an EAV...