Viewing 15 posts - 1 through 15 (of 36 total)
Well, I closed and reopened the package and got it to work. I suppose it needed to refresh.
July 18, 2014 at 2:58 pm
I really like the visualization of SQLjobvis, was more user-friendly than Idera, and had more options.
May 1, 2014 at 11:14 pm
TheSQLGuru (11/28/2012)
Langston Montgomery (11/26/2012)
Update:We upgraded the production server to SP1, and the issue is gone. Lunch for anyone who can figure out why it was happening 🙂
Seems pretty obvious what...
November 28, 2012 at 9:55 pm
SQLKnowItAll (11/28/2012)
mmartin1 (11/28/2012)
It may not be a bad idea to have the server and other workstations check apply updates automatically to Windows and applications.
Yes it would. This should administered...
November 28, 2012 at 9:53 pm
Update:
We upgraded the production server to SP1, and the issue is gone. Lunch for anyone who can figure out why it was happening 🙂
November 26, 2012 at 7:51 pm
richykong (11/12/2012)
That seems a bit strange...can you check the collation between the two servers?
I agree, Richy. It's very strange. Here are the collations for each server:
Production: SQL_Latin1_General_CP1_CI_AS
UAT: SQL_Latin1_General_CP1_CI_AS
Database (production): SQL_Latin1_General_CP1_CI_AS
Database...
November 13, 2012 at 11:36 am
Bhuvnesh (11/12/2012)
Langston Montgomery (11/11/2012)
November 12, 2012 at 12:43 pm
Hi Everyone,
Thank you all for the replies. I can always count on this site for assistance.
I'm embarrassed to say that it turns out to be a version issue. We ran...
November 11, 2012 at 11:51 am
!!False Alarm!!
I feel like such an idiot. I'm almost embarrassed to admit this, but out of courtesy, I thought I would give an update on this in case anyone else...
October 10, 2011 at 12:47 pm
L' Eomot Inversé (10/9/2011)
Langston Montgomery (10/8/2011)
October 9, 2011 at 2:44 pm
Has anyone come across cases where SHA1 has produced output longer than 20 bytes, because I think I have. We are using HASHBYTES to detect changes in our data warehouse,...
October 8, 2011 at 9:03 pm
Jeff Moden (4/8/2011)
April 10, 2011 at 1:16 am
GilaMonster (12/30/2010)
Sure.
The clustered index enforces the logical order of the data, the next and previous page pointers on each page provide a way to read the clustered index in...
December 30, 2010 at 1:58 pm
GilaMonster (12/30/2010)
Langston Montgomery (12/29/2010)
(since, as we know, the data is physically stored in the same order as the clustered index)?Myth, not true.
Care to elaborate?
December 30, 2010 at 12:10 pm
After reading Jeff's full article on "Quirky Update", and by pure luck, I am following all the rules (including the Safety Check). Well, the MAXDOP 1 option just made sense...
December 29, 2010 at 7:26 pm
Viewing 15 posts - 1 through 15 (of 36 total)