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

Steve Jones - SSC Editor (8/22/2016)

---

I've listened to some code items while driving, and it's interesting. However, I can't learn. I can only get interested. I need to re-listen later...

Your decision between table variable or temp table should depend on the data access pattern of your query.

Generally speaking, table variables are best applied in OLTP stored procedures where you...

I hate "security questions". If I'm a hacker and want to know your grandfather's first name or your mother's mainden name, I can just go to ancestry.com. If I want...