Viewing 15 posts - 5,416 through 5,430 (of 8,761 total)
Few points
😎
polkadot (5/2/2015)
1) Import the file line by line into a staging table and parse it from there. This method is common when importing multi-document-type files.
The...
May 2, 2015 at 11:58 pm
Here is a partial solution, it matches the city/state but does not remove them from the address.
😎
Sample data
USE tempdb;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.TBL_ADDRESS_WORKTABLE') IS NOT NULL DROP TABLE dbo.TBL_ADDRESS_WORKTABLE;
CREATE TABLE dbo.TBL_ADDRESS_WORKTABLE
(
...
May 2, 2015 at 11:22 pm
Talib123 (5/2/2015)
How long should the latest TLOG backups be kept on tape before the media is recycled. Some suggest 2 weeks. This seems very short to me.
Corruption issues could be...
May 2, 2015 at 2:11 pm
Quick question, are you using Full Text Search?
😎
May 2, 2015 at 1:01 pm
Jeff Moden (5/2/2015)
May 2, 2015 at 12:22 pm
Such reliance on defaults never ceases to amaze me. First thought is ignorance and competence, finding databases on the OS drive when the server has 15K spinners for the data...
May 2, 2015 at 11:58 am
Quick suggestion, use cross tab aggregation, here is an example
😎
-- if temp table exists...drop it
if object_id('TempDB..#exams','U') is not null
drop table #exams
-- create...
May 2, 2015 at 10:02 am
jerald.wilks (5/1/2015)
I am using SSIS 2008 to attempt to send data to a web service. The web service contains complex types which are not supported within Web Service Tasks. I...
May 2, 2015 at 9:03 am
Jeff Moden (5/2/2015)
Eirikur Eiriksson (5/2/2015)
Quick suggestion, use the GETDATE() function in T-SQL😎
Heh... it wouldn't be "quick" though because it wouldn't be SARGable if the same formula the OP used were...
May 2, 2015 at 8:50 am
KGJ-Dev (5/1/2015)
thanks for your reply.
I Eirik,
before i though of posting on this forum, i thought about using Jeff's delimit function what you have suggested. But i am sorry that...
May 2, 2015 at 8:43 am
polkadot (5/1/2015)
Have read this article and tried suggestions: http://stackoverflow.com/questions/10888616/why-is-ssis-complaining-that-there-is-a-partial-row-at-the-end-of-the-file
have read this KB article stating it is a known bug with a SP fix for 2005...
May 2, 2015 at 8:37 am
Quick example
😎
USE tempdb;
GO
SET NOCOUNT ON;
GO
/* SMALLINT MAX = 65535 */
DECLARE @SAMPLE_SIZE INT = 65535;
;WITH T(N) AS (SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL)) AS X(N))
, NUMS(N)...
May 2, 2015 at 8:09 am
TomThomson (5/1/2015)
Revenant (5/1/2015)
Ed Wagner (5/1/2015)
whereisSQL? (5/1/2015)
Eirikur Eiriksson (5/1/2015)
Ed Wagner (5/1/2015)
Eirikur Eiriksson (5/1/2015)
crookj (5/1/2015)
SQLRNNR (5/1/2015)
totemTikki
Raita
Yogurt
Skyr
Lactose
Milk
Run
away
Train
May 2, 2015 at 5:05 am
Quick suggestion, generate the sequential bits separately and use the stuff function to merge it into the guid.
😎
May 2, 2015 at 5:03 am
Quick thought, schema qualify the table name by adding the schema name + dot prefix.
😎
May 2, 2015 at 4:55 am
Viewing 15 posts - 5,416 through 5,430 (of 8,761 total)