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...
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
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/
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
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)?
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
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...
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
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...
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
May 14, 2013 at 2:08 am
Doesn't matter
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
May 13, 2013 at 4:26 pm
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...
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
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,...
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
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)
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
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...
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
May 13, 2013 at 8:35 am
Partitioning is not primarily for performance, have a read through the article I referenced.
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
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...
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
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...
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
May 13, 2013 at 5:10 am
sqlnaive (5/13/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
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.
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
May 12, 2013 at 3:01 am
Viewing 15 posts - 13,171 through 13,185 (of 49,552 total)