After reading up on the process of how 'Lutefisk' is prepared, I'm left with the impression that it's nothing like the popular Spanish dish 'Ceviche'.

http://mylittlenorway.com/2009/12/lutefisk/

xsevensinzx (8/25/2016)

---

Hope you enjoy Oslo, Norway. I was able to relocate there for the company I worked for 4 years ago. It was also my longest business trip before I...

Federal contractors, at least within the realm of IT, farm the actual work out to sub-contractors anyhow, and I can tell you that those sub-contractors are no more skilled than...

Matt Miller (#4) (8/25/2016)

---

SQLBill (8/25/2016)

---

Eric M Russell (8/25/2016)

---

I'm not surprised that a small group of students could take a public dataset and spin up a better application than the original...

Markus (8/25/2016)

---

Gary Varga (8/25/2016)

---

Changing for sure. That's nothing new. The change might be new but that it is...

An organization can spend millions on infrastructure, fancy BI tools, and contractors, but it will collapse like a house of cards unless they have a team of solid DBAs and...

I'm not surprised that a small group of students could take a public dataset and spin up a better application than the original government IT contractors. When dealing with non-sensitive...

Tac11 (8/24/2016)

---

Thanks Eric and SQL Guru.

Eric, so you think I can run "sys.dm_db_index_usage_stats" and find if there are index scan taking place?

or any other step should I take?

or...

If a query is performing full table scans on some large tables, then you want those tables to be held in the buffer cache so they arn't read physically from...

Grant Fritchey (8/24/2016)

---

It will do the business validations, absolutely. You just have to write the tests. There's not a tool out there that knows your business well enough to automatically...

Every time a data or index page is read, it's first copied to the page buffer pool. Pages are allocated and deallocated based on the frequency of their usage, and...

Whenever I change jobs or projects, I context switch between being primarily a DBA or Database Developer, both of which cross-over into tasks that could be best described as DevOps....

What partitioning brings to the table are things like partition switching, partial backups, partition level reindexing / compression, etc.

But 100K rows and 500MB small; you could fit that in an...

Reply back with the actual error or warning message you are getting. Are you sure it mentions 'LOB' ?

For example, if you attempt to create an index on a set...

The career path of IT professionals is a lot like actors, you don't want to allow yourself to become type casted in terms of a role or industry, and you...