Viewing 15 posts - 4,936 through 4,950 (of 8,761 total)
mw112009 (7/13/2015)
create table abc( lab_id varchar(10), lab_time datetime, lab_name varchar(100) )
INSERT INTO abc( '10001' , '2015-07-13 14:01:023' , 'K' );
INSERT INTO abc( '10001' , '2015-07-13 14:01:023' , 'K' );
INSERT INTO...
July 13, 2015 at 3:09 pm
robert.wiglesworth (7/13/2015)
select * from #temp t where t.color in ('red','blue')
and still get record number 4 because red...
July 13, 2015 at 2:45 pm
SQLRNNR (7/13/2015)
July 13, 2015 at 2:33 pm
robert.wiglesworth (7/13/2015)
create table #test
(id int
,color varchar(20)
)
insert into #test
(id, color)
values
(1, 'blue'),(2, 'red'),(3,'green'),(4,'red,green')
In this example, if I wanted to run a query to select any records...
July 13, 2015 at 2:22 pm
Mikael Eriksson SE (7/13/2015)
Doing it with a ten million leaf nodes instead of just four might deliver quite different results. :hehe:
FYI: the plan will be identical regardless of what your...
July 13, 2015 at 2:12 pm
Mikael Eriksson SE (7/13/2015)
Eirikur Eiriksson (7/13/2015)
SELECT
NAME.DATA.value('.','NVARCHAR(128)')
FROM @TXML.nodes('//name') AS NAME(DATA)
SET STATISTICS TIME,IO OFF;
SET STATISTICS IO,TIME ON;
SELECT
NAME.DATA.value('.','NVARCHAR(128)')
FROM @TXML.nodes('/STUFF_FROM_MSDB/SYSTABS/name/text()') AS NAME(DATA)
//name and /STUFF_FROM_MSDB/SYSTABS/name/text() is not...
July 13, 2015 at 2:07 pm
BG101 (7/13/2015)
July 13, 2015 at 1:46 pm
TomThomson (7/13/2015)
Eirikur Eiriksson (7/13/2015)
This is a very trivial example, the structure of the XML and the size makes it ill fit for any performance testing.😎
Yes, quite so. 😎
Doing it...
July 13, 2015 at 1:35 pm
Further on the discussion, here is a small test sample
😎
USE msdb;
GO
SET NOCOUNT ON;
DECLARE @TXML XML = (
SELECT --TOP 200
*
FROM sys.tables ST
INNER JOIN...
July 13, 2015 at 1:08 pm
SQLRNNR (7/13/2015)
Mikael Eriksson SE (7/13/2015)
SELECT
col.value('(Title/text())[1]', 'varchar(50)') AS 'Book'
FROM @x.nodes('/root/Books/Book') a(col)
Using text() in the values clause removes one call to...
July 13, 2015 at 12:40 pm
Jeff Moden (7/13/2015)
July 13, 2015 at 10:07 am
chgn01 (7/13/2015)
try './/Book'
Will work but it's far more expensive to traverse the structure than to do a direct reference.
😎
July 13, 2015 at 9:56 am
rahmanagg (7/13/2015)
I'm working on a project comparing the performance of SQL and NoSQL database (MongoDb). I'm focusing on "insert, select, delete and update operations. I am trying to...
July 13, 2015 at 9:42 am
jackfh (7/13/2015)
I don't think that's it, our older prod instance appears to be configured the same way. I've tried logging in as domain admin and local admin.
Suggest you...
July 13, 2015 at 8:21 am
GilaMonster (7/13/2015)
Brandie Tarvin (7/13/2015)
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
YAY!
What is the degree in?
M.Sc...
July 13, 2015 at 4:57 am
Viewing 15 posts - 4,936 through 4,950 (of 8,761 total)