Viewing 15 posts - 5,071 through 5,085 (of 8,753 total)
Quick thought, piecemeal'ing the information like this can go on forever, far too many pieces of information missing. Do post the storage configurations (as complete as possible) and in addition,...
June 10, 2015 at 12:48 am
Further on Jeff's reply, here is a quick sample on how this can be done by importing the file as a single lob and parse it afterwards. Mind you that...
June 9, 2015 at 10:45 pm
adonetok (6/9/2015)
There are about 50 questions.
Most questions are check box like
[check box ] No [check box]...
June 9, 2015 at 12:14 pm
Ed Wagner (6/9/2015)
djj (6/9/2015)
Eirikur Eiriksson (6/8/2015)
Ed Wagner (6/8/2015)
crookj (6/8/2015)
Ed Wagner (6/8/2015)
Revenant (6/8/2015)
DonlSimpson (6/8/2015)
Ed Wagner (6/8/2015)
djj (6/8/2015)
Ed Wagner (6/8/2015)
DonlSimpson (6/5/2015)
Eirikur Eiriksson (6/5/2015)
MonarchyEmpire
Republic
Plato
Socrates
Philosopher
Academy
Starfleet
KDF
Bird of Prey
Specialization
Specific
General
Generations
June 9, 2015 at 12:00 pm
Adding on to Phil's question, what is the compatibility mode of the database? What are the two storage configurations etc.? Lots of variables left blank.
😎
June 9, 2015 at 11:58 am
mpdillon (6/9/2015)
June 9, 2015 at 11:30 am
FootyRef (6/9/2015)
GilaMonster (6/9/2015)
FootyRef (6/9/2015)
I only want to do the switching of partitions when running the daily ETL processes.
You've talked about having monthly partitions and switching partitions out of the...
June 9, 2015 at 11:28 am
Nice piece as always Gail, made me giggle a little as when I read it, I had just finished a very similar exercise which brought the execution time of a...
June 9, 2015 at 11:06 am
jsullivan 18251 (6/9/2015)
Central publisher/distributor is on a cloud provider. Some customer servers are named just SERVER
Quick question, can you share some more details?
😎
Edit: typo
June 9, 2015 at 10:49 am
sgmunson (6/9/2015)
DiabloZA (6/7/2015)
Yes, this is it.Thank you so much sir !!
You are a life saver.. God bless..
You may want to look at performance. With small amounts of data,...
June 9, 2015 at 10:48 am
Steve Jones - SSC Editor (6/9/2015)
Eirikur Eiriksson (6/4/2015)
Should be as simple as
..TOP(1)...
WHERE POST.VISIBLE = TRUE;
😎
Nothing is ever simple, and the queries that do this potentially slow way down with...
June 9, 2015 at 10:34 am
ChrisM@Work (6/9/2015)
Steve Jones - SSC Editor (6/9/2015)
Eirikur Eiriksson (6/4/2015)
Should be as simple as
..TOP(1)...
WHERE POST.VISIBLE = TRUE;
😎
Nothing is ever simple, and the queries that do this potentially slow way down...
June 9, 2015 at 10:19 am
mpdillon (6/9/2015)
I do not understand how to create a CTE from a CTE. Could you...
June 9, 2015 at 10:15 am
Quick suggestion, add another CTC and filter the output from there.
😎
June 9, 2015 at 8:55 am
GilaMonster (6/8/2015)
Switch the partitions that are needed out to a staging table, do processing on the staging table then switch...
June 9, 2015 at 1:41 am
Viewing 15 posts - 5,071 through 5,085 (of 8,753 total)