How many rows there...

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...

So...

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...

opc.three (8/19/2013)

---

Can you please elaborate? I use this technique quite often and am interested to know what you mean by "as the correct result of SELECT statement is undefined". Is...

Jeff Moden (8/19/2013)

---

I'm pretty sure that's not true. From BOL:

Reorganizing also compacts the index pages. Any empty pages created by this compaction are removed providing additional available disk space....

No, it may be OK. In this case, the jfgrocha removed 200 GB of...

SQLSteve (8/19/2013)

---

Erland,

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') +...

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...

opc.three (8/19/2013)

---

Here is a non-cursor option, just for the sake of having an alternative to using a cursor:

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += 'EXEC LoadFile ' + QUOTENAME(FILENAME, '''')...

I assume that this is response to my post.

I suggest that you study the query piece by piece. The first...

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...

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...

kapil_kk (8/18/2013)

---

Yes. It is common to see...

hlsc1983 (8/18/2013)

---

i came across this . can u kindly verify this

"SQLManagementStudio_x64_ENU.exe is NOT SSMS! Confusing filename, huh? It includes only the basic management tools (e.g., Configuration Manager) and...