Viewing 15 posts - 556 through 570 (of 1,583 total)
Definitely sounds like an issue with the mapped drives (this happens) - don't suppose the external storage is a READYNAS or something similar?
While not sure it's the cause of your...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 16, 2013 at 8:21 pm
You know that doing COUNT(*) on a table with a lot of columns and a lot of rows can take a lot of time and memory
There is virtually no difference...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 15, 2013 at 7:04 am
What (if anything) does your System/Application Event logs have to say?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 11, 2013 at 1:38 pm
Have you tried writing it locally first, then copying?
Not that this would be a solution, but it would prove there's an issue with the UNC mapping - issues with mapped...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 11, 2013 at 1:01 pm
Thanks for all the GREAT responses everyone. I had actually tweaked an existing index to get the query down to a few seconds, and at one point attempted the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 23, 2013 at 9:20 pm
Was this link of any use to you?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 18, 2013 at 1:00 pm
BTW, I am using SQL 2008 EE, not 7,2000
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 13, 2013 at 7:24 am
Did you ever find an answer to this? I have a similar situation: I have a query that consistently showing 2.4 million reads in profiler, yet running the exact...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 13, 2013 at 7:24 am
Yes it should be set to a fixed amount...and other equally important items are outlined quite plainly in the article I pointed out from idera (above) - have you had...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 11, 2013 at 3:27 pm
This is a good article outlining tempdb, it's not too lengthy and should help answer your questions:
http://www.idera.com/resourcecentral/whitepapers/demystify-tempdb-performance-and-management
It will definitely answer your questions regarding how to set the growth...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 11, 2013 at 7:29 am
You could also check to see if there are any lingering/old/unused spids that can be killed - in our shop we have report writers that will run rather large queries...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 11, 2013 at 7:25 am
So...just tweak what I already posted? Something like:D-ECLARE @OldTable TABLE( col1 varchar(1), col2 int, col3 int, col4 int, col5 int);
D-ECLARE @NewTable TABLE( col1 varchar(1), col2 int, col3 int);
INSERT @OldTable VALUES...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 11, 2013 at 7:15 am
Assuming the NewTable has at least 1 column - in it's simplset form:
INSERT INTO NewTable
SELECT SUM(col1 + col2 + col3 + col4 + col5 + col6 + col7) FROM OtherTable
Test
D-ECLARE...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 11, 2013 at 6:34 am
I am familiar with the wildcard operator and like everyone else, the answer should have been 2, but because of the insert issue, I also chose 0 knowing that the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 11, 2013 at 6:27 am
If your DB is only 800GB and you have that many indexes, chances are the non-clustered indexes are pretty small so the rebuild process should go rather quickly (especially so...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 9, 2013 at 10:21 am
Viewing 15 posts - 556 through 570 (of 1,583 total)