Viewing 15 posts - 35,476 through 35,490 (of 39,720 total)
We are integrating another server here at the site and it will run W2K3. Not sure if it will run the web or db, but we'll see if we notice...
December 29, 2003 at 10:54 am
I haven't done much with warehousing, but AFAIK, isn't the Meta Data Services in SQL Server supposed to do most of this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
December 29, 2003 at 10:52 am
Distinct will return distinct rows, so I'd select the combination of all three.
select distinct p.product, c.currency, c.customer
from ...
where ...
as you need them. Then count these rows by...
December 29, 2003 at 10:51 am
Have a bunch on SAN, none on NAS.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 10:48 am
16 is correct (0x10) according to BOL. As far as system proc, don't see one. sp_helpfile and sp_helpfilegroup don't tell you which is the default.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
December 29, 2003 at 10:43 am
Clustered index - low selectivity columns, those with relatively few different values or ranges, like dates.
Non clustered, those that have high selectivity, like identities, where you usually return one column.
Due...
December 29, 2003 at 10:40 am
defragging should help performance, but as far as I know, it doesn't change the fragmentation internally. Your extents will still be where they are relative to each other.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
December 29, 2003 at 10:34 am
Tend to agree with most of this. PHP is pretty neat and works well, even on Windows. It's a nice language, but personally I find that ASP does everything I...
December 29, 2003 at 10:32 am
That would be my guess as well. As to why, I'm not sure.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 10:10 am
Use a permanent table (clear it each time). The xp_cmdshell changes context, so the temp table isn't visible.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:47 am
There are partitioned views, distributed across servers, which seem like a similar thing. Not as mature in SS2K.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:46 am
You need a MAPI client. Or xpsmtp, which is an extended stored proc itself.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:44 am
Interesting thought. No way that I know of, but I'll keep looking. This might be a handy option.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:42 am
Are you sending the password through? Pwds are not stored in the DSN.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:37 am
I'd rename the file after it was created with a simple xp_cmdshell 'ren oldfile.zip newfile_date.zip'
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 29, 2003 at 9:35 am
Viewing 15 posts - 35,476 through 35,490 (of 39,720 total)