Browse by Tags
» Performance (RSS)
Showing page 2 of 4 (31 total posts)
When you're developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming?
I know that I did just that, for years. It wasn't until I was trying to performance tune some existing code that I realized I hadn't actually taken caching of data and execution plans into account. So all those modified ...
First off - the Pain of the Week webcast series has been renamed. It's now known as The Expert's Perspective.
Please join us for future webcasts and, if you're interested in
speaking, drop me a note to see if we can get you on the roster!
bigger your databases get, the longer backups take. That doesn't really
seem like a ...
Several attendees at the SQLRally were asking about NoSQL (''Not Only SQL'') and its benefits. This article gives a quick overview: HERE.
Also, two good resources have come out from my friend Guy Harrison. This piece on Cassandra, one of the most popular NoSQL databases, was published a while back in Database Trends and Applications Magazine. I ...
Interested in my various performance tuning and troubleshooting
videos about SQL Server? These videos feature my good buddies (and
uber-SQL Server experts) Brent Ozar (blog | twitter) and Buck Woody (blog | twitter).
View these insight-packed training videos from our SQL Server training
events originally presented on ...
I first wrote about Mladen Prajdic's excellent tool in my Tool Time column at SQL Server Magazine HERE. The tool is a nice plug-in to SSMS and definitely worth having.
If you’ve never installed it or have only installed an older version, but sure to pick up the newest release. Here’s Mladen’s press release complete with hyperlink for the ...
I profiled Adam Machanic's (blog | twitter)
excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in
my monthly SQLMag column, Tool Time. Adam has been diligent about
maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
One of the things that I enjoy about working for Quest Software is that we give back copiously to the community. From activities and offerings like SQLServerPedia, to our free posters mailed anywhere in North America (and don't forget the free hi-res PDFs for the rest of the world),
Don't forget that free DVDs of our virtual conferences ...
I first wrote about useful database maintenance scripts on my SQLBlog account way back in 2008. Hmmm - now that I think about it, I first wrote about my own useful database maintenance scripts in a journal called SQL Server Professional back in the mid-1990's on SQL Server v6.5 or some such. But I digress...
Anyway, I pointed out a couple ...
Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA. Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin. You can see the recording and slide deck here. Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had ...
Law tells us that CPU's get a LOT faster over time. Unfortunately
for the database professional, all of the secondary elements of our
databases DO NOT get a lot faster over time. Overall, the main methods
of storing data since the 1960's, magnetic tape and hard disks, have
improved only in the single percentiles year ...