Viewing 15 posts - 1,261 through 1,275 (of 6,036 total)
ben.brugman (8/16/2016)
The question was:So how would you load/parse/store the data were all unnecessary data is filtered out before it is inserted ?
The answer was given.
You probably should read it.
Given are...
August 16, 2016 at 4:17 pm
ben.brugman (8/15/2016)
Sergiy (8/2/2016)
I believe building tables to hold the unnecessary data, load it, parse, store (even temporarily) will cause quite a performance hit. With no any benefits.Don't you think?
No I...
August 16, 2016 at 1:39 am
sknox (8/14/2016)
Sergiy (8/14/2016)
1. The same small query populating a temp table may be reused in several procedures.
In such case its plan...
August 14, 2016 at 10:19 pm
There are other aspects which were not mentioned by anyone.
1. The same small query populating a temp table may be reused in several procedures.
In such case its plan will be...
August 14, 2016 at 7:08 pm
Stoutheart (8/8/2016)
August 10, 2016 at 4:55 pm
sqlenthu 89358 (8/8/2016)
HI Sergiey, These tables get populated every few mins. Though there are no updates and deletes. Will that be impacted if clustered indexes are built on them ?
The...
August 8, 2016 at 9:53 pm
Grumpy DBA (8/8/2016)
Ed Wagner (8/8/2016)
Hugo Kornelis (8/7/2016)
SQLRNNR (8/7/2016)
ragequit
Resign
Celebrate
life
August 8, 2016 at 6:50 am
Igor Micev (8/5/2016)
Sergiy (8/4/2016)
BTW, did you check default collation for tempdb?
Does this question make sense?
When you create a temp table all char columns get the default tempdb collation.
Unless you explicitly...
August 5, 2016 at 3:23 pm
sqlenthu 89358 (8/4/2016)
August 5, 2016 at 5:08 am
sqlenthu 89358 (8/4/2016)
That is typo from my end. Everything is fine syntax wise.
So how the correct version would look like?
Like this?
select t1.col1,t1.col1,t1.col3,t1.col4,t1.col5,
sum(case when @listofids<>replace(@listofids,t2.col20,'') then col15*10 else col15 end)
from table1...
August 4, 2016 at 11:50 pm
The number of brackets open is 2 more than the number of brackets closed.
Am I missing something?
August 4, 2016 at 6:41 pm
WhiteLotus (8/3/2016)
I have issue with collation . my PRODUCTION server collation is SQL_Latin1_General_CP1_CI_AS and database collation is Latin1_General_CI_AS
And also when I check in 1 database that we use...
August 4, 2016 at 12:39 am
You need to have a table with DLS schedule, and use it when calculating current time.
You may get DSL schedules from various locations, for example from here:
August 3, 2016 at 6:53 pm
Revenant (8/3/2016)
Ray K (8/3/2016)
Luis Cazares (8/3/2016)
whereisSQL? (8/3/2016)
Ed Wagner (8/3/2016)
Hugo Kornelis (8/3/2016)
Ed Wagner (8/3/2016)
djj (8/3/2016)
whereisSQL? (8/3/2016)
crookj (8/3/2016)
Ed Wagner (8/3/2016)
Y.B. (8/3/2016)
Luis Cazares (8/3/2016)
Hugo Kornelis (8/3/2016)
Ed Wagner (8/3/2016)
crookj (8/3/2016)
djj (8/3/2016)
Grumpy DBA (8/3/2016)
djj (8/3/2016)
Ed...
August 3, 2016 at 4:14 pm
ben.brugman (8/2/2016)
It all sounds OK when you exporting a file.
If it sounds OK somebody probably will do this. Handling mixed textqualifiers does take a performance hit, so I am excluding...
August 2, 2016 at 5:35 pm
Viewing 15 posts - 1,261 through 1,275 (of 6,036 total)