Viewing 15 posts - 35,551 through 35,565 (of 39,803 total)
Was this the original size? If not a DBCC SHRINKFILE will bring it down or use this script:http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:20 am
select * from sysobjects where type = 'proc' and then run this in a cursor with exec( drop procedure xx) in the loop./
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
December 31, 2003 at 10:18 am
It potentially cold add rows. It depends if you have many variable length columns. The # of rows is 8060 / row size (roughly). Variable length columns could change that....
December 31, 2003 at 10:17 am
Thanks, I saw this out somewhere and thought it would make a pretty funny list for DBAs.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 31, 2003 at 10:14 am
Processing aborted when updating my personal info.
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 1:22 pm
removed
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 1:09 pm
Not sure why this was locked, but I unlocked it.
I wouldn't use NAS, barely like using SAN because of the potential contention and access issues. If a large file copy...
December 29, 2003 at 11:00 am
Good idea. Love to see an article on using this in an app 😀
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:56 am
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
Viewing 15 posts - 35,551 through 35,565 (of 39,803 total)