Well, he did it again, and I got tagged by Denny and Tim (who apparently does not read or subscribe to Denny’s blog). So I thought I should answer the bell and post a response, then tag someone else. The question at hand is: What are the largest challenges that you have faced in your … Read more
So there I am, eating some meat pie for lunch, thinking about how much better it would be if it had some bacon, when I perform a very common task that results in a very uncommon error. Well, uncommon for me at least. I went to display the estimated execution plan for a stored procedure … Read more
Thanks for getting back to me. I know that you want this relationship to work as much as I do, and that we can get through any problem if we work together. So what if you create your own databases on the C: drive, we can fix that. And I love how you go out … Read more
Quick quiz: what causes deadlocks? No, no, no. Keep your answers simple. Here, choose from these two options: 1. MS SQL Server, or 2. Applications designed to run on MS SQL Server There, that should make things easy. Can we all agree that MS SQL Server … Read more
Please refrain from deciding where to place databases upon install. I have already configured a default data and log directory. If you really feel the need to create databases upon your installation, then just accept the default locations I have configured. I can appreciate your application going out of its way to help, I really … Read more
Opened up SQL 2008 Management Studio. Double-click on a job, up pops the Job Properties screen. So far, so good. Go to the step properties, up pops another window, all still good. Next, hit CRTL-A and get beeped. WTF? I have to right-click in order to do a select all? No keyboard shortcut? I see … Read more
