Viewing 15 posts - 5,866 through 5,880 (of 7,597 total)
A longshot, but, in the interests of being thorough ...
Are there possibly different "table1" tables under different schemas? Could one session be reading from a different schema.table1 than the...
August 7, 2014 at 10:11 am
GilaMonster (8/7/2014)
ScottPletcher (8/7/2014)
Which is why I don't quite understand the "definitely not!" 🙂You may have missed the word before that phrase.
"The average of those isn't 'definitely not'"
Yep, sure did :blush:
August 7, 2014 at 9:37 am
Would it "ever not do that"?
The INSERT could fail if it ran out of physical file space to hold the new rows.
August 7, 2014 at 9:29 am
ChrisM@Work (8/7/2014)
ScottPletcher (8/7/2014)
ChrisM@Work (8/7/2014)
gstarsaini (8/7/2014)
Thanks for the reply.This means there is no effect on the queries?
Each reply posted to your question implies "maybe", "probably" or "definitely". The average of these...
August 7, 2014 at 9:26 am
ChrisM@Work (8/7/2014)
gstarsaini (8/7/2014)
Thanks for the reply.This means there is no effect on the queries?
Each reply posted to your question implies "maybe", "probably" or "definitely". The average of these isn't "definitely...
August 7, 2014 at 9:10 am
gstarsaini (8/7/2014)
Do multiple SELECT queries on the same table but different condition in WHERE clause block or affect each other in any way?
They definitely could. The WHERE conditions determine...
August 7, 2014 at 8:08 am
Bill Talada (8/6/2014)
August 6, 2014 at 5:23 pm
For best performance overall, I strongly suspect you need to change the clustered indexes on the tables. We would have to look at least at missing index and index...
August 6, 2014 at 5:09 pm
LutzM (8/6/2014)
If the table contains a rather large number of columns (e.g. 50 or more) you might consider "vertical partitioning",...
August 6, 2014 at 5:00 pm
Basically, I want to wait for the job to complete and then send either a success or failure email based on the outcome of the job.
Again, I urge you to...
August 5, 2014 at 9:45 am
For that, you could create a proc on the remote server. You execute the proc remotely, and the proc can issue the start job, and then monitor for job...
August 4, 2014 at 6:34 am
8 hours seems extraordinarily extreme for 172M rows. It seems like there must be more to the story.
Are you changing the clustered index on the table? Does the...
August 3, 2014 at 11:40 am
I'd also create the best indexes while re-working the code.
#Events indexes:
1) Unique Clustered on ( ProcessDate, L4Ident ) --in that order
2) Nonclustered on ( L4Ident )
3) NNonclustered on ( LinkRL4,...
August 1, 2014 at 11:25 am
dkriplani97 (8/1/2014)
UPDATE TableA
SET Value = isnull((select top 1 Value from #tmpcopylibrary
where dataid = tempquerydataid), 0).
however this is not working
UPDATE TableA
SET Value = isnull((select top 1...
August 1, 2014 at 11:11 am
Viewing 15 posts - 5,866 through 5,880 (of 7,597 total)