Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,161 through 17,175 (of 59,067 total)

RE: How to read XML

bhushanbagul (7/25/2016)
I tried but no luck.
Then try using an RDBMS the way it was meant to be instead of storing denormalized, tag bloated, mostly non-SARGable data in your database 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)

July 25, 2016 at 9:57 am

#1891846
RE: Well I have been Moved to the DBA Team and I am a Noob

jameslima (7/24/2016)
I was thinking that it might have data since this is going to be a regular thing. They want to run the job every month, so the table should...
--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)

July 25, 2016 at 6:13 am

#1891796
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

I'm not the one with the keys to the Web Services. When it happened to me and one of them grabbed the single connection, I had to get 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)

July 25, 2016 at 6:02 am

#1891794
RE: Find all 35 combinations in 7 numbers ?

calvin_wk_wong (7/24/2016)
Thanks very much
the image is updated ?
any detail SQL statement would you suggest ?
What is the domain of numbers involved?
--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)

July 24, 2016 at 9:41 pm

#1891757
RE: Analyzing Data in Real Time

From the Article:
Of course, the definition of real time isn't really well known.
The definition is, of course, very well defined...
https://www.google.com/?gws_rd=ssl#q=definition+of+real+time
... and anyone that thinks or says otherwise is why...
--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)

July 24, 2016 at 6:06 pm

#1891744
RE: I nedd code to purge or clear sql server logs (current) not database logs

So, it WAS a "hide". 😉
--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)

July 24, 2016 at 5:11 pm

#1891741
RE: Need Help! ETL Stored Procedure Used to Work but Now Very Slow

1. What are the log file settings for initial size and growth?
2. What are you deleting and why?
3. Are you doing proper backups that include log file...
--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)

July 24, 2016 at 1:51 pm

#1891733
RE: I nedd code to purge or clear sql server logs (current) not database logs

Deg-235673 (7/24/2016)
I nedd code to purge or clear sql server logs (current) not database logs
"Current" log? What mistake are you trying to cover up?
--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)

July 24, 2016 at 12:48 pm

#1891729
RE: Today's Random Word!

Hugo Kornelis (7/22/2016)
Ed Wagner (7/22/2016)
djj (7/22/2016)
whereisSQL? (7/22/2016)
crookj (7/22/2016)
Ed Wagner (7/22/2016)
Luis Cazares (7/22/2016)
Grumpy DBA (7/22/2016)
Revenant (7/22/2016)
Ed Wagner (7/22/2016)
Luis Cazares (7/22/2016)
crookj (7/22/2016)
Red
Blue
Sky
Rainbow
Pot o' gold
leprechaun
Irish
Pub
Brawl
Fisticuff
Fight
That will give you the right to be free
Semantically,...
--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)

July 24, 2016 at 12:45 pm

#1891728
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

Thanks for the response, Joe.
Except for the part where you say "do not have to write with the full ANSI/ISO current SQL standard", I have to continue to...
--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)

July 24, 2016 at 10:15 am

#1891718
RE: Temp Table vs Permenant Table

Temp Tables or not, there are a whole lot of problems with this code and I wouldn't complicate it any further by building in the concurrency problems of using permanent...
--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)

July 22, 2016 at 7:13 pm

#1891685
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

CELKO (7/20/2016)
how do you define the arguments of a stored procedure in ANSI/ISO? If by using variables, then that pretty much shoots portability in the face.
It is actually...
--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)

July 22, 2016 at 6:26 pm

#1891682
RE: Script to stop service using XP_CMDSHELL, restore full and differential .bak files in a single script

John Mitchell-245523 (7/21/2016)
Jeff Moden (7/20/2016)
John Mitchell-245523 (7/20/2016)
The reason for changing to single-user isn't to get a connection to the database; it's to remove all other connections to the database. ...
--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)

July 22, 2016 at 6:19 pm

#1891681
RE: Reducing the hash match inner join cost

ScottPletcher (7/21/2016)
But, to me, there are exceptions. Such as when: (1) the only filtering is by active flag, and (2) there are a very high number of inactive rows, and...
--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)

July 22, 2016 at 5:46 pm

#1891680
RE: Auto Email based on rule - Is it possible?

wrightyrx7 (7/21/2016)
Jeff Moden (7/20/2016)
If someone is hired on Nov 30th, 2011, what is considered to be 3, 6, and 9 months from then according to your rules?
Hi Jeff,
Many thanks...
--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)

July 22, 2016 at 5:37 pm

#1891679

Viewing 15 posts - 17,161 through 17,175 (of 59,067 total)