Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,851 through 35,865 (of 59,102 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (11/29/2010)
Jeff Moden (11/29/2010)
WayneS (11/29/2010)
CirquedeSQLeil (11/29/2010)
On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make...
--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)

November 29, 2010 at 9:23 pm

#1256576
RE: Index build and parallelism

TheSQLGuru (11/29/2010)
4) If nothing else works, consider dropping in a fusionIO card and put tempdb there and use sort_in_tempdb option. :w00t:
Even though you can select the option 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)

November 29, 2010 at 8:55 pm

#1256574
RE: need help with loading a string

kevin4u06 (11/29/2010)
Hi Jeff,
Sorry for the late response. I was off for the thanks giving weekend. You didnt post your solution here.
Heh... I was off for the Thanks Giving weekend, myself....
--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)

November 29, 2010 at 8:19 pm

#1256573
RE: Converting Quartz.Net time columns to datetime

My apologies. I normally document what I did a lot better but I was in a rush. Here's how I came to those numbers from the excellent description...
--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)

November 29, 2010 at 5:29 pm

#1256550
RE: How do I, in effect, SELECT FROM a stored procedure

Actually, my bad. I didn't read the whole post to see what the data source actually was. I agree that the Information_Schema views are the ticket in 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)

November 29, 2010 at 4:46 pm

#1256548
RE: Are the posted questions getting worse?

WayneS (11/29/2010)
CirquedeSQLeil (11/29/2010)
On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make sure we 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)

November 29, 2010 at 4:40 pm

#1256546
RE: How to create procedure from definition of another procedure

I agree with Scott... the OBJECT_DEFINITION function is documented and easy to use for just about everything except a table. Take a look in Books Online for the details.
--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)

November 29, 2010 at 4:35 pm

#1256543
RE: Need help writing the correct SQL

Hi Sergiy,
Glad to "see" you still come around once in a while. 🙂
I understand the basic misgiving there but EXCEPT does only return "distinct" values much like a GROUP BY...
--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)

November 29, 2010 at 4:26 pm

#1256541
RE: Need help building a query.

GSquared (11/29/2010)
Wayne, just because a table has an ordered clustered index, doesn't mean an identity column will honor that order. Usually it will, but you can't guarantee it.
Jeff's solution...
--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)

November 29, 2010 at 4:10 pm

#1256539
RE: Help to write a regular expression

Helical Johan (11/26/2010)
Hi,
I need write a regular expression:
1. Must start in caracter - next to any letter.
2. Must end in caracter - next to any number.
For example:
5D-Canada-Alberta-Calgary-5715-#3#3-9990516-V3-Local-8-0-0
My output is:
Canada-Alberta-Calgary
Thanks.....
Will...
--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)

November 29, 2010 at 6:37 am

#1256220
RE: How to create procedure from definition of another procedure

roman.goldenberg (11/29/2010)
Thanks...
I do this in production for save back up's before altering procedure
As a side bar, backups of this nature are fine but you may want to look into some...
--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)

November 29, 2010 at 6:35 am

#1256218
RE: exec scope

nadersam (11/29/2010)
Thanks Jeff,
That's exactly what i will start working on in the next period.
Thanks for the feedback, nadersam.
--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)

November 29, 2010 at 6:34 am

#1256217
RE: what is highavailability solutions

p.s. If, as your subtitle to the post implies, this is only for log shipping, I recommend you start reading "Books Online" (the free help system that comes 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)

November 28, 2010 at 10:24 pm

#1256106
RE: what is highavailability solutions

shoukat.shaik (11/28/2010)
how we can perform highavailability solutions
Gosh... people write thousand page books on the subject. I'm sure folks will give you some hints but this is much to large...
--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)

November 28, 2010 at 10:20 pm

#1256104
RE: Close,Deallocate cursor with rollback

Ashwin M N (11/28/2010)
The cursor I have shown above is just an example the actual is more complicated than above.
Complexity changes nothing here. 99.9999% of the time, there is...
--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)

November 28, 2010 at 10:17 pm

#1256102

Viewing 15 posts - 35,851 through 35,865 (of 59,102 total)