Viewing 15 posts - 1,936 through 1,950 (of 2,458 total)
Without using parsename:
;WITH sample_data(val)
AS
(
SELECT '1.9999-Q1'
UNION SELECT '01.9999-Q11'
)
SELECTval,
part1 = substring(val,1,charindex('.',val)-1),
part2 = substring(val,charindex('.',val)+1,(charindex('-',val)-charindex('.',val))-1),
part3 = substring(val,charindex('-',val)+1,...
-- Itzik Ben-Gan 2001
June 19, 2014 at 9:37 am
rightontarget (6/16/2014)
I have a table:
id pallet color
1 a red,blue
2 ...
-- Itzik Ben-Gan 2001
June 16, 2014 at 3:17 pm
This click takes less than a second in staging and about 33 seconds in production.
A common cause of this kind of problem is when critical indexes are not moved...
-- Itzik Ben-Gan 2001
June 16, 2014 at 10:28 am
This Database used to be in simple recovery model and I did change it to Full now. I am taking T-log backup and full backup .
No, no... My apologies...
-- Itzik Ben-Gan 2001
June 13, 2014 at 12:36 pm
Doctor Who 2 (6/12/2014)
Alan.B (6/11/2014)
-- Itzik Ben-Gan 2001
June 13, 2014 at 11:12 am
Users say a lot of things...
A few questions to help you sort this out:
1) Do you track your DB growth? Do you have any idea how fast this DB...
-- Itzik Ben-Gan 2001
June 12, 2014 at 12:02 pm
...what's missing from Standard SQL edition where parallelism is concerned. I thought it was only for special index operations... are we talking about two different things?
I just wanted to add...
-- Itzik Ben-Gan 2001
June 11, 2014 at 3:08 pm
I am going to make a wild guess and say that you are in Albuquerque, NM or somewhere nearby? I don't know much about that market but know that there...
-- Itzik Ben-Gan 2001
June 11, 2014 at 10:52 am
Can anyone help me build a FLOWR-based query that produces the same result as the pure XPath one?
I don't know if that is possible. I thought I saw an article...
-- Itzik Ben-Gan 2001
June 10, 2014 at 5:23 pm
Premièrement, je ne parle pas français. Je n'ai pas une solution complète mais cela devrait aider...
passer à l'anglais(switching to English)...
OK. You have the following data:
-- données de l'échantillon
IF...
-- Itzik Ben-Gan 2001
June 9, 2014 at 3:44 pm
I think we could figure this out a little easier if you included the query plan the each query produces. Could you run this with " include actual query plan"...
-- Itzik Ben-Gan 2001
June 8, 2014 at 7:03 am
clucasi (5/28/2014)
...the problem I am having is that the XML has two row nodes.
The deal with two nodes with the same name you could refer to them by their position....
-- Itzik Ben-Gan 2001
June 5, 2014 at 3:55 pm
Eirikur Eiriksson (5/28/2014)
😎
USE tempdb;
GO
DECLARE @TXML XML = N'<?xml version="1.0"?>
<CommonEventData>
<Row>
<CallSource>999</CallSource>
<CallerCityStateZipCode>
</CallerCityStateZipCode>
<CallerName>TEST</CallerName>
<CallerPhone>TEST</CallerPhone>
</Row>
<Row>
<Beat>E27</Beat>
<MultiEventId>0</MultiEventId>
<PrimaryUnitId>E09A1</PrimaryUnitId>
</Row>
</CommonEventData>'
SELECT
MAX(RO.W.value('CallSource[1]','NVARCHAR(50)') ...
-- Itzik Ben-Gan 2001
June 5, 2014 at 3:44 pm
You could go with:
SELECT cast(8999999*rand() as int)+1000000
For multiple rows you could go with:
SELECT cast(8999999*rand(cast(newid() AS varbinary)) as int)+1000000
FROM <something>
Edit: typo
-- Itzik Ben-Gan 2001
June 5, 2014 at 1:27 pm
I just read this. Great work Don. Very thorough and a really good read. I am looking forward to the rest of the SQL Server Security stairways!
-- Itzik Ben-Gan 2001
June 4, 2014 at 6:32 am
Viewing 15 posts - 1,936 through 1,950 (of 2,458 total)