Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,316 through 15,330 (of 59,101 total)

RE: 'Spell check' a string-valued field

You're welcome. It might sound a bit strange but (I have no life 😉 ) thank you for the interesting problem.
--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)

March 30, 2017 at 7:32 pm

#1935893
RE: SQL Server DBA Certification

See the following.
https://www.microsoft.com/en-us/learning/sql-certification.aspx
In the process of becoming a DBA, make sure you know how to write code to get the current date an time. T-SQL 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)

March 30, 2017 at 9:15 am

#1935753
RE: DBCC is running from 5 days

NorthernSoul - Thursday, March 30, 2017 2:34 AM
I notice you've raised another topic regarding memory pressure. Is this happening on the same...
--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)

March 30, 2017 at 8:37 am

#1935742
RE: Stored procedure parameters

I take exception to the supposed correct answer. If you have defaults on the parameters, input is not required. I agree... a bit of word play has come into 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)

March 30, 2017 at 8:32 am

#1935739
RE: Big Companies are Improving with DevOps

I guess I just don't understand why people think you can "implement" DevOps. You can't implement a culture. You have to enable it and then let it happen.
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)

March 30, 2017 at 8:29 am

#1935738
RE: Instance is under memory pressure. How to relieve from pressure

coolchaitu - Thursday, March 30, 2017 1:30 AM
RAM=30 GB
I'm pretty sure that you've just discovered the reason for your "memory pressure". ...
--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)

March 30, 2017 at 8:14 am

#1935732
RE: Kudos on this choice forum software !!

I've found that copying and pasting from SSMS directly to an SQL Code window makes a train wreck of things. Turns out that they only have limited support for IE...
--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)

March 30, 2017 at 8:10 am

#1935729
RE: Kudos on this choice forum software !!

Have you tried to post any code, yet?
--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)

March 30, 2017 at 1:00 am

#1935640
RE: Convert DATETIME, trim leading zeros

thisisfutile - Wednesday, March 29, 2017 2:26 PM
I sure hope this isn't considered bad etiquette by reviving a 5 year old thread...
--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)

March 29, 2017 at 5:00 pm

#1935623
RE: What Kind of DBA Are You?

hakim.ali - Monday, March 27, 2017 10:16 PM
Jeff Moden - Sunday, September 6, 2015 10:40 AM
--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)

March 28, 2017 at 9:16 am

#1935295
RE: DB MAXDOP Settings

No problem. And thank you! Thanks to your question, I learned something new.
--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)

March 27, 2017 at 7:38 pm

#1935191
RE: Log file growth

Admingod - Monday, March 27, 2017 1:36 PM
Thanks for everyone for the replies. The log growth is happened during index maintenance plan....
--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)

March 27, 2017 at 7:32 pm

#1935190
RE: switch table to partition

Sugesh Kumar - Tuesday, November 13, 2007 11:23 PM
Check for the article on data partitioning in the link given below.http://www.sql-articles.com
Do you 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)

March 27, 2017 at 7:26 am

#1935054
RE: Are the posted questions getting worse?

Michael L John - Sunday, March 26, 2017 7:30 PM
Jeff Moden - Saturday, March 25, 2017 9:05...
--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)

March 27, 2017 at 6:38 am

#1935042
RE: How to reduce log file size in BCP in?

JasonClark - Sunday, March 26, 2017 11:10 PM
Use -b option to Avoid filling the transaction log space. Also, you should drop indexes...
--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)

March 27, 2017 at 6:12 am

#1935037

Viewing 15 posts - 15,316 through 15,330 (of 59,101 total)