Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,096 through 31,110 (of 59,101 total)

RE: Upgrading Your Career

Brent Ozar (2/15/2012)
TravisDBA (2/15/2012)
First, you said there were no braindumps for the MCM. Then, after you asking for proof, I showed you 4 for starters, they are all over...
--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 16, 2012 at 7:42 am

#1447884
RE: There must be an easier way of doing this...

Gosh... I just know a bunch of people will come out of the woodwork on my response but I use simple DOS commands via xp_CmdShell and BULK INSERT for 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)

February 16, 2012 at 7:36 am

#1447881
RE: flat file

Koen Verbeeck (2/16/2012)
Phil Parkin (2/15/2012)
A question for the OP: I'd like to build a car using some bits of metal, some wood and some electrical components. Which tools 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 16, 2012 at 7:26 am

#1447873
RE: public Function

I agree with Eugene. Probably not a good idea to put all of these types of things in master. I also agree that a separate database is good...
--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 16, 2012 at 7:25 am

#1447872
RE: Pass! Thanks for the Help Guys

Very cool. Congratulations!
--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 16, 2012 at 7:13 am

#1447858
RE: When we should use in a query or a procesure "option(recompile)"

Gianluca Sartori (2/16/2012)
Jeff Moden (2/15/2012)
If one second is what you need it to be (especially compared to 30 minutes), why mess with success? Leave the option to recompile in...
--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 16, 2012 at 7:08 am

#1447853
RE: COUNT No of occurrances in a text field

bteraberry (2/15/2012)
If you have a need to improve the performance and you are not overly restricted in your environment, this would be a great place to use CLR. 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 16, 2012 at 6:53 am

#1447843
RE: Count Function

Cadavre (2/16/2012)
Jeff Moden (2/15/2012)
jennigirl (1/18/2012)
I can get a total count of rows returned, but I am trying to get a count of tickets assigned to each person. I don't work...
--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 16, 2012 at 6:49 am

#1447836
RE: How to backup only new data?

Grant Fritchey (2/16/2012)
I'd cheat.
Get a copy of Red Gate SQL Compare and just capture the data that exists in one database, but not the other. Very easy that way. But...
--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 16, 2012 at 6:47 am

#1447834
RE: Convert minutes to HH:MM:SS format

guruprasad1987 (2/16/2012)
Hi Jeff Moden,
Thank you for your reply. Here is the url http://www.sqlservercentral.com/Forums/Topic1252335-391-1.aspx
Regards
Guru
I thought you said it was your post that was blocked.
--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 16, 2012 at 6:45 am

#1447833
RE: Convert minutes to HH:MM:SS format

guruprasad1987 (2/15/2012)
Hi Gail Shaw,
Can I know the reason why my post blocked? I had reply @ "Posted Yesterday @ 10:50:20 AM"
Regards
Guru
Looking back at your previous posts, 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 16, 2012 at 5:33 am

#1447788
RE: sp_executesql()

PHXHoward (2/15/2012)
Thanks for the replies. Interestingly with or without parameters, it still executes very slowly when inside the SP.
Going to look at the execution plan both ways tomorrow to see...
--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 15, 2012 at 11:50 pm

#1447670
RE: when i check the database with following command DBCC CHECKDB(checkerpdatabase) WITH NO_INFOMSGS,these below error occured what i do ????????????????

Right after you get done with all of that, I strongly suggest you learn how to do backups, scheduled log backups, and how to use them to do point-in-time restores...
--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 15, 2012 at 11:12 pm

#1447662
RE: Convert minutes to HH:MM:SS format

pwalter83 (2/15/2012)
Hi,
I have a requirement to convert minutes to HH:MM:SS format. However, the minutes to be converted are calculated through this query:
(sum(datepart(hour,Timenetin) * 60) + sum(datepart(minute,Timenetin) * 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)

February 15, 2012 at 11:03 pm

#1447661
RE: How to quantify TEMPDB usage in relation to other databases hosted on same infrastructure ?

Separation of MDF and LDF for TempDb is a great performance idea IF they're on separate spindles. If they're on the same spindles (or spindle), it won't help much.
Shift...
--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 15, 2012 at 10:57 pm

#1447660

Viewing 15 posts - 31,096 through 31,110 (of 59,101 total)