Viewing 15 posts - 841 through 855 (of 3,738 total)
I found the following article that state that you should a good backup before you Kill the process.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153850
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 17, 2014 at 10:28 am
I deleted it and it worked.
Last time I deleted it in T-SQL Code.
Thank you.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 17, 2014 at 8:37 am
It takes forever but it eventually generates the Code.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 3:51 pm
I was thinking Oracle Free Space. :blush:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 3:40 pm
Grant Fritchey (6/16/2014)
With log buffer waits, it's hitting conflicts with other processes in and around the log. It might just be slow.
Thanks for the insight.:-)
It's moving fast unlike this weekend...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 3:30 pm
It is moving very slowly on a 30 million record table.
Thanks. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 1:48 pm
One of the just worked. Started another and I'm getting a LOGBUFFER WAIT TYPE.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 1:33 pm
Wait Types are mostly CXPACKET. Also getting SOS_SCHEDULER_YIELD.
There is definitely no blocking going on.
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 1:23 pm
Lynn Pettis (6/16/2014)
Still slightly confused. Are you shrinking first then rebuilding indexes or the other way around?And, why are you shrinking the database anyway?
I'm rebuilding first because there was...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 12:14 pm
I shrinking the file from SSMS. I specified reorganize before releasing space.
That could take some time on a .9 Terabyte File.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 11:50 am
Initially I just wanted to reduce fragmentation.
Now I'm trying to reduce the size of the Data Files.
The ndf reduced pretty well but the mdf went from over 422 GB to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 11:47 am
I rebuilt the Indexes on most of the tables in one of the Database and I only have 20% free.
I thought that I would have more than that.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 10:51 am
I'm rebuilding the Indexes.
I have rebuilt a lot of tables but I only have 9% free. It does not appear to be changing.
What am I doing wrong?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 16, 2014 at 9:13 am
This Job has been running successfully for years on this Server when I upgraded it to SQL Server 20008 R2.
Nothing has changed.
Thanks.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 9, 2014 at 1:04 pm
Eirikur Eiriksson (6/8/2014)
😎
/* 250 Gb */
DECLARE @MY_NumberOfBytes NUMERIC(12,0) = 268435456000;
/* bytes */
SELECT
'Bytes' ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 8, 2014 at 4:15 am
Viewing 15 posts - 841 through 855 (of 3,738 total)