Viewing 15 posts - 91 through 105 (of 8,416 total)
dgowrij (2/19/2013)
Could you please clarify what the below statement actually does?
.value('.[1]', 'varchar(MAX)')Especially the '.[1]'
The value XML method is documented in Books Online:
http://msdn.microsoft.com/en-us/library/ms178030.aspx
The '.[1]' is an XQuery expression, where the '.'...
February 19, 2013 at 12:35 am
akberali67 (2/18/2013)
February 18, 2013 at 5:23 am
ChrisM@Work (2/11/2013)
February 18, 2013 at 2:56 am
SQLFiddle (link) showing the following solution:
DECLARE @data AS TABLE
(
StoreName varchar(50) NOT NULL,
Category varchar(50) NOT NULL,
...
February 18, 2013 at 2:34 am
Steve Jones - SSC Editor (11/9/2012)
February 15, 2013 at 2:49 pm
Lowell (2/15/2013)
If i have to hit shift_alt+0831 or something every time i need a quote-type indicator, instead of a single key stroke, that'd get old real fast.
This made me smile....
February 15, 2013 at 2:35 pm
The C# code could no doubt be improved - I'm not an expert in that language by any means, but it does bear a resemblance to the sort of code...
February 14, 2013 at 1:58 pm
mister.magoo (2/14/2013)
Are you able to share that code, because I would love to learn from it?
Here you go:
USE Sandpit;
GO
/***********************
** Tables and indexes
************************/
CREATE TABLE [dbo].[tblRequests] (
[RequestID] ...
February 14, 2013 at 4:55 am
mister.magoo (2/13/2013)
this version packs 70,000 requests in about 13 seconds on my desktop.
Debug version SQLCLR procedure (without bulk copy) loading the destination table: 1.4s on the same data set.
Time to...
February 13, 2013 at 10:28 pm
GilaMonster (2/13/2013)
February 13, 2013 at 12:51 am
dwain.c (2/12/2013)
Sorry for the basic question but, can you show me where exactly in the execution plan you're seeing this?
Taking the following code as an example (which ran for 5m...
February 12, 2013 at 6:53 pm
dwain.c (2/11/2013)
I found that applying a built-in function to the string to be split in the DelimitedSplit8K function's call has adverse performance effects.
If you look closely at the execution plans,...
February 12, 2013 at 5:29 pm
Hi Colin,
It's quite easy to go mad trying to do this sort of thing in T-SQL today (future things like ordered aggregates might help, I don't know).
A cursor solution is...
February 12, 2013 at 4:13 pm
MyDoggieJessie (2/10/2013)
February 10, 2013 at 1:12 pm
karthik M (2/5/2013)
The conclusion is to use 'OR' instead UNION. Right?
No.
Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query...
February 9, 2013 at 11:14 pm
Viewing 15 posts - 91 through 105 (of 8,416 total)