NorthernDBA (7/2/2015)

---

I'm not really comfortable with licensing (and please correct me if i'm wrong) BUT you have to license all cores that might be available to sql server and not...

No, it's not. In fact, the only feature I can think of that...

The decisions as to what's Enterprise and what's Standard will likely be made much closer to release.

No. MaxDop limits the number of running threads a query may have, not the total number of...

Table variables are only visible in the scope where they are defined. They're like normal variables. Since you declared the table variable outside the dynamic SQL, it's not visible inside...

It's an inefficient split function, but whether it's the problem or not is impossible to tell from the information available.

No, you can't move that to the client, because it's...

I don't recall doing that in the last couple...

Zip the .sqlplan file and attach the zip. Since it's XML, it compresses very well.

The one you captured from Profiler please.

Look in Books Online (the SQL help documentation) on sys.master_files or sys.database_files for what the values mean.

Rod at work (7/1/2015)

---

I have to respond to this, especially when you say that it appears there's a DBA/Developer factory pressing out people all using the same mold. That reminds...

Can you post the query at least? The execution plan you captured would also be rather useful

SELECT * FROM sys.master_files

Correct.

Order of columns matters in the key, not in the include

Feasible, but probably not a good idea.

Unless the query which uses the smaller one is so time-sensitive that it cannot possibly take a millisecond longer, you're probably best off merging...

SQLRNNR (6/30/2015)

---

Alvin Ramard (6/30/2015)

---

Question is being asked in the forum: "if mdf get full by data then how to make free space without adding disk."

Is it ok to suggest dropping...