Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,846 through 34,860 (of 59,099 total)

RE: Grouping a field with slightly simular names in SQL

You bet. Thank you for the feedback.
It would be interesting to find out what the client settles on. If you get a chance, please post back....
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2011 at 6:38 am

#1292874
RE: Triggers

GilaMonster (2/28/2011)
In SQL 2005 and above, the inserted and deleted tables are materialised from the row version store in TempDB, not the transaction log. Hence they do not cause log...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2011 at 6:35 am

#1292873
RE: SSIS Flat File Import with different file layouts

Koen Verbeeck (3/1/2011)
Read the whole file in as one column, then use a conditional split to split the data stream into 3 flows.
For each flow, use a script component to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2011 at 6:24 am

#1292859
RE: Return records at least 10 minutes apart from last valid record without CURSOR

Very cool. Thanks for the feedback, Rob.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2011 at 6:19 am

#1292858
RE: Julian time conversion problem

Jon V (2/28/2011)
Here's an example of data that I'm trying to make sense of:
startdate datetime
starttime int
startdate ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

March 1, 2011 at 6:16 am

#1292855
RE: Grouping a field with slightly simular names in SQL

I don't believe there's a good way to do this. For the two instances you've shown, folks might be quick to say "Substring up to the first space". ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 9:47 pm

#1292707
RE: Update Column Value using After INSERT Trigger on table with no Primary Key

Obviously, you're going to get a whole lot of people that will tell you that you absolutely must have some way to uniquely identify each row, PK or not.
That notwithstanding,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 9:10 pm

#1292701
RE: Julian time conversion problem

Jon V (2/28/2011)
Hi Wayne--The Julian format I'm talking about is the typical format for the Julian calendar. The number I used in the example translates to "1900-03-14 00:00:00" when...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 9:01 pm

#1292699
RE: database size

muthukkumaran (2/28/2011)
gsuvarnarekha (2/28/2011)
Hi,
Is any problem for user having the public role?
Thanks
Rekha
Rekha
Public role couldn't have permision to view that table.
Give the grant VIEW ANY DEFINITION to public role.
I don't know what...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 8:31 pm

#1292695
RE: Pivot Table but Dynamic Columns Not resolved with Dynamic Query.

I don't know much about SSRS but under what circumstances wouldn't you pass a CloseDate parameter to this report?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 8:29 pm

#1292694
RE: Missing row delimeter {CR}{LF} in .txt file

If all the "fields" in the file line up vertically, one of the best bets is to make a "BCP Format File" and use BULK INSERT to load the file.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 8:23 pm

#1292693
RE: Triggers

I guess my question would be... what does the trigger do?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 8:12 pm

#1292688
RE: Triggers

HowardW (2/28/2011)
sqlchanakya (2/28/2011)
Am really looking for an answer or confirmation as how the disabling of a trigger is working. As I mentioned, is this the way that it will log...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 8:06 pm

#1292687
RE: table not using index

Colleen M. Morrow (2/28/2011)
Updates to fields not covered by the index would not cause any extra overhead of maintaining the index, so no concerns there.
"It Depends". If...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 7:57 pm

#1292686
RE: using oSQL utility

I know this is of no help and I apologize for that but I have to know... A billion+ byte SQL Script? What on Earth does it do?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

February 28, 2011 at 7:31 pm

#1292684

Viewing 15 posts - 34,846 through 34,860 (of 59,099 total)