Why would SQL Pass want to list the candidates in the order of committee ranking? The slate has been ratified, so it should be just the names of the candidates...

Hey Jim,

you are right about the data being in the memory for tables that are accessed regularly. But what about the write speed? Even when the data is persisted, the...

Hey Patrick,

There is an improvement performance. But Interpreted T-SQL does not perform like the compiled stored procedures. In SQL 2014, there was some major work done on the query optimizer...

I advised the OP to go for Set based. I hope he does not think that SQL 2014 will magically get everything to run faster.

I got someone asking if Cursor will work fast on memory based objects.

It felt like the OP would upgrade to SQL 2014 so that he/she can make the cursor...

I strongly recommend not to use cursors. Whether be it on a disk based or a memory optimized. You still have to loop through each row. I am sure you...

Hi Gabriel,

In this version of SQL server, the execution of T-SQL statements does not need require that many instructions to execute it. Also if you create compiled stored procs, it...

Hi Simthembile,

You will have to manually migrate the objects. Please keep in mind that it is not recommended to make all disk based tables into Memory objects. You might end...

One thing you can do is to make sure the Job is enabled on the right node.

You can achieve this by having another job running on both the primary...

Thx guys..

There was not SQL Saturday this year. We will have one during memorial day weekend next year.

Jack, hopefully we can meet each other this time around. 🙂

Greg Edwards-268690 (9/4/2014)

---

Roy Ernest (9/4/2014)

---

So ANSI Joe is still at it? It has been a very long time since I have been to the forums.

Do we have any new...

So ANSI Joe is still at it? It has been a very long time since I have been to the forums.

Do we have any new ANSI Joe twin? I...

You nailed it on the head. The domain name was wrong. I set it up with .com but our domain is different. Thanks Perry.

Damn it.. I miss the hugs from Miss Shaw. 🙂

They are using some wrong term when they say Proc cache.