Wow! How's that for a recap? The concept for the SQL in the City events is pretty simple. Put on a free event that instructs people on SQL Server, Azure, and related technologies along with a healthy smattering of Red Gate tools. All teaching is done by some of the best people in the business (and me). This was the second event in London. The concept was launched there last year and succeeded quite well. This year the event filled it's registrations so quickly that Red Gate felt obligated to have a second day, which almost completely filled up too. There were more than 350 people in attendance on Friday, and then, on Saturday, a day off, another 250+ people showed up. That's well over 600 attendees over the two…
When you execute a multi-statement user-defined function you may see an execution plan that looks something like this: It appears as if the cost of the UDF is free. This is especially true if you use the UDF in a query with other objects, such as joining it to actual tables. Since the optimizer always assumes a multi-statement UDF has a single row for statistics estimates, it' frequently displays a low cost. But you know that there’s more going on there, right? It’s a multi-statement UDF because it’s doing a lot of work, but that is not reflected in the execution plan.. or is it? What if we went after the cache? Let’s run this little query: SELECT deqp.query_plan, dest.text, SUBSTRING(dest.text, (deqs.statement_start_offset / 2) + 1, (deqs.statement_end_offset - deqs.statement_start_offset) /…
Gee thanks Jes (blog|twitter). Just what I wanted, a little extra work on a Friday afternoon. I used to like you. We have a tagging theme started by Ted Krueger (blog|twitter) who I also used to like. The theme is: Deciding that I need to delete and start all over Lordy I hate this one. See, I find it easy to decide that I need to delete and start all over. My challenging task is persevering. But… here’s the rub. Because my challenge is persevering, I have a tendency to try to persevere when I really should be throwing in the towel. I don’t have a technical example of this ready at hand (I did mention it was the afternoon on a Friday, right?), but I do have a presentation…
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the plane to leave because you can no longer stand. That’s where I was on Saturday. I’m going to go ahead and write down a few thoughts about the Summit, but I want to point you over to Andy Leonard’s (blog|twitter) blog for what is a truly great summary. I won’t blame you if you read that & skip this. Still here? This year the Summit was amazing. I think it’s probably the best run Summit I’ve attended. From registration on Sunday night, to the final sessions on Friday, everything was dealt with in a timely and professional fashion that made the place a joy to attend. Huge kudos to the…
This is Day 2 of the Summit proper. But for me, this is the fifth day of the Summit and my sixth in Seattle. Sunday was the opening of registration and it was like a high school reunion with people that you really love. Registration itself only takes about three minutes, but I was there for almost two hours talking to people, friends from previous PASS Summits, SQL Saturday’s, SQL Cruise, and SQL In The City. Monday I put on a pre-conference seminar with Gail Shaw. We had 120 attendees. Despite our worries and multiple contingency plans, we had more than enough material for the time (you try coordinating 7 hours of material with someone from South Africa who has less band width than my phone). It went off wonderfully.…
Hello again. The PASS Organization has once more allowed me to sit at the bloggers table for the key note. I’ll be posting updates as the information unfolds. [8:06] The crowd is filling in. this looks like one of the biggest crowds I’ve ever seen at the summit. The organizers have done a great job so far. Thanks for all the hard work guys. [8:10] SQUEEEEE! I just met Dr. David Dewitt and got a picture with him. I’ll post it after I get home and find the cable. [8:22] Watching the videos of different people on the big screen talking about what they like about the PASS Summit is really cool. [8:26] Rushahb Mehta is introducing the board and the Partners of the PASS board. We now have a…
The first ever SQL Rally was held just last week. It was an excellent time. The event was organized and run by PASS. Which means, in effect, it was a like a mini-Summit. I’m struggling a bit to come up with the words to describe what the event was like. It was so much more than a long SQL Saturday, but describing it, as I just did, as a mini-Summit mischaracterizes it as well. I guess it must be it’s own critter. Let me just tell you what went on, maybe that will help. The event was held at a very nice hotel, the Marriott World in Orlando, Florida. The Rally proper was two days long, but there was a set of pre-conference seminars held the previous day, making the…
Tom LaRock has a new meme for Meme Monday. It’s all about the problems caused in your system other than disks. Thankfully, despite the title, I don’t have to list 99 separate things, only 9, but you know what, 99 is possible. I’m going to present the problems. You find the solutions on your own today. Let’s go. Recompiles I’ve seen queries so big that they take more than three minutes to compile. That’s the edge case, but as an edge case it is educational. The most important thing to remember about recompiles is that they are driven by data changes. Once a threshold is reached on any given set of statistics, all queries referencing that set of statistics gets marked for recompile. The key words and tricky phrase here…
Greetings. Welcome once more to the Miskatonic University branch of SQL University. Does anyone know where to buy some camping equipment, cheap? I’ve been tagged to go an expedition to Antarctica and I need some cold weather gear a bit more substantial than my LL Bean boots. Evidently the last expedition found some caves in some mountains down there. Sounds like the perfect place to get away from all the crazy stuff that goes on here at Miskatonic. I mean, what could happen? Anyway, our last several talks have all been about indexes and indexing. One of the things that we haven’t talked about is how to tell if, how or when your indexes are being used. Starting with SQL Server 2005, and continuing to 2008 and R2, there has…
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become so poor that outright hostility between the groups is common. At the end of the day we are all working towards a common goal, to add value to whatever organization we are working for. It's a shame that we all lose sight of this commonality and create such a false dichotomy between the groups. I think there are some ways that we, as database specialists, can use to attempt to cross that gap. Prior to being suborned to the dark side, I was a developer. I had a little over 10 years experience working in VB, Java & C#. I remember, distinctly, cursing our database team for being so problematic…