Jason/Wayne: Belated clap from the back of the room when some dude finally took his earphones off and asked the guy next to him why the applause was so loud....

amadou.barry (4/16/2013)

---

I want to print out the day as in numeric, but when i run this query I don't have any output for display. Can someone please help, I don't...

Egos

I believe the confusion here lies in what is the simple recovery model.

Everything in SQL Server is logged. The Simple Recovery model merely allows for re-usage of the log...

aliens218 (4/16/2013)

---

Hi all, I'm in need to import several flat files into a SQL table. I'm used to importing one at a time, but I'm new and starting to...

kevin.kembel (4/16/2013)

---

I have, and there's plenty of RAM free (8GB of 16GB free when it crashes), but is there another limitation that I'm running into? Something per-process?

I read that...

It sounds like it's running out of memory, offhand. Have you watched the system bottlenecks while this runs? If you're in BIDS, you need to watch your own machine.

Ben, in my opinion there are no Rapid Application Development tools. Just ones that people are the most familiar with so they're quick using it, and pre-built components that...

Branding is all well and good, but I've found that trying to find me can be... interesting.

A) Apparently my name is common.

B) There's a particular Soccer player who tends to...

Sorry, got inundated yesterday, but wanted to catch up with this. As mentioned, we really need everything for tuning assistance. The article describes the easiest ways to get...

Milliseconds, most likely. See what happens when you get so thorough in your answers? 😉

Running totals are best done in reporting environments. SSRS handles this cleanly.

If you HAVE to get your procedure/T-SQL to do this, look up the article on this site under...

I have found that you need to examine the 'noise' in each table, and update accordingly. Now, you have to go to 'huge' before it matters, but as little...

Heya Josh,

You're most likely on the right track with the heap, but for optimization items there's a bunch of data most of us prefer to see before we start bounding...

I just saw a rather disconcerting event (which was in my favor) where a local white hat broke open my PC's administrator password in about 20 seconds from a cold...