Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,451 through 33,465 (of 59,099 total)

RE: Group Islands of Contiguous Dates (SQL Spackle)

quickdraw (6/27/2011)
Oh, that row_number trick is so beautiful it makes me want to cry!
If you'd like to see a similar "Row_Number Trick" on steroids 😉 to solve the problem 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)

June 27, 2011 at 6:45 pm

#1344919
RE: Please,need help with constructing a right query ...

skynet_si (6/27/2011)
jeff,thanks a lot...
Did not have the time to check this but it seems the last output is wrong
DBLMS 2011-04-25 00:00:00.000 2011-04-26 00:00:00.000 118.00 ...
--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)

June 27, 2011 at 4:42 pm

#1344896
RE: Format File works with BCP, but fails with BULK Insert

Brandon Forest (6/27/2011)
I have a format file as follows:
8.0
4
1 SQLCHAR 0 2...
--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)

June 27, 2011 at 4:31 pm

#1344893
RE: DBA Roles

Wrong post... removed comments.
--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)

June 27, 2011 at 5:58 am

#1344434
RE: Need to Create File Listing through T-SQL

mail2payan (6/26/2011)
How to set share access policies in MS SQL Server??
You don't. You have to set the share at the OS level and the share needs to be for...
--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)

June 27, 2011 at 5:52 am

#1344430
RE: Where Do You Go for Authoritative SQL Server Best Practices?

paul s-306273 (6/27/2011)
As for coding, if you can't make sense of something that's been posted reasonably quickly, I suggest you move on to something that you can comprehend.
On the other...
--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)

June 27, 2011 at 5:47 am

#1344428
RE: Converting a string to a generalized format

pandeesh (6/27/2011)
Regex Replace won't be faster than the nested replaces. .
May i know how?
Yep.... like I said...
Behind the scenes, they do the same thing.
However, if you want, I can...
--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)

June 27, 2011 at 5:30 am

#1344417
RE: Split the data in the row seperated by comma

Thanks, Kamal.
--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)

June 27, 2011 at 5:27 am

#1344415
RE: query for continuous period

TheSQLGuru (6/22/2011)
If you want an amazingly efficient way to collapse date intervals, see here: http://www.solidq.com/sqj/Pages/2011-March-Issue/Packing-Intervals.aspx. Incredible TSQL goodness served up by Itzik Ben-Gan.
Damn, that's clever. It's not...
--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)

June 26, 2011 at 11:44 pm

#1344305
RE: Please,need help with constructing a right query ...

Additional info would be great so I can understand something.
just learning ...
Ok... in that light...
The key to easily figuring out this problem had absolutely nothing to do with any...
--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)

June 26, 2011 at 10:06 pm

#1344295
RE: Please,need help with constructing a right query ...

As a side bar, I believe using the actual enddates for each rate is confusing because they aren't actually the enddates. They're actually the start date of the next...
--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)

June 26, 2011 at 9:20 pm

#1344292
RE: Please,need help with constructing a right query ...

skynet_si (6/26/2011)
So can someone enlighten me and put me out of my misery.
Absolutely.
Additional info would be great so I can understand something.
just learning ...
The additional info you seek...
--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)

June 26, 2011 at 9:16 pm

#1344291
RE: Where Do You Go for Authoritative SQL Server Best Practices?

I pretty much use the same resources and in the order that you did when you wrote your book, Brad.
For your final question, I NEVER take anything at face...
--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)

June 26, 2011 at 7:36 pm

#1344282
RE: Converting a string to a generalized format

pandeesh (6/26/2011)
Yes! Obviously it can be achieved via nested replace statements.
But i still wonder that why REGEXP_REPLACE is not yet introduced in Sql Server.
I am expecting this in the next...
--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)

June 26, 2011 at 5:58 pm

#1344273
RE: Random timeout running a stored proc - drop recreate fixes

amjid.qureshi (6/26/2011)
Hi all, So I work with a largish database (30 gig) sql 2005 with a .net 3.5 web front end on a 10 year old system. It has...
--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)

June 26, 2011 at 5:46 pm

#1344270

Viewing 15 posts - 33,451 through 33,465 (of 59,099 total)