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...
-
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.
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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.
-
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...
-
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...
-
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.
-
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... -
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... -
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.
Viewing 15 posts - 2,011 through 2,025 (of 9,643 total)