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...

Really short answer, VARCHAR(MAX) is not supported. You can't put that table into columnstore.

Long answer. Columnstore indexes are extremely useful for aggregation queries. They also work ok for some types...

Eirikur Eiriksson (4/3/2015)

---

Grant Fritchey (4/3/2015)

---

You should be able to simply run CAST against the data to put it into the right data type in the view. But, if the data...

You should be able to simply run CAST against the data to put it into the right data type in the view. But, if the data is not formatted properly,...