Viewing 15 posts - 11,386 through 11,400 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2013 at 9:24 am
wolfkillj (10/7/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2013 at 9:16 am
thisted (10/7/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2013 at 7:36 am
Don't shrink the log.
Take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2013 at 7:27 am
Jeff Moden (10/5/2013)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 7, 2013 at 5:04 am
Not enough information to tell. A single data point is never enough to say anything decisive.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 6, 2013 at 9:31 am
Viewing 15 posts - 11,386 through 11,400 (of 49,552 total)