Viewing 15 posts - 271 through 285 (of 470 total)
SQL can more easily optimize inline functions. If you're running it against a table a multi-line function needs to get called once for each row. An inline function...
July 19, 2011 at 2:23 pm
What's the load on the server? On the network?
Is the query returning a lot more data than it was before?
Is there any blocking going on?
July 19, 2011 at 2:18 pm
Only so much of this can be automated. You also need to look for things that reference views or stored procs because there could be a restriction down the...
July 19, 2011 at 2:13 pm
I've taken the same attitude when interviewing. I don't want to go through six jobs in eight years so I'll find out as much as I can during the...
July 19, 2011 at 1:28 pm
Revenant (7/19/2011)
July 19, 2011 at 8:58 am
andreas.agren (7/19/2011)
Watch before you form alliances? Sounds a lot like prison to me.
I think all he's trying to get to is know who you're getting close to. If there's...
July 19, 2011 at 8:24 am
bopeavy (7/18/2011)
July 18, 2011 at 1:27 pm
What are looking for the sessionID for? sys.dm_os_query_stats is historical data so there may not be a query running at the current time. If you let us know...
July 18, 2011 at 12:44 pm
Jayanth_Kurup (7/17/2011)
July 18, 2011 at 7:18 am
Thomas Abraham (7/15/2011)
Seriously, I'm only posting this to get the point back for having had a correct answer marked incorrect. 😉
My bet is that Steve knows who answered what and...
July 15, 2011 at 6:52 am
I'm glad you've never been bitten by that. From working on a dev project where updates and inserts for a table came from multiple locations and there were probably...
July 14, 2011 at 7:53 am
The last application I worked on had some DRI but a lot that wasn't. Personally, dealing with the headaches that came from references that weren't declared (and seeing headaches...
July 14, 2011 at 6:46 am
OPTION (RECOMPILE) is to be only used as a temporary measure while a process for converting adhoc T-SQL code to Stored Procedures is underway.
I'm not sure I agree with this....
July 7, 2011 at 10:26 am
If option recompile is used the plan doesn't remain in cache so it won't lead to cache bloat. Disclaimer, don't run this in production.
dbcc freeproccache
go
select * from msdb.dbo.sysjobs option...
July 7, 2011 at 10:17 am
We log but don't regularly look at the backup growth size. We pay more attention to the amount of free space on disk. We're working on getting a...
July 7, 2011 at 7:59 am
Viewing 15 posts - 271 through 285 (of 470 total)