Viewing 15 posts - 11,386 through 11,400 (of 49,562 total)
Update stats on that table manually, see if you get the same error. If so, update stats one by one, see which one gives you the error. Look at what...
October 7, 2013 at 9:41 am
aleksandar.ivanovski (10/7/2013)
If there is no single column index per key it will last long right?
It could, yes.
My question was, if there is no way to insert/update/delete rows in some of...
October 7, 2013 at 9:25 am
DBCC CheckDB WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY
If you do a SELECT * FROM TableName do you get the same error?
October 7, 2013 at 9:24 am
wolfkillj (10/7/2013)
October 7, 2013 at 9:16 am
thisted (10/7/2013)
October 7, 2013 at 8:21 am
There's nothing there to suggest anything is recompiling. In fact, if those procedures were in the middle of a recompile they couldn't be causing blocking as they'd still be in...
October 7, 2013 at 8:07 am
Maybe. Test it and see if that index helps with the performance of the application. If it does, implement it. If it doesn't, don't implement it. Either way, it's not...
October 7, 2013 at 7:43 am
enriquezreyjoseph (10/4/2013)
BUT i want checkboxes to behave like radio button(thou it seem stupid but i have my own reason why i am using it)
That's generally a bad idea. Anyone who's...
October 7, 2013 at 7:36 am
Don't shrink the log.
Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
October 7, 2013 at 7:29 am
Jack Corbett (10/7/2013)
I actually had a recruiter contact me about a contract in NYC with a title of Data Architect that they wanted to pay 45/hr for.
That's actually...
October 7, 2013 at 7:27 am
Jeff Moden (10/5/2013)
October 7, 2013 at 5:58 am
curious_sqldba (10/6/2013)
Can we disable PK which is nc index?thanks
Do you want to disable data integrity constraints in your table? Do you want to potentially allow bad data in and have...
October 7, 2013 at 5:04 am
Not enough information to tell. A single data point is never enough to say anything decisive.
October 6, 2013 at 2:55 pm
JimReid (10/6/2013)
Anyway, SQL seems very difficult to work with
Bear in mind that SQL is a server product, it's more like Exchange or Lync than Office or Visual Studio.
October 6, 2013 at 12:18 pm
Drop the clustered index = recreate the entire table and rebuild all nonclustered indexes
Create the clustered index = recreate the entire table (again) and rebuild all nonclustered indexes (again)
Given that,...
October 6, 2013 at 9:31 am
Viewing 15 posts - 11,386 through 11,400 (of 49,562 total)