Browse by Tags
All Tags »
SQL Server 2000 »
Miscellaneous (
RSS)
But in my job I have to wear the DBA hat quite often. I was having a problem today where a query that returns 200 rows was taking 16 seconds to return to my application. The same query run in Query Analyzer came back in .47 seconds. Huh? One of my co...
Hat's off to Chris Hammond for making public the Visual Studio 2005 Launch Event. I'll be going to the one in Atlanta.
I was having trouble connecting to a remote SQL Server instance using Windows Authentication. I was getting the apparently famous "Not a Trusted Connection" error, (apparently famous because of the number of results google turned up) but none of the standard...
I was trying to test the PDF export generated by Sql Server Reporting Services, but I couldn't get the pdf documents to open. It wasn't just the pdf documents generated by reporting services--I couldn't open any pdf at all. I tried the uninstall/reinstall...
Michael Kaplan has a great post on how to make sorted views performant. His post was essentially a response to my previous post on why you shouldn't use ORDER BY statements in views. Michael shows how to make it work. Thanks Michael!
Don't put ORDER BY Statements in Views. Delay sorting until you're actually about to use the data. If you end up sorting differently than the default sort specified by the ORDER BY in the view, it comes as an expensive performance hit. Witness a stored...
Nice blog from David Mauri on explaining the importance of a Data Access Layer.
I have a client-server application that uses SQL Server 2k as the backend. One of the things that I have done successfully is to require that all applications access the database via stored procedures. I don't have any grant permissions on any tables...
The VS Data Team has a new blog on Database Projects. I've written before about things I'd like to see made better in the database projects and Visual Data Tools, but here is how I'm leveraging them now to manage our projects now. The projects I've been...
This week has been an exercise in working around holes in other people's tools. I am using InstallShield 10.5 Pro to create an msi to deploy an intranet ASP .NET application and the associated database. I want the installation to be smart enough to remove...
More Posts
Next page »