Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,636 through 25,650 (of 59,099 total)

RE: Recursive Stored Procedure

sarafpradeep (10/9/2013)
Thank you Sean Lange, I did not think about it. I liked the idea of "Jeff Moden" but I am not sure about how to create a partitioned view.
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 15, 2013 at 8:13 am

#1658546
RE: Running out of workers

Erland Sommarskog (10/15/2013)
ELLEN-610393 (10/3/2013)
I see that you said that the default 0 for worker threads should be good. What is the impact of having a process spin up several...
--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 15, 2013 at 8:08 am

#1658542
RE: how to split the comma delimited string into rows without using LOOP, CTE, XML.

@mynkdby,
I've been trying to figure out why you wanted to avoid a CTE for this and I believe I've come up with the answer. Since you're on a quest...
--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 15, 2013 at 7:55 am

#1658532
RE: how to split the comma delimited string into rows without using LOOP, CTE, XML.

Th. Fuchs (10/14/2013)
---- drop the recursion into a static table
if object_id('dbo._numbers') is null --- drop 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 15, 2013 at 7:38 am

#1658521
RE: TempDB question

sunny.tjk (10/14/2013)
Jeff Moden (10/11/2013)
sunny.tjk (10/11/2013)
Does having multiple tempdb files on different drives help with contention?
Yes... especially if they're on different drives.
Thanks Jeff.
Another way to reduce contention is to turn 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 14, 2013 at 5:32 pm

#1658376
RE: What is your favorite "I didn't know that" moment in T-SQL?

Sergiy (10/13/2013)
L' Eomot Inversé (8/10/2013)
but in SQL Server 2000 if people without SA access had access to xp_cmdshell
How?
I can't speak for Tom but apparently through methods similar 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)

October 14, 2013 at 5:22 am

#1658238
RE: Need Help on Fastest Search Logic

lnardozi 61862 (10/13/2013)
You could be right but the FTI wouldn't be on Table 2 according to the OPs latest post. It would only be needed on Table 1. Fortunately, 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 13, 2013 at 1:34 pm

#1658138
RE: i want to generate sequence number in SSIS

Phil Parkin (10/13/2013)
...it's still not actually being done by SSIS... it's being done by a script.
Well, I think we are drifting into a grey semantic area here.
SSIS natively provides...
--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 1:25 pm

#1658137
RE: Map Network drive not visibile for backup?

ananda.murugesan (10/11/2013)
Hi,
I have mapped network drive for backup purpose. It is showing server level. But it is not visible in Management plan at chose backup drive location.. what could be...
--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:23 am

#1658130
RE: Unable to alter view

tshad (10/10/2013)
I was able to resolve the issue by killing all queries open to the database and shutting down SSMS, when I came back - it worked fine. Before...
--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:16 am

#1658129
RE: Need a Query on group by condition

Sean Lange (10/11/2013)
smharabbani40 (10/11/2013)
Hi I need a Query from the month 112013 to 122013 sir......
i have used the below Query which is not satisfieing.
...
--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:14 am

#1658128
RE: Need a Query on group by condition

Bhuvnesh (10/13/2013)
declare @tbl table
(
emp int ,
monthyear int,
amount money
)
insert into @tbl
select 1, 102013 ,1000
union all select 2, 102013, 1000
union all select 1,...
--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:07 am

#1658127
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

Viewing 15 posts - 25,636 through 25,650 (of 59,099 total)