Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on either side of the space delimiter so,...

Jason-368451 (8/6/2014)

---

I have a CSV file that I bulk loaded into a single column staging table.

I need a way to parse proper csv files that are comma delimited with...

brisims34 (6/27/2014)

---

I have been asked to create an auditing trigger on sql server and calls a form (windows, asp.net, or whatever possible) that forces the user on a client workstation...

clucasi (5/27/2014)

---

I have the following XML file and want inserting into a SQL table, the problem I am having is that the XML has two row nodes.

These need to be...

mburbea (5/20/2014)

---

How am I sure sql server actually does the work and doesn't just cheat realize that the first 999 rows don't matter, and only processes the last row? (since...

mburbea (5/20/2014)

---

Here is my current TestEachProc that uses a functions table to make it a bit easier to test.

'

--===== Run the test

SELECT csv.RowNum, split.ItemNumber, split.Item

INTO...

Paul White (5/15/2014)

---

I agree, though one has to ask if...

mburbea (5/14/2014)

---

Since the slowdown seems to be the virtual tally table I'd wonder if a CLR function that just spits out a streaming number table might be able to improve...

Hey there. I am 99.9% positive that the issue is TIMEZONEOFFSET in...

renu.iitkgp (5/9/2014)

---

Hi Solomon,

Thank you for the reply, that is very helpful.

When the memory footprint was so large and it wasn't been freed up, I tried dropping the user defined...

renu.iitkgp (5/8/2014)

---

Hi,

I had to convert huge volumes with datetime fields (given timezone info) to UTC.

Since Sql does not have a native way to do this, I chose to do...

cgreathouse (5/1/2014)

---

Hello

I have a CLR SQL Function with a signature that looks like this...

public static long fnCreateKey(string value)

{

...

}

The function is working fine. However, in SSMS this is what the...

I do not think any authentication will be placed in the SOAP <Header> element. I am not sure about all authentication schemes, but I know that Basic Auth is a...

Hi there. How exactly are you calling the WebService and what type of authentication is being used? I have successfully used Basic Auth and HttpWebRequest for this by setting the...

Yes, a Multistatement TVF (as opposed to an Inline one like I had tried earlier, or even a View) seems to work.

So first this:

CREATE FUNCTION dbo.TestWrapper()

RETURNS @Temp TABLE (IntVal INT)

BEGIN

INSERT...