Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,066 through 37,080 (of 59,072 total)

RE: What are the daily DBA administrator tasks

There's a huge amount of info available on this... just Google it. 😉
--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)

August 27, 2010 at 8:37 pm

#1213364
RE: Missing sequence number

WayneS (8/27/2010)
Jeff Moden (8/27/2010)
You folks already have the split thing pretty much down pat so I'll just demo another method for detecting and displaying "gaps". I haven't tested every...
--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)

August 27, 2010 at 8:24 pm

#1213363
RE: Excel Colum Formatting

WayneS (8/27/2010)
Using OpenRowset/OpenDatasource, it can't be done.
However, you can accomplish the formatting by:
1. Use the Export wizard.
2. Use a SSIS package.
3. Use the sp_OA procedures to perform OLE Automation. 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)

August 27, 2010 at 7:35 pm

#1213356
RE: Missing sequence number

You folks already have the split thing pretty much down pat so I'll just demo another method for detecting and displaying "gaps". I haven't tested every method in 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)

August 27, 2010 at 7:05 pm

#1213352
RE: Convert CSV values in three columns to rows

Quatrei.X (8/27/2010)[hrCool! thanks, I needed this... uhmmm, I have a question about this but in a different forum/section (don't wanna double post)...
http://www.sqlservercentral.com/Forums/Topic975437-392-1.aspx?Update=1
hope you can look at it.
Thanks in advance!...
--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)

August 27, 2010 at 6:53 pm

#1213351
RE: CTE - How to surpass the limit

steveb. (8/26/2010)
Quatrei.X (8/26/2010)
hmmmm...
:hehe: I was planning to create a generic function which gets a comma separated list of words in a string and use CTE to seperate those strings...
--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)

August 27, 2010 at 6:50 pm

#1213350
RE: CTE - How to surpass the limit

ColdCoffee (8/27/2010)
Quatrei.X (8/27/2010)
Question 1:
Use tally table or CTE... which is a better practice? (although I'm already thinking of CTE but still wanna hear from you guys)
Jeff Moden's CTE in his...
--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)

August 27, 2010 at 6:43 pm

#1213348
RE: CTE - How to surpass the limit

GilaMonster (8/27/2010)
Quatrei.X (8/27/2010)
Query costs relative to batch is 84% for the first one and 16% for the second.
Those costs are estimates. There are lots of things that make the estimates...
--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)

August 27, 2010 at 6:33 pm

#1213347
RE: CTE - How to surpass the limit

shield_21 (8/27/2010)
Hi there,
Here's another method for splitting comma separated values using recursive cte without using tally table.. When the string contains more than 8000 characters, this performs quite faster (otherwise...
--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)

August 27, 2010 at 6:29 pm

#1213346
RE: If You Had To Pick a Super Hero...

David in .AU (8/27/2010)
Jeff, that's such a cop out 🙂
Come on, show the color of your spandex...
As for me, Atomic Robo, has a lot more fun with technology that 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)

August 27, 2010 at 5:12 pm

#1213340
RE: Missing sequence number

Ram:) (8/27/2010)
Jeff,
Yes, Here the purpose is I will get bill_ids as a string from application.. I want which id's are missing in between.. Just for reporting Purpose which we are...
--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)

August 27, 2010 at 5:10 pm

#1213339
RE: Missing sequence number

Mark-101232 (8/27/2010)
WayneS (8/27/2010)
Jeff Moden (8/26/2010)
I'm waiting to hear back from the OP of what he wants to do if a couple of million row were to be returned because I'd...
--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)

August 27, 2010 at 5:09 pm

#1213338
RE: If You Had To Pick a Super Hero...

I try to stick with the real life super heroes. Steve Jones comes to mind. I also see a bunch of dedicated heavy hitters on this forum 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)

August 26, 2010 at 11:47 pm

#1212746
RE: xp_cmdshell PSCP - "The server''s host key is not cached in the registry"

akhilesh.aggarwal123 (6/2/2010)
James Rizzo you rocks!!!
I just registered to thank you!!!:-D
That's a cool thing to 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)

August 26, 2010 at 11:38 pm

#1212739
RE: The Semantics of NULL in SQL Server 2008

Alex-668179 (8/26/2010)
AFAIK, NULL is the only way to leave a field empty!
I disagree: setting a field to NULL does not 'leave [or make] a field empty', instead it makes (or...
--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)

August 26, 2010 at 11:36 pm

#1212738

Viewing 15 posts - 37,066 through 37,080 (of 59,072 total)