Viewing 15 posts - 4,966 through 4,980 (of 5,103 total)
FROM BOL:
quote:
To access a secured Access database, configure the registry (using the Registry Editor) to use the correct Workgroup Information...
December 5, 2003 at 8:27 am
this is my subjestion
SELECT
stock.id,
stock.item,
COALESCE( SUM(in),0) AS total_in,
COALESCE( SUM(out),0) AS total_out,
COALESCE( SUM(in),0) - ...
December 5, 2003 at 8:13 am
quote:
SELECT id_1, id_2FROM TABLE_DATA
WHERE calcOne(5, data1, data2, data3, data4, data5, null, null, null, etc... null)
is faster than
SELECT id_1, id_2...
December 5, 2003 at 7:31 am
quote:
What do you do if you have 50 columns in a table?. There must be a better way of doing this.
December 5, 2003 at 7:09 am
go to the "index" and type sp_OA the list of them should come up
http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_14_7bcc.asp?frame=true
December 4, 2003 at 5:56 pm
And Also Try the difference with a join:
SELECT * From
TABLE JOIN (SELECT CAST (SUBSTRING( @List , n.n + 1 , CHARINDEX( ',' , @List , n.n + 1 )...
December 4, 2003 at 2:14 pm
I didn't know you were using 75 MILLIONS records. I should have warn you about the cast because is not using any index.
I have nothing with that many records but...
December 4, 2003 at 2:07 pm
if you want Outputs you can:
1.
- run package with the sp_OA procedures
- store result on global variable
- read global variable
2.
- Store output...
December 4, 2003 at 1:03 pm
December 4, 2003 at 12:50 pm
the short answer is "Logging"
try to delete in "small" chuncks like 5000 rows at a time
December 4, 2003 at 9:57 am
December 4, 2003 at 9:33 am
if the job is owned by a sysadmin the package is run uder the context of the SQL Server AGENT service Acccount!
if the job is owned by non-sysadmin account...
December 4, 2003 at 8:43 am
how about:
Declare @varlist varchar(255)
Set @varList = ',1,2,3,5,' -- Commas before and after
SELECT *
FROM Table_Name
WHERE CHARINDEX(',' + Convert(varchar, TableId) + ',', @varList) > 0
December 4, 2003 at 8:34 am
assining Null to the parameters is NOT going to speed up your functions!!!
so as long as the udf uses the Right Values you should be ok with :
dbo.calcOne(@Timeframe, @FromYear, data1,...
December 4, 2003 at 8:10 am
Viewing 15 posts - 4,966 through 4,980 (of 5,103 total)