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]

😎

Simple solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_STATUS') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_STATUS;

CREATE TABLE dbo.TBL_SAMPLE_STATUS

(

Timestamp DATETIME...

DicksonMulwa (4/30/2015)

---

What is the logic used by the DB recovery/Crash Recovery process while recovering uncommitted data. Does it simply rollback all changes? Say, for example, if a database crashes before...

SQLDB101 (5/1/2015)

---

My question is, how can the indexes in Environment-2 fragment so much more quickly than the indexes in Environment-1? Both environments are on exactly the same hardware and have...

WhiteLotus (4/30/2015)

---

Eirikur Eiriksson (4/30/2015)

---

No, you cannot reduce the size of this file without either purging data or...

sharonsql2013 (4/30/2015)

---

I need to divide a number by the number of full weeks based on today's date.

Say today is April 30 which is Week 18th but since its the middle...

Quick thought, looks to me like an overkill unless IMPLICIT_TRANSACTIONS are set ON in either the code or the Server's Connection Properties.

😎

No, you cannot reduce the size of this file without either purging data or compacting/compressing the content.

😎

My...

Good question Steve, I'm chipping in my 2 Cents

😎

Finding a problematic code which hasn't been executed since the last reboot or...