BL0B_EATER (1/19/2016)

---

Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my mentoring / training relationship...

ffarouqi (1/18/2016)

---

Hugo,

I cannot post each, and everything due to certain reasons which I hope you understand. I'll provide you with the select query with the actual values replaced with dummy...

ffarouqi (1/18/2016)

---

Fyi...we've used isdate to eliminate the non-date stuff, but the problem still persists. Kindly, let me know which piece of code is causing the issues, because if I run...

Thanks for that, but you did not provide all the elements I asked for. Could you also provide INSERT statements with sample data, a sample DELETE statement to set off...

There is no easy way to do this.

You could try querying the DMV sys.dm_all_sql_modules with a WHERE clause like WHERE definition LIKE '%SearchString%', and then use searchstrings that invoke serializable...

By changing the condition from IN (some values) to = (one value), you caused SQL Server to choose a different execution plan.

By using a different execution plan, SQL Server attempts...

Not sure if it is related or not, but perhaps this helps:

https://support.microsoft.com/en-us/kb/303774

(This is about @@SERVERNAME, not about @@REMSERVER - but have you tested @@SERVERNAME on both the local and the...

The code you posted appears to be incomplete.

The comments already indicate that @PP_IDParm is passed from the trigger, but you did not post the actual trigger code. The code you...

When using spinning disk, then ideally the transaction log should be on its own disk. If you have multiple heavy used databases, then ideally have a separate disk for each...

The correct but bad answer is to start with DECLARE CURSOR and OPEN CURSOR, plus initializing some string variables. Then you enter a loop that uses FETCH to get the...

The "problem" with wanting to ask too much in a single question (and I can know, I have the same problem when submitting questions) is that readers can get at...

With int, the maximum value supported by SQL Server is 2,147,483,647. Since you are currently at 1,000, I think you do not need to worry just yet.

If you do run...

I have had some very unpleasant experience with linked server queries recently. Unfortunately, I have not discovered any silver bullet.

When troubleshooting linked server performance, always study the execution plans in...

er.mayankshukla (1/15/2016)

---

When looking at low-level implementation details, yes.

Functionally, no. There are lots of functional differences between unique and nonunique indexes. So you will want to continue defining indexes are unique...

When looking at low-level implementation details, yes.

Functionally, no. There are lots of...