Viewing 15 posts - 6,496 through 6,510 (of 13,469 total)
the mail server in your databasemail profile you are using in = your Exchange Server?
i've got several profiles set up , some with the company mails erver, some with...
November 3, 2011 at 9:33 am
i think the issue is related to the mails erver, and not your database configuration settings.
Are you using your Exchange server that Outlook points to as the mail server in...
November 3, 2011 at 9:06 am
i usually use dynamic sql for the command, as if i'm adding a table that doesn't exist, the script will fail validation.
IF EXISTS(SELECT 1
...
November 3, 2011 at 8:42 am
bulk insert allows you to use a format file, and the format file handles the quoted delimiters for you.
without the format file, you end up having to handle the delimiters...
November 3, 2011 at 7:49 am
if there are different server versions, for example ServerA is SQL2005 but ServerB is SQL2008, you'll want to rebuild the indexes as well as rebuild the statistics for non-index columns;...
November 3, 2011 at 6:57 am
since you are migrating from another table, and at least one value already exists, shouldn't you be joiing on the local data to prevent the duplicates from being inserted?
or do...
November 2, 2011 at 6:08 am
i may be misremembering the thread; i'm searching thru my posts now to find it; i was fiddling with trying to make an example, but the clustred index i'm creating...
November 1, 2011 at 3:14 pm
I think Gail had posted that they are logically stored in the clustered index order, and not necessarily physically stored once you look inside a page.; there was a post...
November 1, 2011 at 2:59 pm
well remember floats are stored as approximations, so i'd suspect witht eh full details, that's where the issue lies.
SQL
with the one exampel you offered, i don't see anything specific...
November 1, 2011 at 2:50 pm
are you sure it's an inline TVF? if you are in the database you know it exists, what does this return?
select type,* from sys.objects where name='getuserrelations'
November 1, 2011 at 12:25 pm
can you start sending differentials or transaction logs to the other site instead of full backups, and start doing incrementals restores there instead?
October 21, 2011 at 2:00 pm
this is one of the ramificaitons of having the "universal" lookup table instead of one lookup table for each logical group of values.
to do what you are asking, you need...
October 21, 2011 at 1:17 pm
since MySQL is preventing you from multiple UNIONs, you'll end up having to insert into a temp table (MySQL has temp tables, right?
3 unions would be three inserts, all into...
October 21, 2011 at 12:21 pm
bcp.exe requires a MS operating system....so you can't call bcp.exe from a unix operating system....
but you can bcp a FILE into or out of a shared directory that exists on...
October 21, 2011 at 10:47 am
I'm thinking it's because of statisitcs..the plan itself is fine, but the statistics used get more and more out of date as that 10% per day occurs.
when you recompile...
October 21, 2011 at 8:06 am
Viewing 15 posts - 6,496 through 6,510 (of 13,469 total)