The most effective way you can have this done from within SQL Server itself is through triggers. You can set up extended events to capture the changes... it's going to...

Hugo Kornelis (1/21/2016)

---

Though I am happy to hear that he feels that he has heard enough to be able to solve it, I am at the same time concerned. Based...

salardx (1/21/2016)

---

Guys! please!

We CANNOT have much indexes in the tables (neither one table for each month, nor 10,000 tables!)

because data is bulking into the tables! 1000 records on each bulk!...

Please, please, please, I already feel like I've been picking on this person, so no piling on. But they're looking for help and I don't think I'm providing it in...

salardx (1/21/2016)

---

Do any of the files that you load have the same structure? If so, why not put them into the same table? And why create a new database each...

The very best way to deal with scale is start with the fundamentals. Making good choices on the clustered index, primary key (not the same things), unique constraints, normalization, data...

I don't understand what you're going for. When you say you want to "check five columns uniqueness by checking one column" you're stepping outside of standard mechanisms.

What I'm suggestion is...

There are lots of ways to document a procedure. It really depends on why you're documenting it, for what purpose, for what audience.

One option is to look to a third...

bebe022476 (1/20/2016)

---

HI Gail,

Here it is:

DocumentID(PK,int,not null)

DocFolderID(int,null)

PublishToWeb(bit,null)

Filename(varchar(100),null)

Filesize(int,null)

ModifiedDate(datetime,null)

TableName(varchar(40),null)

EntityCode(varchar(12),null)

I'm not sure how to attached the jpg screenshot here but the execution plan only has 100% Clustered Index Scan(Clustered) on [document],[pk_document] .

The job normally...

What about just using a unique constraint?

For the most part, when it comes to parallelism, your MAXDOP is not the issue. Instead, the issue is almost always around the Cost Threshold for Parallelism. The default value...

You need to capture the execution plan when the query is performing well and when the query is performing badly. Compare the two plans. There differences should indicate why you're...

craig-962225 (1/21/2016)

---

As this has been a problem since the beginning of time, one would have hoped MS would have come up with a solution to create a backup into a...

Lynn Pettis (1/20/2016)

---

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb...

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It evidently looks...