Lamprey13 (4/8/2011)

---

Probably not important, but you can also make sure of the DATENAME function, that way sql will handle localizing the name of the month is that should ever be...

steve smith-401573 (4/8/2011)

---

Well, I finally figured out that bcp is an .exe requiring a command window. However, I want to specify an input file rather than enter the query,...

I have not tried it within SSIS but the OUTPUT clause will generate a resultset for you with your ID that you may be able to pipe into a variable...

I thought so too so I figured I would share it. The performance benefits are enough reason to add it to the toolkit. The fact that it reads a bit...

Test the execution plans but my testing shows this form of the query perform a bit better than the DELETE...IN method:

-- Credit to Itzik for exposure to technique

WITH ...

Some random thoughts...

1. MSIS = Microsoft Integration Services? Maybe a local Windows account or Domain account accessing the server via an AD group?

2. Re: the logging table you have setup...do...

steve smith-401573 (4/8/2011)

---

I apologize for the confusion. Let's try this: SS 2008 SE database TABLE aggregates system logs from multiple servers for multiple 'customers'. The requirement is...

BCP would be an excellent solution IF I knew the output file format. Where will I find the definition(s) for truncation that SSMS provides? When I examine an...

ISNUMERIC was not changed from 2000 to 2005 with respect to a single decimal point. This returns 1 on 2000 and 2005:

SELECT ISNUMERIC('.') ;

which happens in support of the...

Keep going...your query is subject to a data-driven bug.

CREATE TABLE #temptable(tranName varchar(1),planname varchar(20), priority int)

INSERT INTO #temptable VALUES ('a','plan1',1)

INSERT INTO #temptable VALUES ('a','plan2',2)

INSERT INTO #temptable VALUES ('c','plan3',3)

INSERT INTO #temptable VALUES...

It has to do with the optimizer and how much "smarter" it has gotten since 2000. In your situation however you are experiencing a regression as a result of improvements...

Dominic Gagné (4/8/2011)

---

Hi,

I need to extract data from a linked server by using a StoredProc with a parameter. I wanted to store the result in a temporary table...

Here is a good start explaining how NULLs are tracked by the storage engine at the page level in non-sparse columns: http://www.sqlskills.com/BLOGS/PAUL/post/Misconceptions-around-null-bitmap-size.aspx

And some info about Sparse Columns: http://www.sqlskills.com/BLOGS/PAUL/category/Sparse-Columns.aspx

I do not know what the proc is doing so I may be completely off the grid here...but I can't get over the assumption that you should even be in...

I agree with Dan. I categorize this kind of work into the sysadmin domain which is not a strength of SSIS.

What you've described is a need to sync a...