Viewing 15 posts - 811 through 825 (of 1,219 total)
curious_sqldba (8/20/2013)
In sys.sysprocesses wait type is always 'SOS_SCHEDULER_YIELD' when my CTP is 5 and MAXDOP is 0, what do you want me to check in sys.dm_os_tasks ?
How many rows there...
August 20, 2013 at 9:01 am
The query you posted uses group_concat() which is not a function in SQL Server. That smells MySQL to me, but I could be wrong. Furthermore, the error message you posted...
August 20, 2013 at 1:37 am
curious_sqldba (8/19/2013)
The server on which i see this issue doesn't have hyperthreading enabled ( msinfo32 shows physical=logical).Is that the reason why i see twice the number of cores being used?
So...
August 19, 2013 at 4:13 pm
Well, distributed queries, even more distributed transactions, often causes pain, so there is all reason to avoid them if you can. But if your developers have painted them so much...
August 19, 2013 at 4:09 pm
opc.three (8/19/2013)
August 19, 2013 at 4:03 pm
Jeff Moden (8/19/2013)
Reorganizing also compacts the index pages. Any empty pages created by this compaction are removed providing additional available disk space....
August 19, 2013 at 4:01 pm
IgorMi (8/19/2013)
It is not good to shrink without rebuild.If you shrink and rebuild after then it's ok.
No, it may be OK. In this case, the jfgrocha removed 200 GB of...
August 19, 2013 at 8:22 am
SQLSteve (8/19/2013)
Even with the below, I get syntax errors it still doesnt run through. It doesn't like the dash
EXEC msdb.dbo.sp_add_job
@job_name=N' + dbo.quotestring(@DatabasenameInput + '- backup Job') +...
August 19, 2013 at 7:08 am
REORGANIZE essentially performs a bubble-sort of the index. The pages are not changed, so if a page is only 50 % full, it will remain 50% full. Possibly, REORGANIZE could...
August 19, 2013 at 5:58 am
opc.three (8/19/2013)
DECLARE @sql NVARCHAR(MAX) = N'';
SELECT @sql += 'EXEC LoadFile ' + QUOTENAME(FILENAME, '''')...
August 19, 2013 at 3:24 am
vignesh.ms (8/19/2013)
this gives the ans but difficult to understand that's why....
I assume that this is response to my post.
I suggest that you study the query piece by piece. The first...
August 19, 2013 at 3:22 am
By adding the appropriate calls to sp_trace_event. You find the documentation for sp_trace_event in Books Online. The codes for the events and columns are available in sys.trace_events and another DMV...
August 19, 2013 at 1:18 am
No, ALTER INDEX REORGANIZE is not going to help if you are to shrink a database. REBUILD may do, as you may end up with fewer extents allocated to the...
August 19, 2013 at 1:14 am
kapil_kk (8/18/2013)
Thanks Erland for the info...
one more thing I saw in your code is that you write
FETCH cur INTO @filenameonly once inside the loop....
Yes. It is common to see...
August 19, 2013 at 1:09 am
hlsc1983 (8/18/2013)
"SQLManagementStudio_x64_ENU.exe is NOT SSMS! Confusing filename, huh? It includes only the basic management tools (e.g., Configuration Manager) and...
August 19, 2013 at 1:05 am
Viewing 15 posts - 811 through 825 (of 1,219 total)