Actually, it does sound as if this database is only a repository for data.

If I understand the architecture correctly:

1. The application reads data from the database, or someplace.

2....

abdullah.zarour (1/13/2016)

---

Hello Michael

Quick questions. Have you ever partitioned a table? If so, can you provide some actual facts as to what the performance gains you realized?

Yes , I did...

abdullah.zarour (1/13/2016)

---

Hello SSC-Enthusiastic ,

You might try the following point :

1. Create a table partition.

2. Configure the SQL Server Instance Option ( Optimize for Ad hoc workloads).

3. Check Max...

Stijn Vervaet (1/12/2016)

---

Apologies Michael, I was trying to get my DSQL-SPs generator to work so I could test it and forgot to provide you with the execution plans. I will...

Again, can we see a comparison of the two actual execution plans? That would help much more than this chart from Idera.

Stijn Vervaet (1/12/2016)

---

Hello gentlemen,

I investigated the “SP with Dynamic SQL” for a couple of hours this morning and came to the conclusion to move away from this route in...

I second Eric's suggestion. Can you post a comparison execution plan?

Thank you.

The local variables are what I...

I have a pure OLTP system, which I'm trying to further optimize. For this I use a set workload which runs a large number of big transactions (mimicking my production...

Jack Corbett (1/11/2016)

---

Ed Wagner (1/11/2016)

---

Koen Verbeeck (1/11/2016)

---

Ed Wagner (1/11/2016)

---

Grumpy DBA (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my...

Will this work:

Declare

@lcFirst_Name VARCHAR(20) ,

@lcLast_Name VARCHAR(100) ,

@lcGuar_First_Name VARCHAR(20),

@lcGuar_Last_Name VARCHAR(20),

@lcMinitial VARCHAR(20) = '',

@lcGuar_Minitial VARCHAR(20) = '',

@PIDcName VARCHAR(100) = 'Sumair^Haider^R',

@GITcName VARCHAR(100) = 'Ali^Haider.',

@Pidx INT = 0,

@Gidx INT = 0

SELECT [1] ...

Ed Wagner (1/6/2016)

---

Sean Lange (1/6/2016)

---

Ed Wagner (1/6/2016)

---

Brandie Tarvin (1/6/2016)

---

Sean Lange (1/6/2016)

---

Wow. I rarely have to deal with user issues but I was just on a phone call with one of...

Jeff Moden (12/29/2015)

---

Lynn Pettis (12/29/2015)

---

Jeff Moden (12/29/2015)

---

I rather like the mostly unedited type of articles that are posted on SQLServerCentral. As a regular working Joe-bag-o-dunuts, I don't have a...

Jeff Moden (12/29/2015)

---

I rather like the mostly unedited type of articles that are posted on SQLServerCentral. As a regular working Joe-bag-o-dunuts, I don't have a whole lot of time...