Why Tune Queries?
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
2,997 reads
It’s just a query against the database. If things are running slow, buy some more memory, a faster CPU or...
2012-10-17 (first published: 2012-10-15)
2,997 reads
I’m working through some code that I haven’t touched recently and I’m running it for the first time on a...
2012-10-16
1,466 reads
I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...
2012-09-26 (first published: 2012-09-24)
3,350 reads
Yeah, it’s that time again. And we have a magnificent slate of people running. I mean truly amazing and wonderful...
2012-09-21
701 reads
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
969 reads
When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.
2012-09-13
6,233 reads
Just so we’re clear, I use SQL Server. I like SQL Server. But, this doesn’t mean I have anything against...
2012-09-07
5,017 reads
I presented a session at the SQL Saturday event in Oklahoma City last weekend. The event itself was pretty good....
2012-08-28
1,280 reads
I should know. I was one of the judges of this year’s Exceptional DBA of the Year award. I had...
2012-08-28
1,008 reads
A couple of weeks ago I posted about how different execution plans look when using the Azure Management Portal. I...
2012-08-23 (first published: 2012-08-20)
1,900 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers