March 8, 2010 at 9:32 am
Paul White (3/8/2010)
Grant Fritchey (3/8/2010)
Every time I get these "Hey, let's build a database that doesn't have referential integrity/indexes/normalization/mirrors our objects/only stores unstructured data/etc, I honestly try to convince them that they don't need a database. It's so weird. "We want a DB that behaves just like a flat file." Then why don't you just use a flat file? "Oh, but we have to have a database" Why?I have a bad reputation at work.
:laugh:
I can relate. If I had $1 for every time someone had said, "We just need something quick and dirty - you can do your flash database stuff later"...
So an engineer works with software company to get some enhancements to their testing software we use....
Software company does almost everything in tempDB, and uses a stored proc to write 1 summary table.
Engineer asks me to create Excel report, 95 columns wide, off 1 summary table. This comes about after his own IT guy runs into roadblocks.
After I look at engineer's excel mock up, printed landscape on 4 11X17 pages, I go 'so what do you expect to see out of the data?'
Out comes all kinds of different scenarios. None of which match the excel mock up. And admission that the Excel really isn't very useful.
And then comes the best one - there is a whole line of tests not even in the sample db.
At least this one had a db course or 2 in college, and could understand why it might be rather difficult to do much with only the summary table in place. And why although varchar is flexible, maybe splitting things up into some additional tables would be helpful.
Greg E
March 8, 2010 at 9:34 am
CirquedeSQLeil (3/8/2010)
Anybody here have an idea on this one?
Someone being stupid. I'd say set it back to 90 immediately.
It can be done, just ran this on my SQL 2008 instance
ALTER DATABASE master SET COMPATIBILITY_LEVEL = 80
Command(s) completed successfully.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2010 at 9:49 am
Grant Fritchey (3/8/2010)
I thought MCP was Main Coolant Pump.
In my line of work, it's Managed Care Plan
ILT (I Love TLA's (Three Letter Acronyms)) (is that recursion? :hehe:)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 8, 2010 at 10:20 am
GilaMonster (3/8/2010)
CirquedeSQLeil (3/8/2010)
Anybody here have an idea on this one?Someone being stupid. I'd say set it back to 90 immediately.
It can be done, just ran this on my SQL 2008 instance
ALTER DATABASE master SET COMPATIBILITY_LEVEL = 80Command(s) completed successfully.
Thanks - I just tested and agree. I was on my way out the door and couldn't do it earlier.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2010 at 10:29 am
Alvin Ramard (3/8/2010)
CirquedeSQLeil (3/8/2010)
I just realized the true term for what the Thread should be called.MCP (Master Control Program).
When it comes to the thread, MCP could stand for: Multiple Crappy Postings.
"Unauthorized user access detected - this program is being terminated"
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 8, 2010 at 10:34 am
Matt Miller (#4) (3/8/2010)
Alvin Ramard (3/8/2010)
CirquedeSQLeil (3/8/2010)
I just realized the true term for what the Thread should be called.MCP (Master Control Program).
When it comes to the thread, MCP could stand for: Multiple Crappy Postings.
"Unauthorized user access detected - this program is being terminated"
Awesome - avatar and the whole works. You could tune that program just a bit by changing your alias to MCP. 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2010 at 10:51 am
CirquedeSQLeil (3/8/2010)
I just realized the true term for what the Thread should be called.MCP (Master Control Program).
Okay, that took me back to my Burroughs days as a computer operator... 😉
March 8, 2010 at 10:52 am
And the vague question of the week award goes to
....
...
<drum roll>
...
....
http://www.sqlservercentral.com/Forums/Topic878772-1292-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2010 at 10:56 am
Lynn Pettis (3/8/2010)
CirquedeSQLeil (3/8/2010)
I just realized the true term for what the Thread should be called.MCP (Master Control Program).
Okay, that took me back to my Burroughs days as a computer operator... 😉
Heh...New Tron is coming out in December - and the old Tron is what sparked the memory for me.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2010 at 10:58 am
GilaMonster (3/8/2010)
And the vague question of the week award goes to....
...
<drum roll>
...
....
http://www.sqlservercentral.com/Forums/Topic878772-1292-1.aspx
Psychic helmet was on for that one. 😀 I like to change my Script Editor colors in SSMS too.:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2010 at 11:02 am
I stared at that for a while before realising what he wanted.
Only time I ever change fonts is when I'm doing presentations. Other than that I only typically change tab settings
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 8, 2010 at 11:19 am
The default white background causes too much glare. It is easier for me to look at a black background. For presentations, I stick with the default colors though (increase text size substantially).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2010 at 11:35 am
Of Topic...
On an average how many people attend SQLSaturdays?
-Roy
March 8, 2010 at 11:41 am
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
Good question.
I think this last one hit 1000.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 8, 2010 at 11:56 am
CirquedeSQLeil (3/8/2010)
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
Good question.
I think this last one hit 1000.
That would depend on where it's being held. We've been thinking about hosting one in Memphis, targetting 100-200 attendees.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 15 posts - 12,286 through 12,300 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply