Viewing 15 posts - 13,051 through 13,065 (of 39,965 total)
I don't know when/if this will be available. It certainly would make some sense, with overrides from the DBA. There are indexes that are lightly used (in frequency), but very...
November 29, 2012 at 11:13 am
Why can't you increase the space? Make the file bigger or add a new file or filegroup.
November 29, 2012 at 9:44 am
You might also read this about choosing your clustered key: http://www.sqlservercentral.com/articles/Indexing/68563/
November 29, 2012 at 9:43 am
you could build a clustered index and then drop it again to clear things up, but really you ought to consider adding a clustered index and leaving it there, as...
November 29, 2012 at 9:37 am
brian.francis (11/29/2012)
November 29, 2012 at 8:53 am
cfradenburg (11/29/2012)
November 29, 2012 at 8:52 am
Koen Verbeeck (11/28/2012)
November 29, 2012 at 8:46 am
Since a few of you are experienced, we're looking for a few disaster recovery stories on fairly short notice for the week of the 10th. If you want to write...
November 28, 2012 at 10:34 am
Not sure about the optimizing, but I think Ignite (http://www.confio.com/performance/sql-server/ignite/#5) and Performance Advisor (SQL Sentry, http://www.sqlsentry.net/performance-advisor/sql-server-performance.asp#features) will help find poor queries.
November 28, 2012 at 10:16 am
rusanu.com is a good source. I'd ask him further questions if you need them. He's done a lot of SB work.
November 28, 2012 at 10:13 am
Sean is right in that you need to define active. Are these sessions with a connection to SQL Server? Those running?
We could help with a better definition, but you'd also...
November 28, 2012 at 10:12 am
yes, identity is supported in all versions of SQL Server.
November 28, 2012 at 10:09 am
Simon E Doubt (11/28/2012)
I do think there is a lot of value in networking as well, so this might not be the best approach for everyone, but it certainly is...
November 28, 2012 at 10:09 am
Sorry, I wasn't clear.
Leave the 4th/5th place as a single game. That was fairly exciting.
Move the next two rounds (DS/CS) to a beset of 5. I know the first one...
November 28, 2012 at 10:04 am
good catch, Hugo. added "estimated" to the question.
I don't change answers. The reason is I don't want to mess with the history of what you've chosen, however I do leave...
November 28, 2012 at 9:58 am
Viewing 15 posts - 13,051 through 13,065 (of 39,965 total)