Viewing 15 posts - 11,941 through 11,955 (of 14,953 total)
I'm not sure what you mean when you say you are trying to log in to SSIS.
Normally, the way I get into SSIS is by opening Visual Studio. That...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 22, 2008 at 7:30 am
I'm a firm believer in making communication as personal as possible.
I'll put requests in writing (that way there's a record), but I prefer face-to-face or voice-to-voice (phone, voice-chat, etc.), over...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 22, 2008 at 7:24 am
samsql, I still need you to clarify what you're asking for when you mention cases.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 22, 2008 at 6:54 am
I found a solution. It's based on the way OLE DB works. Turns out that it scans a few rows of the Excel file, figures out what data...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 19, 2008 at 2:30 pm
I recently set something up to import Excel files from a directory, with different names for the files. In order to get it to work, I had to build...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 19, 2008 at 12:35 pm
Yeah, an indexed (persisted) view would help with lazy spooling. That makes sense.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2008 at 10:16 am
You're welcome. Glad I could help.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2008 at 9:01 am
SQL Server can handle 20- to 100-million rows no problem, so long as they are well-designed.
The problem isn't the number of rows, it's the overhead from processing metadata that way.
If...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 18, 2008 at 8:59 am
The first thing I'd do is look at the execution plan for the query and see what's going on with that. Are there table scans? Index scans? ...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2008 at 7:23 am
Have you looked at adding XML indexes to the columns?
I've found that parsing out XML is a major performance hog, but with XML indexes it becomes fast and painless.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2008 at 7:09 am
I'm not sure I follow your question. Are you asking how to select a computed column, or how to create one? You can't use one computed column in...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2008 at 7:02 am
You can use OpenQuery to pull data from the ADSI. For example (secure data removed):
ALTER VIEW [dbo].[vwActiveDirectory]
AS
SELECT
CAST(objectGUID AS BINARY(16)) AS ActiveDirID,
CAST(SAMAccountName AS VARCHAR(20))...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 17, 2008 at 6:54 am
I have a CLR proc that clears the files out of a directory prior to another proc writing files to that directory. I have a CLR function that calls...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 16, 2008 at 12:37 pm
I just tested this:
create table #T (
PT_Window_ID varchar(50),
PT_UD_Key varchar(50),
PT_UD_Number int,
STRGA255 varchar(50))
insert into #T
select 'SOPENTRY','L100011',4,'MANUFACTURER' union all
select 'SOPENTRY','L100011',6,'SHIP' union all
select 'SOPENTRY','L100011',8,'PACK' union all
select 'SOPENTRY','L100011',14,'VESSEL'
SELECT PT_Window_ID, PT_UD_Key, [4], [6], [8], [14]
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 16, 2008 at 8:03 am
Perry Whittle (9/15/2008)
also, SQL2005 is able to address as much RAM as the NOS will allow 😉
Depending on the edition of SQL Server, of course.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 16, 2008 at 7:09 am
Viewing 15 posts - 11,941 through 11,955 (of 14,953 total)