Viewing 15 posts - 1,951 through 1,965 (of 3,616 total)
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
As far as I am concerned encryption and data security should be present in all editions.
I can understand the lesser editions having limits on CPU and RAM they can use.
I...
December 21, 2009 at 1:55 pm
robert.goudie-497430 (12/18/2009)
BTW we still use DTS - despite having several books at work on SSIS that our key people have read at one point or another.
Thus far we have found...
December 20, 2009 at 9:49 am
The article was mainly about standard edition.
The killer feature for enterprise users is the ability to switch partitions on replicated tables. This means that with careful design the purge...
December 18, 2009 at 2:42 am
The point has been made that many DBAs know these procs and have used them for years.
Great, so why doesn't Microsoft include them in BOL?
They are stable and have survived...
November 20, 2009 at 4:31 pm
If it is for a development environment, then the Standard Edition may cover what you need..
Worth buying developer edition. All the features of enterprise edition but for the price...
November 13, 2009 at 11:23 am
You sql string should include a parameter marker
set @sql = @sql + ' AND b.LocationID=@LocationID' etc
That way sp_executesql will cache the appropriate query plan.
November 13, 2009 at 11:13 am
Depends on the license that has been bought and the hardware and OS you want to install it on.
If you have the Enterprise license then use the Enterprise edition.
If you...
November 11, 2009 at 2:54 pm
Viewing 15 posts - 1,951 through 1,965 (of 3,616 total)