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

...

Start by having a look at these two articles

😎

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/url]

Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs[/url]

Quick question, have you tested if @i ever becomes NULL?

😎

WHILE @i IS NOT NULL

...

SELECT @i = min(Id) FROM @Alarms WHERE id > @i

I prefer using Extended Events when working with MARS result sets, little bit more work but cleaner to process especially if you take the result straight into Excel or PowerBI.

😎

One...