Viewing 15 posts - 4,606 through 4,620 (of 49,571 total)
If you're running under read committed snapshot, then why the nolock hint?
Under read committed snapshot, read queries don't take locks anyway, so all the nolock is doing is adding...
October 6, 2015 at 6:09 am
Commands do not undo themselves!
Either your original update didn't actually update any rows, or some other process was explicitly updating the data back. SQL will not randomly undo data...
October 6, 2015 at 4:18 am
There's nothing wrong with the update you posted, and providing there are rows with someField = 'OldValue', it'll work fine and doesn't need to be changed. Now if there are...
October 6, 2015 at 3:59 am
Probably not. It might even make the locking worse, as there will be less IO-related waits.
Buffer cache hit ratio's useless. A server can be under severe, sustained memory pressure and...
October 6, 2015 at 3:58 am
Implicit conversions most likely. Also they're much larger data types than you need. A GUID stored in a nvarchar column will take 72 bytes, vs 16 if stored in a...
October 6, 2015 at 3:56 am
No. Insufficient permissions will get you an error.
If you're sure there's no transaction (and that implicit transactions isn't on), then either someone else is running an update to reverse it,...
October 6, 2015 at 3:44 am
Either you're running the update in a transaction and not committing it, or someone else is running updates to reverse the changes, or someone's restoring the database from a backup.
The...
October 6, 2015 at 3:29 am
I'd go instead with https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Eirikur's query will show individual queries with high CPU usage, but by using just that you may miss the queries which are running very, very frequently.
Which...
October 6, 2015 at 2:52 am
Welsh Corgi (10/5/2015)
I have 1 Table has been refreshed since the 29th of October.I checked other tables and they are being refreshed.
How can I identify and correct the problem?
Considering that...
October 5, 2015 at 3:31 pm
Jeff Moden (10/5/2015)
Just curious as to why you wouldn't shrink it to zero and regrow it properly.
Huh? I said 'don't shrink it to zero', as in don't DBCC SHRINKFILE (2,0),...
October 5, 2015 at 3:18 pm
No.
October 5, 2015 at 3:06 pm
yb751 (10/5/2015)
The upcoming 'Stretch Database' feature in SQL 2016 may be exactly what you are looking for.
With poor queries, that'll just make matters worse. If the queries can't eliminate...
October 5, 2015 at 9:00 am
ps_vbdev (10/5/2015)
October 5, 2015 at 8:42 am
Please post the most common queries.
Also, why Datetimeoffset? It's not a common data type choice, especially since it's not daylight savings aware, which reduces the usefulness of storing a time...
October 5, 2015 at 7:30 am
ps_vbdev (10/5/2015)
October 5, 2015 at 6:55 am
Viewing 15 posts - 4,606 through 4,620 (of 49,571 total)