Strongly suggest that you use Ola Hallengren's SQL Server Maintenance Solution[/url]

😎

moosamca (12/9/2016)

---

Hi All,

COuld you please help me to tune the below query. I have attached the query plan of this query. Its going ont he nested loop and its cost...

Start by removing the redundant tables which are cross joined in the from clause, not used in the query so why are they there?

😎

wtpart A1,

epmdocument A2,

epmbuildrule A3,

epmreferencelink...

GA_SQL (12/9/2016)

---

i got the requirement exactly.. i have schema called dbo.table1,dbo.table2 that has to be copied (not transfer) dbonew.table1,dbonew.table2 (with in same db), this below script transfers the name since...

Hari-250426 (12/8/2016)

---

Your solution works pretty good. Simpler as well.

Just one question. Does this syntax work with older versions of SQL Server as all our clients won't be having SQL Server...

Haven't had time to look at it and frankly, I wouldn't bother with sp_xml_preparedocument as the XQuery methor is much better.

😎

Question, will you be running other services on the server, i.e. SSIS,SSRS,SSAS etc.?

😎

With 160Gb memory on the server, I would suggest to set the SQL Server Max Memory to 128Gb...

Eric M Russell (12/7/2016)

---

Think of a database table as a library shelf containing books. When you pull a book from the shelf, the self doesn't get smaller. It just contains...

Just sent you a...

If you are either copying all or majority of the objects, I would suggest doing a backup and restore with a different name, then drop anything that is not needed.

😎

You will need to script out all objects in the source db, then create...

ALTER SCHEMA schema_name TRANSFER transfers...

Siten0308 (12/6/2016)

---

Hello everyone,

so i am wondering, how does cardinality estimator fit in with running the execution plan, is it help give the results of estimate, or part of the actual...

First a question, can you explain why you want to do this?

😎

There are several ways of doing this, some good and some bad, unfortunately the T-SQL ones are not...

Quick suggestion, use XQuery, here is an example

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @XML_DOC XML = '<?xml version="1.0" encoding="UTF-8"?>

<DespatchAdvice xmlns="urn:oasis:names:specification:ubl:schema:xsd:DespatchAdvice-2" xmlns:clm5639="urn:un:unece:uncefact:codelist:specification:5639:1988" xmlns:ext="urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2" xmlns:ccts="urn:un:unece:uncefact:documentation:2" xmlns:cct="urn:un:unece:uncefact:data:specification:CoreComponentTypeSchemaModule:2" xmlns:cac="urn:oasis:names:specification:ubl:schema:xsd:CommonAggregateComponents-2" xmlns:clmIANAMIMEMediaType="urn:un:unece:uncefact:codelist:specification:IANAMIMEMediaType:2003" xmlns:udt="urn:un:unece:uncefact:data:specification:UnqualifiedDataTypesSchemaModule:2" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:clm66411="urn:un:unece:uncefact:codelist:specification:66411:2001" xmlns:clm54217="urn:un:unece:uncefact:codelist:specification:54217:2001" xmlns:cbc="urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2" xmlns:qdt="urn:oasis:names:specification:ubl:schema:xsd:QualifiedDatatypes-2">

...