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...

It sounds like you're describing some specific implementation of unit testing within SSDT or Visual Studio.

Unit Testing a stored procedure, generally speaking, is when you execute a stored procedure using...

Michelle-138172 (8/23/2016)

---

I have a db that has huge data but simple tables. I want to set up a job to back up the db structure only without the data. What's...

I havn't used eBay in years, but I recall from the past that it was possible to simply drill down on another user's ID and see a history of auctions...