August 15, 2011 at 10:23 am
GilaMonster (8/15/2011)
All that tech talk's reminded me I need to spec and order my new server.2TB internal storage and 1 TB external sound enough for now?
Double that. Never enough storage.
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
August 15, 2011 at 10:26 am
GilaMonster (8/15/2011)
Hmm, I can pick up 4 x 1 TB drives for around $300. RAID 5 config, 3TB internal. Should last for a while.Or I can get 4 x 1.5 TB drives for just under $400 for 4.5TB internal. The 2TB drives aren't cost-effective. 4 x 2TB drives would cost almost $900.
I'd go with the 1.5's.
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
August 15, 2011 at 10:44 am
Grant Fritchey (8/15/2011)
Anyone you need to check with to say nice things about Red Gate? Nope!
However, pass the word on how the presentation went, how many people attended, if there outstanding questions, we're always interested. Do you have any of my myriad email addresses?
Will do. And no, I don't - I realized I have your twitter id and run into you here, and that's about it. So a quick shout-out here was the easiest way to get your attention - I really should have just said "hey, RedGate people" instead of "Grant", considering the site... 🙂
-Ki
August 15, 2011 at 10:47 am
GilaMonster (8/15/2011)
Hmm, I can pick up 4 x 1 TB drives for around $300. RAID 5 config, 3TB internal. Should last for a while.Or I can get 4 x 1.5 TB drives for just under $400 for 4.5TB internal. The 2TB drives aren't cost-effective. 4 x 2TB drives would cost almost $900.
As I'm fairly paranoid about recoverability, including performance while recovering, I might go for 4 X 1.5TB in a RAID 10 config to give 3TB effective.
It does sound as if 2TB drives are too expensive, at least where you are (Amazon.com have 2TB SATA 3 drives at $99.99).
Tom
August 15, 2011 at 11:35 am
Kiara (8/15/2011)
Grant Fritchey (8/15/2011)
Anyone you need to check with to say nice things about Red Gate? Nope!
However, pass the word on how the presentation went, how many people attended, if there outstanding questions, we're always interested. Do you have any of my myriad email addresses?
Will do. And no, I don't - I realized I have your twitter id and run into you here, and that's about it. So a quick shout-out here was the easiest way to get your attention - I really should have just said "hey, RedGate people" instead of "Grant", considering the site... 🙂
IM already on the way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 16, 2011 at 3:29 am
Grant Fritchey (8/12/2011)
Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A product of the down tools week experimentation they allow at the company. Check it out.
Very useful little thing, but if you open an execution plan in XML (because I'm currently reading your SQL Server Execution Plans book) it raises an error when you go back to another tab. It doesn't crash anything so I'm sticking with it, but it doesn't appear to like the XML tabs. It sends an error report, so they may have suddenly seen a handful of these back at Redgate.
August 16, 2011 at 5:26 am
BrainDonor (8/16/2011)
Grant Fritchey (8/12/2011)
Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A product of the down tools week experimentation they allow at the company. Check it out.Very useful little thing, but if you open an execution plan in XML (because I'm currently reading your SQL Server Execution Plans book) it raises an error when you go back to another tab. It doesn't crash anything so I'm sticking with it, but it doesn't appear to like the XML tabs. It sends an error report, so they may have suddenly seen a handful of these back at Redgate.
I've actually found it to be quite buggy. But, it's a beta product. If you use it, send some feedback & then uninstall it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 16, 2011 at 6:48 am
Grant Fritchey (8/16/2011)
BrainDonor (8/16/2011)
Grant Fritchey (8/12/2011)
Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A product of the down tools week experimentation they allow at the company. Check it out.Very useful little thing, but if you open an execution plan in XML (because I'm currently reading your SQL Server Execution Plans book) it raises an error when you go back to another tab. It doesn't crash anything so I'm sticking with it, but it doesn't appear to like the XML tabs. It sends an error report, so they may have suddenly seen a handful of these back at Redgate.
I've actually found it to be quite buggy. But, it's a beta product. If you use it, send some feedback & then uninstall it.
Yes it is a bit buggy. I found another one last night. Try opening a maintenance plan. I'm converting a client from maintenance plans to Ola Hallengren's maintenance scripts and when I tryied to open a maintenance plan last night I got an error from SSMS. Uninstalled Tab Magic because I needed to see the maintenance plan and that was the only change to the sql environment on my laptop and then the maintenance plan opened.
I can totally understand how they missed things like execution plans and maintenance plans when developing something over a week. They were trying to save a query history (notice the error reporting message says SQL Query Keeper), and it evolved into a bit more with some things that use tabs being missed.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 16, 2011 at 7:30 am
Roy Ernest (8/16/2011)
We have a new Celko in the making. Yes, the SP he had was bad, but keep calling it a peace of garbage is not going to help the guy.
Oh, lovely. *shakes head* I'd love to see what he'd say about some of the legacy code I have to deal with. (An application API that *requires* "select * ..." in certain instances to work, anyone?) And he really ought to try performance tuning when the offending SQL queries are baked into an application and you can't get at them. Or...
I'll just take my little rant over in here to the corner now. Yes, I've been busily unraveling more code that can't possibly do what the author originally intended this morning, why do you ask? 🙂
-Ki
August 16, 2011 at 7:44 am
Roy Ernest (8/16/2011)
We have a new Celko in the making. Yes, the SP he had was bad, but keep calling it a peace of garbage is not going to help the guy.
No, Nabadan will never be a Celko; he may have all Celko's worst posting traits (in fact in my view he is even more gratuitously insulting than Celko), but at least Celko usually gives his reasons for his criticisms, whereas Nabadan gives none. I suspect he doesn't have anything like Celko's knoweledge or skill in the SQL field, either - I'm certainly not aware of his ever having demonstrated such knowledge or skill and I am aware of posts that suggest he is good at evasive bluster but not at anything useful or constructive (see for example his contributions to this topic).
Sean Lange's post was just as critical as Nabadan's, but it was also constructive and helpful and the contrast between the different reponses these two posts evoked from the OP is instructive.
Tom
August 16, 2011 at 2:10 pm
Just finished an article on Change tracking. I would love to have it reviewed by some of you. Anyone would like to take a peek at it?
PS : Just 99 posts to hit the big mile stone of 3000 posts. I never though I would come anywhere close to it. 🙂
-Roy
August 16, 2011 at 2:23 pm
Roy Ernest (8/16/2011)
Just finished an article on Change tracking. I would love to have it reviewed by some of you. Anyone would like to take a peek at it?PS : Just 99 posts to hit the big mile stone of 3000 posts. I never though I would come anywhere close to it. 🙂
send it my way
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
August 16, 2011 at 7:39 pm
Roy Ernest (8/16/2011)
Just finished an article on Change tracking. I would love to have it reviewed by some of you. Anyone would like to take a peek at it?PS : Just 99 posts to hit the big mile stone of 3000 posts. I never though I would come anywhere close to it. 🙂
Feel free to fire it my way.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 16, 2011 at 11:39 pm
Phew. Man, life is passing me by.
Just had our first Austin UG meeting at a new time yesterday. This is the city's 2nd meeting night each month to service the other half of the city (traffic is bad here). Slow startup. There were 9 there total; including me. T'was fun though. It'll take a few months for the word to get out. http://sqlwatchmen.com/blogs/jim/index.php/2011/08/user-group-meeting-location-picked/
Up late fighting with a VM and tons of Windows Updates. Flying to Dallas in the morning for the rest of the week to be on-site with a new client (yey). Now, if I could only get some sleep.....
Also, one of my larger DBA clients is doing a massive conversion from a dreaded SQL7 install (325GB DB) to a totally new vendor app, SQL2008, all new Crystal Reports, etc. A 2 year effort and the conversion finally began late in July. Wall-To-Wall meetings and activities to ensure everything is converted successfully. Man, what a huge amount of time this is. It'll be great to kick SQL7 to the curb after all these years though. Buh-bye!
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
Viewing 15 posts - 29,071 through 29,085 (of 66,749 total)
You must be logged in to reply to this topic. Login to reply