Viewing 15 posts - 6,886 through 6,900 (of 49,552 total)
Drop the indexed view which you created with the tuning adviser and next time test the tuning adviser's recommendations, don't apply them blindly
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
January 5, 2015 at 3:33 am
ScottPletcher (1/2/2015)
GilaMonster (12/31/2014)
Luis Cazares (12/30/2014)
Yes, it's possible, but I wouldn't advice on using decimals on calculations as it's easy to get it wrong.
It's also far less clear than a DATEADD...
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
January 5, 2015 at 1:27 am
Jeff Moden (1/4/2015)
I've taken to quoting the original post in many cases simply because too many people delete the original post even if they get a reasonable answer.
I've had cases...
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
January 5, 2015 at 1:18 am
Jeff Moden (1/5/2015)
What is "VSS"? Last time I heard that abbreviation, is was for "Visual Source Safe".
Volume Shadow (Copy) Service
It's what's used to take 'snapshot'-type backups of SQL databases....
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
January 5, 2015 at 1:16 am
Paul Brewer (1/3/2015)
I spent a couple of hours last night using this stress testing tool SQLQueryStress to compare temp table\table variable latch contention. You were right,...
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
January 4, 2015 at 10:00 am
SQL Guy 1 (1/2/2015)
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
January 4, 2015 at 9:59 am
Divine Flame (1/2/2015)
When a Clustered Index is created on a table, the table data is physically sorted as per the clustered index key.
Logically. Not physically. Same as nonclustered indexes
If...
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
January 4, 2015 at 9:58 am
There's only two ways you get this log wait
1 - Transactional replication that's not properly set up/broken/not running
2 - CDC jobs that aren't running/aren't succeeding.
Nothing else will cause a replication...
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
December 31, 2014 at 3:28 am
You sure you don't also have transactional replication set up?
Are all the CDC jobs running properly? There's more than one and I can't recall which is the one that reads...
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
December 31, 2014 at 3:15 am
Yes, that will affect CDC. No, it's not the way to fix the problem
Check that all the CDC jobs are running correctly and succeeding.
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
December 31, 2014 at 2:49 am
mauriciorpp (12/30/2014)
Keep your app data on a single database. Cross-database queries are bad.
Nothing wrong with cross-database queries. Performance-wise they're the same as queries within a database. There may be some...
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
December 31, 2014 at 1:45 am
KenVickers (12/29/2014)
Well I did say "can" but they are memory objects and wont create anything in tempdb
Myth, completely false.
Table variables are not memory-only, they are allocated space in TempDB, they...
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
December 31, 2014 at 1:40 am
Igor Micev (12/30/2014)
I had 4 update statements (2 updates and 2 merges ) in one transaction and I isolated them in separate transactions.
Which means you no longer have atomicity for...
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
December 31, 2014 at 1:37 am
Please note: 6 year old thread.
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
December 31, 2014 at 1:35 am
Luis Cazares (12/30/2014)
Yes, it's possible, but I wouldn't advice on using decimals on calculations as it's easy to get it wrong.
It's also far less clear than a DATEADD for anyone...
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
December 31, 2014 at 1:32 am
Viewing 15 posts - 6,886 through 6,900 (of 49,552 total)