September 14, 2014 at 6:53 pm
Lynn Pettis (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Sounds awesome. Glad you were able to attend a SQL Saturday. I have managed to attend three so far, two in Colorado Springs and one in Denver. I am hoping to be able to attend others in nearby states when I return home from Afghanistan.
When are you coming home? Do you still have a job when you arrive? The last thing I remember was that it was in jeopardy upon your return.
September 14, 2014 at 8:26 pm
Ed Wagner (9/14/2014)
Lynn Pettis (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Sounds awesome. Glad you were able to attend a SQL Saturday. I have managed to attend three so far, two in Colorado Springs and one in Denver. I am hoping to be able to attend others in nearby states when I return home from Afghanistan.
When are you coming home? Do you still have a job when you arrive? The last thing I remember was that it was in jeopardy upon your return.
Well, that depends. I am seriously considering another extension of 6 months (and it would be my last) and talking with our Theater Tech Lead it looks like that would have a very good possibility of being approved. At the same time as he told me that he also said the Director of Field Services is still working on trying to get me a plant position back home in Field Services (my original position was in the Government Engineering Services Division).
Makes me feel good that someone high up in the company wants to keep me in the company. No guarantees, of course, but it would make things easier to come home with a job instead of looking for one.
The reason this would be the last extension out here is I made another commitment when I came out here. I want to home for my youngest daughters senior year of high school. The extra 6 months out here will give me the money to stay in Colorado Springs until she graduates even if I don't find a job right away without dipping into the money I am saving to help pay for college for the younger two.
September 15, 2014 at 3:43 am
GilaMonster (9/14/2014)
Sometimes advice on a blog still scares me. Not often, but sometimes. Like todayConsider using a RAMDisk for Index filegroups.
Putting non-clustered indexes on a RAMDisk will greatly improve performance
Be absolutely sure that your RAMDisk either backs itself up to disk, or at least saves and loads itself from a real disk on shutdown and startup.
This can significantly increase shutdown/startup/reboot times.
I also recommend doing regular SQL backups of these filegroups.
If the system crashes, recovering the database becomes a lot harder. Which is why backups are very important.
Crikey. I haven't encountered RAM disks since Windows 3.11/Dos 6.
How does RAM measure up to SSD's in £/GB these days?
September 15, 2014 at 6:00 am
Good Lord... RAMDisk for Indexing? Are they stupid? I have no words.
Gazareth (9/15/2014)
GilaMonster (9/14/2014)
Sometimes advice on a blog still scares me. Not often, but sometimes. Like todayConsider using a RAMDisk for Index filegroups.
Putting non-clustered indexes on a RAMDisk will greatly improve performance
Be absolutely sure that your RAMDisk either backs itself up to disk, or at least saves and loads itself from a real disk on shutdown and startup.
This can significantly increase shutdown/startup/reboot times.
I also recommend doing regular SQL backups of these filegroups.
If the system crashes, recovering the database becomes a lot harder. Which is why backups are very important.
Crikey. I haven't encountered RAM disks since Windows 3.11/Dos 6.
How does RAM measure up to SSD's in £/GB these days?
September 15, 2014 at 6:18 am
Gazareth (9/15/2014)
GilaMonster (9/14/2014)
Sometimes advice on a blog still scares me. Not often, but sometimes. Like todayConsider using a RAMDisk for Index filegroups.
Putting non-clustered indexes on a RAMDisk will greatly improve performance
Be absolutely sure that your RAMDisk either backs itself up to disk, or at least saves and loads itself from a real disk on shutdown and startup.
This can significantly increase shutdown/startup/reboot times.
I also recommend doing regular SQL backups of these filegroups.
If the system crashes, recovering the database becomes a lot harder. Which is why backups are very important.
Crikey. I haven't encountered RAM disks since Windows 3.11/Dos 6.
How does RAM measure up to SSD's in £/GB these days?
It's not the cost that is the concern. It's the durability. If the RAMDisk doesn't write back to durable storage before the server shuts down (ie, uncontrolled shutdown), the database, or at least the index filegroups, would have to be restored from backup before the DB would be usable again.
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
September 15, 2014 at 7:07 am
Lynn Pettis (9/13/2014)
SQLRNNR (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Rub it in. Rub it in.
That is one way to do BBQ. 😉
The only way for me.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 15, 2014 at 7:16 am
Sean Lange (9/15/2014)
Lynn Pettis (9/13/2014)
SQLRNNR (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Rub it in. Rub it in.
That is one way to do BBQ. 😉
The only way for me.
I'm waiting for the arrival of my new smoker. It's just a shame my birthday is at the end of September so the first few runs are almost certainly going to be done in the rain.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
September 15, 2014 at 7:16 am
Ed Wagner (9/14/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Good job, Sean. Other than the food, did you have fun?
Yeah it was pretty cool. The thing I found a little strange was some of the sessions I attended were marked "advanced" but were really basic. I would have chosen to attend a couple of different choices if I had known the discussion was going to be so shallow. Definitely planning on going again next year and may try to make it to a couple of others that aren't too far away.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 15, 2014 at 7:22 am
BWFC (9/15/2014)
Sean Lange (9/15/2014)
Lynn Pettis (9/13/2014)
SQLRNNR (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Rub it in. Rub it in.
That is one way to do BBQ. 😉
The only way for me.
I'm waiting for the arrival of my new smoker. It's just a shame my birthday is at the end of September so the first few runs are almost certainly going to be done in the rain.
What kind did you get?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 15, 2014 at 7:27 am
Sean Lange (9/15/2014)
BWFC (9/15/2014)
Sean Lange (9/15/2014)
Lynn Pettis (9/13/2014)
SQLRNNR (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Rub it in. Rub it in.
That is one way to do BBQ. 😉
The only way for me.
I'm waiting for the arrival of my new smoker. It's just a shame my birthday is at the end of September so the first few runs are almost certainly going to be done in the rain.
What kind did you get?
I've currently got a cheapo bullet smoker but it just doesn't get hot enough. I'm awaiting a (cheap) offset smoker. Hopefully it'll have better ventilation and control and it should get up to temperature and stay there.
I know it shouldn't be too hot but my old one barely scraped to 70oC. It actually went out if you took your eye off it for more than a few minutes.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
September 15, 2014 at 7:31 am
Sean Lange (9/15/2014)
Ed Wagner (9/14/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Good job, Sean. Other than the food, did you have fun?
Yeah it was pretty cool. The thing I found a little strange was some of the sessions I attended were marked "advanced" but were really basic. I would have chosen to attend a couple of different choices if I had known the discussion was going to be so shallow. Definitely planning on going again next year and may try to make it to a couple of others that aren't too far away.
Rating sessions is impossible. I usually set my at the 200-300 level and I constantly get complaints that it was too advanced/simple. I usually take that to mean that I got it just right. But simple for you might be advanced for others. It's so hard to get those right. Just assume if Connor Cunningham, Bob Ward or Paul White is speaking, it's advanced. Everyone else is a gamble.
"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
September 15, 2014 at 7:32 am
BWFC (9/15/2014)
Sean Lange (9/15/2014)
BWFC (9/15/2014)
Sean Lange (9/15/2014)
Lynn Pettis (9/13/2014)
SQLRNNR (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Rub it in. Rub it in.
That is one way to do BBQ. 😉
The only way for me.
I'm waiting for the arrival of my new smoker. It's just a shame my birthday is at the end of September so the first few runs are almost certainly going to be done in the rain.
What kind did you get?
I've currently got a cheapo bullet smoker but it just doesn't get hot enough. I'm awaiting a (cheap) offset smoker. Hopefully it'll have better ventilation and control and it should get up to temperature and stay there.
I know it shouldn't be too hot but my old one barely scraped to 70oC. It actually went out if you took your eye off it for more than a few minutes.
Yeah low and slow is good but that is nowhere near warm enough. You want it around 225- 250F (107 - 121C).
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 15, 2014 at 7:37 am
Sean Lange (9/15/2014)
BWFC (9/15/2014)
Sean Lange (9/15/2014)
BWFC (9/15/2014)
Sean Lange (9/15/2014)
Lynn Pettis (9/13/2014)
SQLRNNR (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Rub it in. Rub it in.
That is one way to do BBQ. 😉
The only way for me.
I'm waiting for the arrival of my new smoker. It's just a shame my birthday is at the end of September so the first few runs are almost certainly going to be done in the rain.
What kind did you get?
I've currently got a cheapo bullet smoker but it just doesn't get hot enough. I'm awaiting a (cheap) offset smoker. Hopefully it'll have better ventilation and control and it should get up to temperature and stay there.
I know it shouldn't be too hot but my old one barely scraped to 70oC. It actually went out if you took your eye off it for more than a few minutes.
Yeah low and slow is good but that is nowhere near warm enough. You want it around 225- 250F (107 - 121C).
I definitely got what I paid for. The last time I used it I just ran it for a couple of hours to get some flavour in to the meat and then finished it in the oven. Cheating horribly I know but it was either that or starve.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
September 15, 2014 at 7:38 am
Grant Fritchey (9/15/2014)
Sean Lange (9/15/2014)
Ed Wagner (9/14/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Good job, Sean. Other than the food, did you have fun?
Yeah it was pretty cool. The thing I found a little strange was some of the sessions I attended were marked "advanced" but were really basic. I would have chosen to attend a couple of different choices if I had known the discussion was going to be so shallow. Definitely planning on going again next year and may try to make it to a couple of others that aren't too far away.
Rating sessions is impossible. I usually set my at the 200-300 level and I constantly get complaints that it was too advanced/simple. I usually take that to mean that I got it just right. But simple for you might be advanced for others. It's so hard to get those right. Just assume if Connor Cunningham, Bob Ward or Paul White is speaking, it's advanced. Everyone else is a gamble.
I can only imagine how hard it would be to rate them. The one that comes to mind was one marked as advanced and in the first two minutes the speaker said "this is not going to be a deep dive and is a topic I enjoy and am still learning about".
I attended the Bob Ward presentation about troubleshooting sql server memory. The first half was really interesting and I learned a ton. By about half way through he started sounding like the teacher from Peanuts and I snuck out to get a refill of coffee. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 15, 2014 at 7:41 am
BWFC (9/15/2014)
Sean Lange (9/15/2014)
BWFC (9/15/2014)
Sean Lange (9/15/2014)
BWFC (9/15/2014)
Sean Lange (9/15/2014)
Lynn Pettis (9/13/2014)
SQLRNNR (9/13/2014)
Sean Lange (9/13/2014)
Woo Hoo!!! I was able to find a coach to fill in for me today and I was able to attend my first SQL Saturday. The place is almost an hour from my house so I didn't make it in time for Steve's session at 8:30 but was able to meet up with him for a little bit in between sessions. Was good to finally get a chance to meet in person. Lunch was a bbq buffet and there was plenty for seconds. 😀Rub it in. Rub it in.
That is one way to do BBQ. 😉
The only way for me.
I'm waiting for the arrival of my new smoker. It's just a shame my birthday is at the end of September so the first few runs are almost certainly going to be done in the rain.
What kind did you get?
I've currently got a cheapo bullet smoker but it just doesn't get hot enough. I'm awaiting a (cheap) offset smoker. Hopefully it'll have better ventilation and control and it should get up to temperature and stay there.
I know it shouldn't be too hot but my old one barely scraped to 70oC. It actually went out if you took your eye off it for more than a few minutes.
Yeah low and slow is good but that is nowhere near warm enough. You want it around 225- 250F (107 - 121C).
I definitely got what I paid for. The last time I used it I just ran it for a couple of hours to get some flavour in to the meat and then finished it in the oven. Cheating horribly I know but it was either that or starve.
I wouldn't call that cheating. It is just using what you have available. I got a new smoker this summer. It was super cheap and runs on propane and has a tray for wood chips. I can cook as good on that one as I can on any of the full sized smokers I have ever used.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 45,646 through 45,660 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply