Viewing 15 posts - 2,011 through 2,025 (of 3,669 total)
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
If there are a discreet set of designs and a discreet set of sales reps then you need a separate mapping table with a combined primary key of LogoDesignID and...
November 11, 2009 at 2:50 pm
This sounds like a strange approach.
Are you trying to back up on one server and restore on another?
I would use a batch file that runs SQLCMD to do each task...
November 11, 2009 at 2:41 pm
So you have one distributor but how many distribution databases do you have?
I ran into a problem where the distributor didn't look like it was stressed but the outstanding transactions...
November 11, 2009 at 2:37 pm
create PROCEDURE [dbo].[usp_Dynamic]
@location_id int = NULL
...
November 11, 2009 at 2:32 pm
David, can you elaborate on this?
The other things that strike me is that the "text in row" option may apply and also the maximum replicated text size (defaults to 64Kb).
sp_tableoption...
October 24, 2009 at 9:31 am
Personally I believe that VARCHAR(MAX) is a datatype of last resort.
To give an extreme example the longest possible telephone number is 15 digits so allowing for formatting I allow VARCHAR(20)....
October 23, 2009 at 6:33 am
If you have one publisher then multiple distribution databases won't do you any good because a publisher is associated with one distributor.
MySQL is great for one master, multiple slaves.:hehe:
We did...
October 22, 2009 at 7:42 am
Viewing 15 posts - 2,011 through 2,025 (of 3,669 total)