Chuck Hottle (1/5/2012)

---

We recently found that some of our code was not closing transactions when errors were encountered. The only way that we found that was because we have...

One of the things we almost have to discuss is issues and problems. The trick is who are you throwing under the bus when you discuss it.

If for example...

Greg J (1/5/2012)

---

Stick with me Kraig...

I'm attaching a screeny of the resource monitor's take on memory which is why I originally said it's not taxed.

Also, I saw on the "output"...

Gianluca Sartori (1/4/2012)

---

Koen Verbeeck (1/4/2012)

---

Allright, I missed a few weeks of the thread because my wife gave birth to a wonderful son. (and thus killing my regular sleeping pattern)

Did I...

fabulous617 (1/5/2012)

---

Now considering that, I have a column of share positions whole positions and decimal positions.

Ex.

-What I have:

[Column1]

123456.00000

.12345

...

Isn't that dodecagibbon? Or is that Dodecachimpie?

@tom: ROFL. 😎

Good...

Side note. This analytical software sounds like something you'd usually do in SSAS if you were just using SQL Server tools. You build cubes overnight to see trends...

Yep, page...

What's your clustered index? That's the important part here. I notice you mention no PK but that's not necessarily the same thing.

If you don't have indexing going you're...

clintonG (1/3/2012)

---

I can access and modify the database on HostingServerA server using VisualStudio Server Explorer running on my local machine so not having the experience in this context I thought...

Are you dealing with a hosting provider? If so, you'll need to talk to them. You won't have access to the tools you'll need.

If not, you rarely (preferably never)...

What's this Exademon... err... Hexawitch... err.. Hexademinali stuff?

Open this page:

http://msdn.microsoft.com/en-us/library/ms189826(v=sql.90).aspx

The list on the left is relatively complete. It's missing a few things like MERGE and INTERSECT, but it'll get you started at least. I don't...

Have them look for connection objects that open transactions auto-magically for them as well. I ran into this a while back where my devs swore up and down they...