Viewing 15 posts - 3,856 through 3,870 (of 9,253 total)
bobbums (12/6/2013)
In the article, your suggestion is to drop the PK and then re-add it.
This is correct as in this case the clustered index column is also the...
December 9, 2013 at 4:14 am
what errors are you receiving when you try to start the agent?
December 6, 2013 at 11:27 am
PHXHoward (12/6/2013)
I wrote a long detailed reply but forgot to save to clipboard before hitting submit and it didn't go through. Oh well.
Would have been interested to see that!
PHXHoward...
December 6, 2013 at 11:26 am
SQLSACT (12/6/2013)
I would recommend that you put a file share witness in place
I concur
December 6, 2013 at 4:54 am
ChiragNS (10/16/2008)
Would Create Index WITH Drop_Existing work for moving non-clustered indexes.
Yes it does.
December 6, 2013 at 4:26 am
ALTER TABLE [INVOICE]
DROP CONSTRAINT [INVOICE_PK] WITH (MOVE TO SECONDERYDATA)
After the move, we now recreate the PK Constraint:
ALTER TABLE [INVOICE]
ADD CONSTRAINT [INVOICE_PK] PRIMARY KEY CLUSTERED
( [column name] ASC
)WITH (IGNORE_DUP_KEY...
December 6, 2013 at 4:25 am
Drop the cursors and the calls to xp_fixeddrives and fsutil and use the following
[Code]wmic volume get capacity, "free space", name[/code]
December 6, 2013 at 1:19 am
Junglee_George (12/5/2013)
HiPlease explain the Difference between Now() and Today() functions in SSRS reports. Are they both same or different..??
Note that these are not T-SQL date\time events they are visual studio...
December 5, 2013 at 8:44 am
inevercheckthis2002 (12/5/2013)
After doing so,...
December 5, 2013 at 8:38 am
Aatish Patel (12/5/2013)
-----See if there are any orphan users:
EXEC sp_change_users_login 'Report'
The output was :
finq_sql...
December 5, 2013 at 8:31 am
Gerard Silveira (11/7/2013)
When you say easier to store with the VM, do you mean the same LUN that the .vmdk file is stored on
OR
Do...
December 5, 2013 at 3:50 am
Leo.Miller (2/14/2011)
David Benoit (2/14/2011)
They had a nice shiny new SAN installed to improve performance,
Storage Area Networks are implemented for consolidation not performance, much like virtualisation is implemented for consolidation....
December 5, 2013 at 3:45 am
cpathidba (12/5/2013)
Hi Praveen,I had given those permissions also,still it was showing same error, please help us.
thanks & regards
Chalapathi
It is the SQL...
December 5, 2013 at 3:37 am
Viewing 15 posts - 3,856 through 3,870 (of 9,253 total)