Viewing 15 posts - 17,761 through 17,775 (of 49,552 total)
Can there ever be any rows that are in both TBL_STOCKTRANSACTION and dbo.TBL_STOCKTRANSACTION_ARCHIVE?
If not, that should be a union all, not union.
Probbaly won't help much given teh rest, but...
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
July 7, 2012 at 3:25 pm
I suspect you didn't read the article Jeff asked you to read. Please do so.
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
July 7, 2012 at 2:35 pm
Don't use NET Start. Stop the service, then start SQL as an application. From the command line (in the appropriate directory)
SQLServr.exe -m -f -T3608
Make sure that SQL agent is stopped/...
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
July 7, 2012 at 1:17 pm
SQLSACT (7/7/2012)
If I find that my Index does have a Low Average Page Density,Can I avoid this by using a Higher Fill Factor when/if I rebuild?
Probably not (unless your fill...
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
July 7, 2012 at 12:11 pm
ashok23_sharma (7/7/2012)
Hi Gail.. Please let me know if you have any suggestions...
Indexes on the base tables? Possibly full text indexing for the string wildcard filters, would depend on the...
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
July 7, 2012 at 12:05 pm
SQL has no idea what the holidays in your country are. It's possible to write a function that excludes weekends (complex but possible), but not holidays.
Whose holidays would it use?...
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
July 7, 2012 at 11:52 am
It's sometimes called that, I personally hate the term because it's ambiguous.
It's low average page density.
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
July 7, 2012 at 11:20 am
Maybe.
It's not just about the effect on scans, it's also about the page density. If that's lower than desired, the index takes more space than it otherwise needs and is...
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
July 7, 2012 at 9:58 am
Why do you want to create an indexed view? Have you exhausted every other option in tuning and have you considered all the restrictions and requirements for indexed views?
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
July 7, 2012 at 9:57 am
If you are running 32 bit, I strongly suggest upgrading to 64 bit. The licenses are compatible (you can replace your 32 bit SQL instance with a 64 with no...
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
July 7, 2012 at 8:44 am
The log grows until mirroring is reestablished or the log file is full. The log cannot be truncated (marked for reuse) until the log records are hardened at the mirror,...
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
July 7, 2012 at 7:28 am
Providing you ran the truncate within a transaction that has not yet been committed, yes.
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
July 7, 2012 at 7:27 am
I wouldn't recommend using the /3GB switch. That limits AWE memory to 16GB (because of the reduction in the number of page table entries). This would severely reduce the amount...
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
July 7, 2012 at 7:24 am
32 bit SQL or 64 bit? I assume 32 bit since you have AWE enabled.
The plan cache cannot use memory above the 2GB boundary on 32 bit servers. Only the...
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
July 7, 2012 at 5:13 am
Huh? What does a trigger have to do with methods of update?
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
July 6, 2012 at 2:02 pm
Viewing 15 posts - 17,761 through 17,775 (of 49,552 total)