meta user
network profile
| bio | website | |
|---|---|---|
| location | Austin, TX | |
| age | ||
| visits | member for | 1 year, 5 months |
| seen | Dec 26 '11 at 1:54 | |
| stats | profile views | 16 |
Professional DBA, database developer, data architect and data warehouse/BI architect.
Particular areas of expertise: MS SQL Server, GIS, financial modeling, high concurrency systems.
|
Dec 13 |
awarded | Yearling |
|
Dec 22 |
comment |
Writing a simple bank schema: How should I keep my balances in sync with their transaction history? @NickChammas /me heads off to close his account at BofA. ;-) |
|
Dec 22 |
comment |
Writing a simple bank schema: How should I keep my balances in sync with their transaction history? You know, normally people ask on StackExchange "Is this homework?" because they don't want it to be. But, since you're doing a bank schema from scratch, I really, really hope for your sake that this is homework. :D Either way, it should be a great lesson in proper ACID transaction design. |
|
Dec 21 |
awarded | Quorum |
|
Dec 21 |
comment |
SQL Server reports for management @jcolebrand I'm judging the breadth of the question, not the ability of the person. I am sure Alex is capable & smart & will make a great DBA. But I wouldn't regard a simple list of trackables as an upvote-worthy answer. There's no report that spits out a "Your database is healthy" message. If I say "Monitor the Disk Queue Length" to someone new to the field, I'm going to be saying it as a lead-in to a larger discussion of benchmarking and profiling and understanding what that datum means. "Health" is not just about having an EKG machine, it's about reading what it is telling you. |
|
Dec 21 |
revised |
Joining two tables on multiple criteria added OP's description of attempted solution thus far |
|
Dec 21 |
awarded | Commentator |
|
Dec 21 |
suggested | suggested edit on Joining two tables on multiple criteria |
|
Dec 21 |
comment |
Joining two tables on multiple criteria Welcome to DBA.se. Your questions will typically get better answers and more votes if you include information on what you have already tried, which is why JNK asked. I'm editing your response into the question. Also, if your question is for a specific database server (e.g. Oracle, SQL Server) it is a good idea to put that in the question and in the tags. Which RDBMS are you targeting? |
|
Dec 21 |
comment |
How do you choose a SQL statement timeout? What RDBMS and version? |
|
Dec 21 |
comment |
SQL Server reports for management Your question essentially reduces to "How should I, a non-technical beginner, become a DBA?" This is far too broad a scope to be a good question. As it says in the FAQ, "Your questions should be reasonably scoped. If you can imagine an entire book that answers your question, you’re asking too much." I know you're new to this, and thus you may not realize that you just asked a book-sized question, but you did young grasshopper. :) There's a reason people make a career out of being a DBA. It's a complex subject. |
|
Dec 20 |
revised |
In SQL Server 2008, how can I get all the columns that are marked as nullable in their schemas even though no records contain NULL for those columns? corrected code to incorporate edge case correction suggested by Martin |
|
Dec 20 |
comment |
In SQL Server 2008, how can I get all the columns that are marked as nullable in their schemas even though no records contain NULL for those columns? Yeah, for SQL 2008 your approach is far better optimized. Very elegant, and I'm sticking it in my quiver. And good catch on the QUOTENAME edge case! Code revised accordingly. |
|
Dec 20 |
revised |
In SQL Server 2008, how can I get all the columns that are marked as nullable in their schemas even though no records contain NULL for those columns? Fixed code to replace sys. usage with INFORMATION_SCHEMA |
|
Dec 20 |
comment |
In SQL Server 2008, how can I get all the columns that are marked as nullable in their schemas even though no records contain NULL for those columns? Recreated this off the top of my head and realized there was one part of it I forgot to old-school-ify. Edited to replace usage of sys. views with INFORMATION_SCHEMA for better backward compatibility. |
|
Dec 20 |
answered | In SQL Server 2008, how can I get all the columns that are marked as nullable in their schemas even though no records contain NULL for those columns? |
|
Dec 20 |
comment |
In SQL Server 2008, how can I get all the columns that are marked as nullable in their schemas even though no records contain NULL for those columns? +1 for the elegance of the PIVOT solution, and for fully solving the problem |
|
Dec 20 |
awarded | Revival |
|
Dec 20 |
revised |
Empty Strings: Why or when is '' equal to ' '? Edited title to be more searchable. |
|
Dec 20 |
revised |
SQL Server 2008 R2 - How to check Foreign Key constraints in a transaction only when committed? Clarified title, improved grammar and spelling |
