Viewing 15 posts - 1,996 through 2,010 (of 3,669 total)
Given SQL 2005/2008 would you recommend the same solution, use a filtered index, or something else?
I think I would still stick with the queue table for the reasons mentioned earlier.
My...
February 10, 2010 at 12:30 pm
I didn't use a filtered or nonclustered index on the base table for two reasons.
1. The original solution was on SQL2000.
2. The main table had incredibly heavy read activity on...
February 10, 2010 at 10:59 am
If you look throught he source of the built in system stored procs you will see quite a few cases of IF(SELECT COUNT(*)...)>0
Try sp_helptext 'sp_helptext' for an example!
February 10, 2010 at 4:52 am
When I worked for McCann-Erikson they classified people into 4 segments analogous to the part of a printed advert. It was exactly the same thing as the Introvert/Extrovert Vs...
February 7, 2010 at 4:35 pm
Has anyone noticed that the old system stored procs are not that efficient?
IF(SELECT COUNT(*) FROM ...) >0:w00t:
Cursors all over the place etc.
February 4, 2010 at 1:41 pm
If you have separate instances then you can of course use sp_configure to specify a maximum amount of memory for each instance.
You can also specify which CPUs get used by...
February 2, 2010 at 3:33 pm
Add memory to the physical box and set up virtual servers rather than separate instances.
February 1, 2010 at 5:29 am
Probably a daft question but you are running the proc in the correct database?
January 6, 2010 at 10:30 am
When I've used DBMail to send reports I've formatted numbers as VARCHAR just to get the email format looking nice.
The problem comes when someone wants to use the views for...
December 31, 2009 at 10:46 am
One trick I found if I want to improve query performance where I need to query a character field larger than 900 bytes is to have a column that holds...
December 30, 2009 at 11:42 am
Where you have sysobjects.object_id it should be sysobjects.id
It looks as if someone has tried to translate the use of the system views in SQL2005/SQL2008 into the legacy tables and forgotten...
December 30, 2009 at 10:54 am
James Stover (12/27/2009)
I'll go one further - I don't think it's acceptable to have service packs.
Brave statement. I'm pretty rigorous when writing code but I doubt that even...
December 28, 2009 at 4:00 am
I think of SQL Server/Oracle the way I think of BMW/Mercedes et al. I am paying a premium price for something that comes with certain quality expectations.
Part of those...
December 27, 2009 at 4:02 pm
Personally I liked the original code name "Gemini".
When IT doesn't support the business those non-IT parts of the business that are computer savvy design and build their own tools an...
December 21, 2009 at 2:15 pm
One of the problems I found when switching to agile development practises was getting the non DB development team to accept architectural principles from the DB perspective.
The good architects tend...
December 21, 2009 at 2:02 pm
Viewing 15 posts - 1,996 through 2,010 (of 3,669 total)