Viewing 15 posts - 6,886 through 6,900 (of 49,571 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
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...
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...
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....
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,...
January 4, 2015 at 10:00 am
SQL Guy 1 (1/2/2015)
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...
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...
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...
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.
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...
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...
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...
December 31, 2014 at 1:37 am
Please note: 6 year old thread.
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...
December 31, 2014 at 1:32 am
Viewing 15 posts - 6,886 through 6,900 (of 49,571 total)