Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables to solve a...

jasona.work (10/30/2015)

---

Brandie Tarvin (10/30/2015)

---

Someone needs to have a talk with that David Burrows guy. He's talking crazy in another thread. Like suggesting I could use SQL Server tables to solve...

Thank you all for giving this a try;-)

😎

(mis) Quoting William Edward Hickson

Tis a lesson you should heed:

Try, try, try again.

If at first you don't succeed,

Try, try, try again.

that's 15...

Piling on, this is a perfect case for TRY_CONVERT, unfortunately not available before 2012

😎

Further on Luis's fine answer, works fine and unless there is something else affecting the code that we don't know of, then there isn't much to do;-)

😎

You can add some...

Ed Wagner (10/29/2015)

---

That's pretty slick, Eirikur. I appreciate how you use string replacement using the rows in sys.databases to generate the final SQL to fire. I've noticed that...

Ed Wagner (10/29/2015)

---

Jeff Moden (10/29/2015)

---

Ed Wagner (10/29/2015)

---

That's pretty slick, Eirikur. I appreciate how you use string replacement using the rows in sys.databases to generate the final SQL to fire....

New persopn (10/29/2015)

---

Hi All,

I need out put in single row for below 2 queries using joins

SELECT [total_physical_memory_kb] / 1024 AS [Total_Physical_Memory_In_MB],

CPU_Count AS NumberofCPU

FROM [master].[sys].[dm_os_sys_memory]

CROSS JOIN sys.dm_os_sys_info

SELECT d.NAME,(SUM(mf.size) * 8 /...

To get the information on the XML Schema collections use the sys.xml_schema_collections view and the xml_schema_namespace function

😎

SELECT

SXSC.name

FROM sys.xml_schema_collections SXSC;

SELECT xml_schema_namespace(N'[RELATIONAL SCHEMA]',N'[XML SCHEMA...

Admingod (10/28/2015)

---

I am populating all the table information to main table on daily basis based on date time stamp. However, how to create a script to query against the table....

No, you have to monitor/audit it yourself. Normally I use...

Quick question, Luis's suggestion points to the same...

Ed Wagner (10/28/2015)

---

Eirikur Eiriksson (10/28/2015)

---

Ed Wagner (10/28/2015)

---

allnelsons (10/28/2015)

---

So, question about these splitter functions (which are pretty much the most used tools in my arsenal, btw!), are they faster/more efficient being...

Ultimate tensile strength (UTS)

Tension