Forum Replies Created
Viewing 15 posts - 3,556 through 3,570 (of 5,103 total)
-
RE: Views in Query Analyzer
check the "owner" of the views and the login you are using to connect through EM
* Noel -
RE: T-SQL Quiz of the Day -- Multiple Choice
Yes the ; in that case is the VERSION of the stored procedure.
This is an old ODBC standard and I don't recommend it to use because tools like QA or EM hide...
* Noel -
RE: one physical data file vs two files
if data and log are on the same partition you have the first problem there.
Filesize is not as much an issue as TABLE size
and you coud try to increase...
* Noel -
RE: Loop within a Stored Proc...
I don't fully understand your logic for all cases but this may put you in the right Track:
select
Project,
EventID,
DateAdd( day,
(select sum(Leadtime)
from yourtable t2
where...
* Noel -
RE: one physical data file vs two files
29GB does not sounds that big!
what RAID level do you have?
how many spindles/disks are you using on the RAID?
do you have the log in a separated drive?
are indexes Ok...
* Noel -
RE: SQL Profiler
not sure about database name but:
select db_id() -- gives you the number you need when runned on the desired db
* Noel -
RE: Can Wives Shorten Work Hours?
LOL
* Noel -
RE: Calculate Moving Average
sure! you are materializing it
* Noel -
RE: T-SQL Quiz of the Day -- Multiple Choice
c ?
* Noel -
RE: Calculate Moving Average
Is not that is redundant is that because you only have let's say AVG for lets say 10 , 20 and 200 spans it makes sense to compute ahead of...
* Noel -
RE: Getting current rows from table with from/thru dates
My position is:
if you can avoid the use of nulls you must do it! nulls are bad and can give you many headaches when quering
* Noel -
RE: Dropping a Non clustered Index
PRECISELY!
the downside side is that selectivity will be affected because you are going to have some duplicates. If the duplicates are a lot ex: a column with on very few...
* Noel -
RE: T-SQL to perform 2 COUNTs in 1 Pass (if possible)
You should Follow the above approach but swap the order of operations:
abs(sum(a.correct))
-- abs performed once
* Noel -
RE: Dropping a Non clustered Index
from you previous post:
Create unique nonclustered index ...
The error you are getting indicates that you have DUPLICATES on a column that you are specifiying as unique
You must Either "check the...
* Noel -
RE: Trace output to table
like it or not is a two step process.
If you try to script the profiler settings when performing table output it will write this line in the script:
--...
* Noel
Viewing 15 posts - 3,556 through 3,570 (of 5,103 total)