Viewing 15 posts - 4,306 through 4,320 (of 7,502 total)
I see you did discover the dbmail helper objects 😉
- Does it succeed if you use a vbs to send mail using that smtp server ?
- double check the port...
November 19, 2008 at 11:56 pm
if you would use included column, the B-tree part of the index would be smaller, so faster.
I should have to test, if SQLserver still would resolve the filtering based on...
November 19, 2008 at 2:42 am
Is your SQL2000 db comming from a sql2000 version that is supported for upgrade (i.e. >= SQL2000 SP4) ?
November 19, 2008 at 12:56 am
Jeff Moden (11/18/2008)
Although mostly true... not always true. For example, I don't use a front end to create a file with certain formatting requirements from data.
Arch ... formatted exports...
November 18, 2008 at 10:27 pm
FWIW ... early 2008 I joined a webcast regarding mysql and performance.
The main eye catcher was "to avoid joins"... because that was apparently considered for the niche "oracle /...
November 18, 2008 at 12:13 pm
IMO sqlserver in finally entering companies because msaccess no longer suites their needs (performance / size).
"insert disk and run" now gets some shop it guy to the point they...
November 18, 2008 at 11:58 am
system xprocs or sprocs are equal for 32bit and 64bit.
As mentioned by the urls, you'll have to build your own version.
If doing it using xp_cmdshell, encapsulate it in a sproc...
November 18, 2008 at 5:18 am
presentation ....... should be handled by the front end application !
(and preferably client side)
Do not bother sqlserver with how you want things actually presented for the human eye.
One of...
November 18, 2008 at 5:05 am
it's gone in sql2005 ... it was undocumented .... so shouldn't have been in use ...
check out :
- http://forums.databasejournal.com/showthread.php?t=41753
- http://www.simple-talk.com/sql/learn-sql-server/building-my-first-sql-server-2005-clr/
November 18, 2008 at 5:00 am
This is the same like having an insurance ...
As already stated, this may be a straight $$ matter.
Some companies want to cut costs NOW.
The only thing you can do...
November 17, 2008 at 1:49 pm
Mani Singh (11/17/2008)
November 17, 2008 at 1:36 pm
double check the path to the xp is correct.
Check its path on the "old" server or maybe even restore an old mastedb (to an alternate dbname !) to find out...
November 17, 2008 at 12:58 pm
One of the flaws in SQL2005 partitioning, is that you need to add the partitioned key to any unique or primary key, if you want that index applying the partitioning...
November 17, 2008 at 10:25 am
IMO you'll have to simply order it all
select ProductID ,
min(ProductName) as ProductName,
min(ProductCode) as ProductCode
from #Product
group by ProductID
November 17, 2008 at 4:04 am
Viewing 15 posts - 4,306 through 4,320 (of 7,502 total)