Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,496 through 24,510 (of 59,102 total)

RE: exec proce

elham_azizi_62 (2/3/2014)
I run this function:
select * from dbo.Split('1234567890,2,''92/11/14'',''92/11/17'',''92/11/14'',9214,''92/11/14'',''92/11/14'',1,4,''????? 2''' ,',')
now I need to use from function result for sp parameter:
Exec mysp a,b,c,d,e,f,g,h,i,j,k
I need to this:a=1234567890
b=2
c='92/11/14' and ....
how do 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)

February 3, 2014 at 12:02 pm

#1685603
RE: Best way to add constraint?

My recommendation would be to NOT use numerics here. M, F, U, etc adds clarity and avoids confusion. If you really want to do it right, lookup the...
--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 3, 2014 at 10:25 am

#1685561
RE: Are the posted questions getting worse?

Grant Fritchey (2/3/2014)
Sean Lange (1/31/2014)
wolfkillj (1/31/2014)
Ed Wagner (1/31/2014)
Luis Cazares (1/30/2014)
Would this help?
http://www.sqlskills.com/blogs/kimberly/guids-as-primary-keys-andor-the-clustering-key/
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/guid-vs-int-debate.aspx
Maybe even a post from a GUID lover:
http://blogs.msdn.com/b/sqlazure/archive/2010/05/05/10007304.aspx
Or even BOL on Using uniqueidentifier Data:
http://technet.microsoft.com/en-us/library/ms190215(v=sql.105).aspx
I especially like Kimberly's article Luis...
--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 3, 2014 at 8:25 am

#1685523
RE: Are the posted questions getting worse?

L' Eomot Inversé (2/3/2014)
Revenant (1/27/2014)
I wish that MSFT introduces a T-SQL construct like this:
RUN ON THREAD a
(some T-SQL)
RUN ON THREAD b
(another T-SQL)
AWAIT a AND b
(runs after both a and b...
--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 3, 2014 at 8:11 am

#1685517
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

davoscollective (2/2/2014)
Wow thanks for what was effectively part 2 in this spackle 🙂 You've written an article in its own right to answer my question and I am very grateful,...
--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 3, 2014 at 8:03 am

#1685513
RE: Query to get the CPU Usage,memory usage details of server

sqlsniper (2/3/2014)
Jeff Moden (2/2/2014)
sqlsniper (2/2/2014)
You could also take a look at Windowstooling, like perfmon and the typeperf tooling.
Perfect! How do you store that in a table in SQL Server?...
--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 3, 2014 at 7:56 am

#1685507
RE: Adding to SQL Server

I'm not sure how many people have a wish list like Peter and I but I'll just bet there's a ton of lurkers going "True dat!". Microsoft should have...
--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 3, 2014 at 7:55 am

#1685506
RE: How to convert char 10/2013 to use the filter >=

Golden_eye (2/3/2014)
Jeff Moden (2/2/2014)
Hmmmm... there IS a way to do this in a SARGable fashion (although fixing the column is still the best idea). I just need to know...
--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 3, 2014 at 7:52 am

#1685503
RE: how to deploy single ssis package in ssis 2012 .

Thanks, Lempster. Seems like all of that makes emergency repairs pretty tough.
--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 3, 2014 at 7:50 am

#1685502
RE: SQL Best practices, policies and code-smells.

David Atkinson (2/3/2014)
Jeff Moden (2/1/2014)
David Atkinson (1/29/2014)
Is anyone actively using any tooling (free or commercial) to help with T-SQL best practices?
WHOSE "Best Practices"?
I guess I meant one's own best practices...
--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 3, 2014 at 7:41 am

#1685496
RE: using count with select case

Absolutely my pleasure. Thanks for posting readily consumable data that actually worked. You made it really easy for me to concentrate on an alternate solution instead of having...
--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 3, 2014 at 7:28 am

#1685492
RE: how to deploy single ssis package in ssis 2012 .

Lempster (2/3/2014)
Koen Verbeeck (2/2/2014)
asranantha (2/2/2014)
Hi friends, in my project having 10 packages with shared connection used.here i need deploy only single ssis package please provide how to solve this issuse...
--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 3, 2014 at 7:25 am

#1685487
RE: how to deploy single ssis package in ssis 2012 .

Koen Verbeeck (2/3/2014)
Jeff Moden (2/2/2014)
Koen Verbeeck (2/2/2014)
asranantha (2/2/2014)
Hi friends, in my project having 10 packages with shared connection used.here i need deploy only single ssis package please provide how 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)

February 3, 2014 at 7:22 am

#1685484
RE: How to convert char 10/2013 to use the filter >=

dwain.c (2/2/2014)
Jeff Moden (2/2/2014)
Hmmmm... there IS a way to do this in a SARGable fashion (although fixing the column is still the best idea). I just need to know...
--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 3, 2014 at 7:10 am

#1685477
RE: Finding “Active” Rows for the Previous Month (SQL Spackle)

Stuart Davies (2/3/2014)
Excellent article Jeff - and rated as such.
Thanks, Stuart. I appreciate it. Thanks for the read.
--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 3, 2014 at 7:07 am

#1685474

Viewing 15 posts - 24,496 through 24,510 (of 59,102 total)