Viewing 15 posts - 3,136 through 3,150 (of 19,560 total)
tchaturvedi (5/19/2014)
ohh ok!! I thought so, just looking some work around other that reinstallation. thanks for all your help.
Nope nothing else could be done in that case.
Good luck
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 19, 2014 at 8:01 am
There is no special name for it. It's just another way of writing a join condition.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 19, 2014 at 7:53 am
KoldCoffee (5/18/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2014 at 10:12 pm
I would say no. It is just DETA afterall. The usual precautions still apply - proceed with extreme caution and know your data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2014 at 10:03 pm
What Gail said is spot on.
If you want to see it in tsql, here is something that will work.
WITH compatversions AS (
SELECT 65 AS MajorVersion ,'SQL Server 6.5' AS ServerVersion
UNION
SELECT...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 18, 2014 at 9:46 pm
Grant Fritchey (5/16/2014)
To address the scan, you need to either have a filter of some kind to reduce the amount of data, or fix the conversion so that the optimizer...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 3:12 pm
See if this article will be of any help.
http://bisherryli.com/2011/03/06/ssis-pass-a-variable-to-a-ole-db-source-in-a-data-flow/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 2:50 pm
The database diagram tool is a lightweight data modeling tool. At least until you have a diagram created that matches your schema.
If you are trying to get a feel...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 2:40 pm
What exactly are you trying to do with these 400+ tables through SSIS in a looping manner?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 2:37 pm
So back to the original questions.
What kind of data flow task? The data flow is essentially just a container for different kinds of tasks. So what kind of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 2:26 pm
nviggiani 99687 (5/16/2014)
Script task inside the foreach loop container
K. FWIW - A script task is not a DF task.
Inside the script task, you need to add your variable to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 2:19 pm
What kind of DF task?
Is your DF inside the foreach containter?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 1:51 pm
As Louis said, do a select len(whateveryourcolumnis) for all of the columns and find which one has lengths that are beyond your target table definitions.
Having a staging table with data...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 1:49 pm
Ed Wagner (5/16/2014)
SQLRNNR (5/16/2014)
Ed Wagner (5/16/2014)
SQLRNNR (5/16/2014)
gyroscopicAxis
Allies
Board Game
Fun times
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 8:15 am
Ed Wagner (5/16/2014)
SQLRNNR (5/16/2014)
gyroscopicAxis
Allies
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 16, 2014 at 8:08 am
Viewing 15 posts - 3,136 through 3,150 (of 19,560 total)