Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,651 through 25,665 (of 59,102 total)

RE: i want to generate sequence number in SSIS

manibad (10/13/2013)
Phil Parkin (10/13/2013)
A brief Google search led me to this [/url]article.
It's not difficult, but it's much easier (and almost certainly faster) if you can do this in T-SQL instead.
thanks...
--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)

October 13, 2013 at 10:03 am

#1658126
RE: Need Help on Fastest Search Logic

born2achieve (10/13/2013)
Hi Jeff,
am back,
i got one more tricky situation from my client. i frightened to hear about this concept from them. the concept will be i will have to take...
--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)

October 13, 2013 at 9:37 am

#1658125
RE: Need Help on Fastest Search Logic

lnardozi 61862 (10/13/2013)
At this point, you're better off just creating a full text index on table2 and searching it. You can join it to table2 and perform LIKE '%a%' on...
--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)

October 13, 2013 at 8:31 am

#1658122
RE: Find value of cell from header name and row name (like going down and across)

PiyaKaGhar (10/11/2013)
Hi can I insert image to show,
UPDATE [dbo].[pro]
SET [Test] = <Test, nchar(10),>
,[100] = <100, nchar(10),>
...
--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)

October 12, 2013 at 11:30 am

#1658083
RE: Reason for Column statistics

Yuri55 (10/12/2013)
Just curious- how column statistics that is not part of any index is used?
Thanks
It can help the optimizer figure out whether or not to actually use an index,...
--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)

October 12, 2013 at 11:20 am

#1658082
Reply To: Fragmentation doesn't changes after index rebuilding

Alan.B (10/11/2013)
sandeep singh-337370 (10/11/2013)
Guys,
One of the other project's guys in my company asked me to improve the performance of their databases.
Keeping your indexes un-fragmented will help performance. That said, I...
--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)

October 12, 2013 at 11:12 am

#1658081
RE: Are the posted questions getting worse?

L' Eomot Inversé (10/11/2013)
It must be really nice to have every company bugeting in step
They don't, really. Like so many other countries, many company's budget year is different than...
--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)

October 12, 2013 at 10:45 am

#1658079
RE: running tsql from filetable

And with that and the fact that I've seen many people try to do the same thing, I guess now would be a great time to ask...
... what's wrong with...
--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)

October 12, 2013 at 9:10 am

#1658074
RE: How to write Query on the Result Set of Another Query

lrosini (10/11/2013)
As Jeff showed there are many ways to do this. I only provided one possibility.
I've been a silent observer on this site for along time and finally feel that...
--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)

October 12, 2013 at 9:04 am

#1658073
RE: Generating Test Data: Part 1 - Generating Random Integers and Floats

The feedback is worth more than the stars. Thanks, Steen!
--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)

October 12, 2013 at 9:02 am

#1658072
RE: Are the posted questions getting worse?

Stefan Krzywicki (10/11/2013)
Revenant (10/10/2013)
WayneS (10/10/2013)
Stefan Krzywicki (10/8/2013)
Well, time to polish the resume and start looking for work. Just given a 1 month notice.
They want to keep me on a retainer...
--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)

October 11, 2013 at 3:47 pm

#1658034
RE: TempDB question

sunny.tjk (10/11/2013)
Does having multiple tempdb files on different drives help with contention?
Yes... especially if they're on different drives.
--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)

October 11, 2013 at 3:33 pm

#1658028
RE: How to write Query on the Result Set of Another Query

perireddy.arikatla (10/10/2013)
Hai Every One. Can Any body help me Please.
I Want to Write a Query On the Result Set Of Another Query.
How to Write
Can Any body...
--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)

October 11, 2013 at 3:32 pm

#1658027
RE: Fragmentation doesn't changes after index rebuilding

sandeep singh-337370 (10/11/2013)
It remained same even for the larger tables.
What do you condsider to be a "larger table"?
--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)

October 11, 2013 at 3:27 pm

#1658026
RE: index scan vs seek

Snargables (10/11/2013)
i have a table that has 600 mill recs. i have an update to it that modifies 79 k records a day. Up to last saturday at 8am this...
--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)

October 11, 2013 at 3:24 pm

#1658025

Viewing 15 posts - 25,651 through 25,665 (of 59,102 total)