Viewing 15 posts - 5,776 through 5,790 (of 7,168 total)
k.thanigaivel (6/29/2011)
thks all, i suggested NVACHAR for xml type values is it ok?
It depends on what you need to do with the data while it's in the database. Do you...
June 29, 2011 at 12:20 am
forsqlserver (6/28/2011)
IO works among whom?
Can you please clarify? What are you saying "works among whom"?
June 29, 2011 at 12:02 am
usharani.t (6/28/2011)
How to select Records between two dates '06-06-2010' and '06-06-2011' in sql
Here is how you would select rows from a table where a column named date_column had a value...
June 28, 2011 at 11:55 pm
Is this a trick question? Input/Output, meaning disk activity?
June 28, 2011 at 11:52 pm
Whisper9999 (6/28/2011)
Thank you! I was planning on using bcp actually...
No problem. Happy something I said was useful 🙂
June 28, 2011 at 11:51 pm
IceDread (6/27/2011)
I know.. but I still think it's a big flaw.
I am curious...I am not sure what you mean. Maybe it would help if I knew your standard for OS-dependent,...
June 28, 2011 at 11:34 pm
You highlight a sad but true fact about technical managers.
Does your organization give you the time and tools to keep your systems operating?
I have found that for the most part...
June 28, 2011 at 11:12 pm
This thread seems to have hit a stopping point and I have no specific technical information to lend but this looked weird so I thought I would call it out:
INSERT...
June 28, 2011 at 10:48 pm
Performance? I gotta go with a "maybe" (or at least IMHO :-P). On another link, you said it was only about a 10% gain in performance (which isn't...
June 28, 2011 at 10:15 pm
Whisper9999 (6/27/2011)
June 28, 2011 at 5:16 pm
You beat me to it Tom...I was just testing the theory of having all 10 in a Sequence Container (concurrent execution) with the 11th package connected to it with a...
June 28, 2011 at 4:12 pm
Like it matters...its referencing query optimizations for Sybase 11.0 (the current version is 15.5) and the article was written around the time when MSSQL 6.5 was coming out...years after the...
June 28, 2011 at 3:54 pm
I don't think you'll be able to go directly from Service Broker to the Windows Service but please let us know if you find a way to do that because...
June 28, 2011 at 3:11 pm
Hmmm, something must be out of order on your side. I tested the technique before I posted. Here is my POC code:
USE tempdb
GO
CREATE PROC dbo.proc_a
AS
BEGIN
SELECT...
June 28, 2011 at 2:54 pm
Viewing 15 posts - 5,776 through 5,790 (of 7,168 total)