Viewing 15 posts - 13,171 through 13,185 (of 49,552 total)
Yes, but it's an exceedingly bad idea and it's only supported as part of a rolling upgrade process.
The mirroring will work, however if that ever fails over then the new...
May 14, 2013 at 7:30 am
Yes, you probably do want to split that up.
This blog post's probably closer than the catch-all one
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
May 14, 2013 at 7:27 am
Why don't you write some code, play with it and see how it works (and see the relevant sections in Books Online)?
May 14, 2013 at 5:00 am
Do not automatically create all the indexes that the missing index DMVs suggest, that's a good way to severely over-index and hinder performance.
Evaluate what the missing index DMVs suggest, examine...
May 14, 2013 at 3:01 am
Minor correction.
That script shows the last read or write since the database last started. It shows no information at all prior to that. Hence if you reboot the server every...
May 14, 2013 at 2:08 am
sqlguy-736318 (5/13/2013)
I assume the implications are even greater for join columns which should generally be PK's (clustered indexes). Is this correct?
No. They'll be primary keys on the one side, foreign...
May 13, 2013 at 11:38 am
There's no difference in basic querying in Express edition. Providing both databases are on the same instance, that code will work. Check permissions, check that the database name is correct,...
May 13, 2013 at 10:36 am
You'll want to run it on the database, not a single table, so
DBCC UPDATEUSAGE(CnS_MANIFESTCr)
May 13, 2013 at 8:55 am
hamed1337 (5/13/2013)
Thank you for the tip, i already did that when i saw that you guys aren't supporting SQL 2000.
It's not us that's not supporting SQL 2000 (can you really...
May 13, 2013 at 8:35 am
Partitioning is not primarily for performance, have a read through the article I referenced.
May 13, 2013 at 8:02 am
It's a heap (index 0). You can't reorganise a heap and fragmentation has a very different meaning for a heap than for an index.
Please post new questions in a new...
May 13, 2013 at 5:40 am
If you're partitioning solely for performance, don't waste your time.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
If you're partitioning for fast data loads and easier maintenance, then the table's insert patterns and the business rules for archiving/deleting...
May 13, 2013 at 5:10 am
sqlnaive (5/13/2013)
May 13, 2013 at 5:05 am
No, because there's no way to estimate that. The query could be blocked, it could have to wait for a resource or time on the CPU, etc.
May 12, 2013 at 3:01 am
Viewing 15 posts - 13,171 through 13,185 (of 49,552 total)