Matt Miller (#4) (5/1/2015)

---

only word of caution would be to check where the BEGIN TRAN is. I've seen a few doozies where the "rollback" is in a child/subprocedure and...

Didn't know that was possible:-P

😎

Jeff Moden (5/1/2015)

---

Heh... I cringe every time I see something like this where the human isn't compelled to take an action such a log out. The simple solution...

WhiteLotus (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

That is probably fine, that would be 5120MB or...

Grant Fritchey (5/1/2015)

---

Eirikur Eiriksson (5/1/2015)

---

TRY / CATCH is as valid / useful in SELECT as...

That is probably fine, that would be 5120MB or 5242880KB

😎

Brand

WhiteLotus (5/1/2015)

---

I want to make clear here .. it is not disk space problem but the problem is data file is too big for some user databases . One of...

Brandie Tarvin (5/1/2015)

---

The problem is that I can't nuke the OS. Corporate has to build servers (we're not allowed) and we had to pull teeth in order to get our...

Direction

That's a giant leap, maybe 3328 Mb would be...

TRY / CATCH is as valid / useful in SELECT as in other DML code,...

Quick suggestion

😎

use mysql1

;WITH XMLNAMESPACES('http://schemas.openehr.org/v1' as bp,'http://www.w3.org/2001/XMLSchema-instance' as xsi,'OBSERVATION' as type)

select * from (

select

m.c.value('(/bp:magnitude/text())','int') as systolisch

from

[schema_name].[table_name] [alias]

cross apply [alias].[xml column name].nodes('/bp:content/bp:data/bp:events/bp:data/bp:items/bp:value') as m(c))m;

New Born DBA (4/30/2015)

---

Hi All, can someone tell me the complexity of converting a MySQL Database into a MS SQL Database? Is there a guideline I can use? I just...

Quick suggestion have a look at Glen Berry's article Balancing Your Available SQL Server Core Licenses Evenly Across NUMA Nodes[/url]

😎