Viewing 15 posts - 1,021 through 1,035 (of 1,241 total)
Will this work if the next time you get "This is effective as of May 5, 2014" ? - just giving a heads up in case you are using a...
May 20, 2014 at 5:23 pm
In SSIS 2008, you can right click the Project (top node) in the VS solution explorer. From there go to Properties , Debugging , Run64BitRuntime... set this property to false....
May 20, 2014 at 5:17 pm
Fantastic solution Lowell, I reckon you meant
WHERE Datediff(dd, T1.discharge_date, T2.admit_date) < 30
?
May 20, 2014 at 4:58 pm
If you look at the execution plan of a query using the BETWEEN operator you will see that it is converted to a >= and <=.
Good Point, thanks.
May 20, 2014 at 4:36 pm
You don't necessarily need to use a join, try the WHERE EXISTS clause. Look it up on MSDN.
May 20, 2014 at 2:06 pm
I've come across somewhere that using BETWEEN is slower that actually using the less than/greater than operator. I have not done any testing on it. Any quick feedback on...
May 20, 2014 at 2:00 pm
It would be good to investigate how the tables are joined, are the indexes appropriate, is it fast when you call it from ssms? As mentioned by others taking the...
May 19, 2014 at 5:55 pm
The query is going to return a result to the screen from your select and the insert two columns into your non temp table. If you want to automate email...
May 19, 2014 at 5:51 pm
A typical update using a IF could look like
IF (month(getdate())=4)
begin
update t1
set t1.columnA=t2.columnA
from table1 as t1 inner join table2...
May 16, 2014 at 5:38 pm
Were you disabling your indexes when employing SSIS? Or only when using t-sql?
May 16, 2014 at 5:19 pm
You don't need a script task to export a table in SSIS , chose a dataflow task within SSIS. Make ole db the source and make a flat file...
May 9, 2014 at 5:46 pm
Do you have anything configured under report properties for available values and default values that might cause this behavior?
May 7, 2014 at 3:26 pm
LutzM (5/3/2014)
...which is refrenced across 63 columns in 40 + tables...
Just wondering: Why is a PK column refernced by more than one column of another table?
There are cases when it...
May 4, 2014 at 1:07 am
UserDatasourceFact
UserID | SourceID
1 | A
2 | A
I have Project Dimension Table:
Project ID | Source
P1 | A
P2 | A
P3 | B
I am wondering if the projects table can serve as a...
May 2, 2014 at 2:04 pm
Don't know that you install one, they are created within SQL Server. Start with planning what you expect the size to grow to in the future. For each potential table...
May 2, 2014 at 11:59 am
Viewing 15 posts - 1,021 through 1,035 (of 1,241 total)