Viewing 15 posts - 20,011 through 20,025 (of 22,202 total)
Gail is on the money here, totally.
Instead of trying to avoid having multiple queries, accept the fact that you will have multiple queries and then get some code to generate...
July 8, 2008 at 6:26 am
Posting the execution plan would help in the evaluation. Not seeing your structure and only seeing a query, we're all limited to making guesses.
July 8, 2008 at 6:23 am
GilaMonster (7/8/2008)
"We fixed it. No thanks to you."
I can't honestly say that I wouldn't have hit the guy. Nice exercise in restraint.
July 8, 2008 at 5:28 am
9 months at a start-up run by Harvard grads who's operating phrase was "Think Outside The Box." This extended to every single part of the company. One of the more...
July 7, 2008 at 1:27 pm
It depends on the context that it's running under. If you're running it in a query window, it probably will return NULL.
Try this:
CREATE PROCEDURE ProcName
AS
SELECT OBJECT_NAME(@@PROCID);
GO
EXEC [ProcName];
You should see 'ProcName'...
July 7, 2008 at 1:08 pm
Thanks for reminding me. That helped.
🙁
Crap! That was seven years ago.
July 7, 2008 at 12:13 pm
Like everyone else, I'd suggest starting small. The best way I found to convince someone of the need to normalize was to find data that was messed up and by...
July 7, 2008 at 11:25 am
I got that old feeling last year when Joey Ramone died... Now it's starting to feel like a conspiracy. I wasn't really a fan of Aspirin, but the others... This...
July 7, 2008 at 11:21 am
I've been very happy with ER/Studio, but we mainly use it for documentation. All the management stuff that comes with it haven't worked out for us.
July 7, 2008 at 10:33 am
Actually no, it's not that weird. The optimizer and the query engine are pretty amazing pieces of engineering. They're able to identify that you only need a single row returned...
July 7, 2008 at 9:03 am
The key problem is, desiging, building and deploying software is still not an act of engineering like building a car, a toaster or a bridge. As Steve pointed out in...
July 7, 2008 at 8:46 am
I outlined a way to hook stuff out of the cached execution plans over here. It's not magic or anything, but you're going to have a tough time assessing what's...
July 7, 2008 at 7:34 am
OK. I'm stumped. I tried mucking with the indexes and loading the data into a temp table. The temp table fixed the query time on the sort, but it took...
July 7, 2008 at 7:25 am
You'd have to show sample code and structure (and preferably some sample data) in order to get really detailed help.
Read this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D
July 7, 2008 at 6:50 am
Viewing 15 posts - 20,011 through 20,025 (of 22,202 total)