Viewing 15 posts - 106 through 120 (of 1,162 total)
IT researcher (8/9/2013)
then whether Update is locked for only rows satisfying 'where' condition ? (is it based on value or index or Primary column ?)
As I said in the...
August 9, 2013 at 6:39 am
IT researcher (8/9/2013)
HowardW (8/9/2013)
August 9, 2013 at 4:49 am
That could be a data skew and some form of parameter sniffing and changing MAXDOP has just had a lucky effect on compiling a stable plan that is good enough...
August 9, 2013 at 2:33 am
sys.dm_exec_requests is the DMV with this information. There's a blocking session ID column. If you want something pre-packaged and easy to use in the future, I'd recommend sp_whoisactive.
Read committed snapshot...
August 9, 2013 at 1:59 am
Have you checked with the VMware/Server Team? Maybe they're running snapshots backups of the VM, or doing some other maintenance on the host which is causing the VM layer to...
August 8, 2013 at 10:30 am
ChrisM@Work (8/8/2013)
Howard - the name of the guy made me chuckle, given the pidgin English 😀
Check out the strap-line under the logo on the website as well. Comedy gold....
August 8, 2013 at 6:04 am
I'd normally report this as spam, but the name of the company made me chuckle. At least it's honest 😀
August 8, 2013 at 5:07 am
The position in the where clause isn't relevant (other than when it changes the semantics, e.g with AND/OR combinations), the optimiser will use statistics and indexes to work out the...
August 7, 2013 at 10:00 am
The multiple parameter value option in SSRS is for end users to select multiple items. It would be pretty unusual for an end user to select 20975 different items in...
August 7, 2013 at 3:27 am
It depends. If the two tables you're merging have the same clustered index/key, MERGE can be very efficient, it's certainly quite clean code-wise, but generally speaking, separate INSERT and UPDATE...
August 6, 2013 at 10:33 am
mah_j (8/6/2013)
This is...
August 6, 2013 at 4:23 am
Erland Sommarskog (7/31/2013)
HowardW (7/31/2013)
my point was just that it's not all just T-SQL behind the scenes.
And my point is that that's exactly what it is - even if there is...
July 31, 2013 at 6:31 am
Erland Sommarskog (7/31/2013)
Horribly enough, I've seen people accessing DMO from T-SQL, through sp_OAmethod. SMO should be possible to access through a CLR stored procedure.
Ha! Actually, from what I've heard, you...
July 31, 2013 at 6:16 am
Erland Sommarskog (7/30/2013)
Keep in mind that SSMS has no secret interface to SQL Server, but it uses T-SQL just like you and me.
Well, mostly. Not that it's secret, but it...
July 31, 2013 at 5:59 am
Grant Fritchey (7/23/2013)
July 29, 2013 at 9:11 am
Viewing 15 posts - 106 through 120 (of 1,162 total)