efyuzegeekgurl (4/5/2015)

---

Hi Grant

Thanks for replying.

Actually on our production server, we have a standard maintenance plan setup that runs the "Check Database Integrity Task" nightly before taking a full backup....

Yes. Although, generally, you don't see deadlocks from a procedure that only has reads.

Maybe I'm confused, but it just sounds like an INSERT... SELECT operation. Insert into the new table using the values of the old one. Or am I missing something? The...

Assuming you have a primary key to identify each row, I'd suggest setting things up through the MERGE command instead of just insert. That way you can do what's appropriate,...

I'll just add that you should make sure you still run DBCC CHECKDB on your production server, but that you just do the PHYSICAL ONLY check. Since you're going to...

A lot of what you're asking about isn't necessarily related to capacity planning. Just speaking on capacity planning, focus on size and volume and growth. "How many" and "how much"...

Jeff Moden (4/4/2015)

---

krypto69 (4/4/2015)

---

Grant Fritchey (4/4/2015)

---

If the partitioning is working for your in production and you're actually using it, removing it doesn't make a lot of sense. If this other...

xsevensinzx (4/4/2015)

---

Grant Fritchey (3/31/2015)

---

Well, Prompt does...

Deadlocks occur because Process A has exclusive locks on objects that are needed by Process B while at the same time Process B has locks that are needed by Process...

There's nothing native inside of SQL Server Management Studio that will generate CRUD procedures for you. You'll have to use a third party tool. Codesmith is still out there. Get...

Another vote for the OUTPUT clause. That link is to the documentation.

baiju krishnan (4/4/2015)

---

Message Preview

Hi following is a working code

declare @dte as datetime='2015-04-01'

declare @StDt as Datetime = DATEADD(mm,DATEDIFF(mm,0,@dte), 0)

declare @EnDt as datetime = DATEADD( DD, -1, DATEADD(mm,DATEDIFF(mm,0,@dte) + 1, 0));

DECLARE @query...

If the partitioning is working for your in production and you're actually using it, removing it doesn't make a lot of sense. If this other server is not a production...

NVARCHAR (MAX) is not supported. I mistyped that. Still, everything but my typo is what I meant to say.

It could be a huge number of things. No way to tell you based on the information we have.

I'd suggest monitoring the system in order to understand what's happening with...