Forum Replies Created
Viewing 15 posts - 2,011 through 2,025 (of 9,643 total)
-
RE: Trying to use output of Temp Table ISS SSIS PAckage
I'm not sure what you are trying to accomplish. Are you just trying to move the data into Excel?
Can't you just use the SQL Statement in the OLE DB...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Derived Column Transform using up to 6 OR Statements
That works. One difference is that you are using numeric data and not strings to do the comparison.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Derived Column Transform using up to 6 OR Statements
I think your issue is that you are using strings in the comparison not numbers. What is the data type of lv? If it is a number stored...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: To Set the Identity Column in SSIS while Import into Text file
We definitely need more information. There really isn't an Identity property for a text file. You'd have to add a column using either ROW_NUMBER() in the query if...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Error Message/Error Handling Issue in SP
You have a couple of options:
1. Instead of using an output parameter in the stored procedure, allow the error to come up to the .NET application. Wrap the...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Are the posted questions getting worse?
SQLRNNR (11/4/2011)
SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
What is this query plan operator?It depends. It could be a hash join, hash aggregate, flow distinct, or a union...
+1
But the physical operator is a...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Are the posted questions getting worse?
SQLRNNR (11/4/2011)
SQL Kiwi (11/4/2011)
SQLRNNR (11/4/2011)
Cadavre (11/4/2011)
Brandie Tarvin (11/4/2011)
SQL Kiwi (11/4/2011)
So, it dependsSomeone so needs to come up with an interview question where this is the exact answer that's needed.
Isn't that...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Are the posted questions getting worse?
Kiara (11/4/2011)
L' Eomot Inversé (11/4/2011)
Kiara (11/4/2011)
Brandie Tarvin (11/4/2011)
Ki,You do remember that Table Variables use TempDB, right?
Yup. But when I've been testing, they seem to do less r/w activity than temp...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Are the posted questions getting worse?
Lynn Pettis (11/3/2011)
Well, my daughter Kirisa was just inducted into the National Honor Society ths evening!Congratulations. That's definitely a big deal.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Best way to transfer data from 1 server to another
Are you going to do a complete cutover to the new servers? I'd suggest restoring backups on the new servers, although I'm not sure you can restore a backup...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Finding datafile sizes for all db on server
seth delconte (11/3/2011)
I use both of these:SELECT DB_NAME(database_id) AS DatabaseName,Name AS Logical_Name,
Physical_Name, (size*8)/1024 SizeMB
FROM sys.master_files
order by SizeMB desc
and
exec sp_MSforeachdb @command1='use [?] exec sp_spaceused'go
You can add FileProperty(Name, 'spaceused') to the first...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: Tracking changes in sys.configurations
Not that i know of. Perhaps a server level DDL trigger, but just taking regular snapshots of sys.configurations is the simplest way.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: OLE DB Destination trimming numbers
Elliott Whitlow (11/3/2011)
I have never seen SSIS do any truncation when the data types were correctly sized. Are you working with these as number data types or as string...Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: updating statistics
sandyinfowave (11/2/2011)
I know updating statistics improves the performance of the queries(selects the best execution plan)...but my question is, i have not created any indexes or any sort of other query...Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
RE: One database, copied to two identical servers. Performance bad on second server. Why?
I'd question whether the servers are the same. Could be storage is better or utilized less on one than the other. Could be that network path is different/slower.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 15 posts - 2,011 through 2,025 (of 9,643 total)