Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,761 through 23,775 (of 59,099 total)

RE: Insert triggers updating an audit table

For something like this, consider and "INSTEAD OF" trigger for the inserts. That way, you're only hitting the table once. Updating after the fact will prove to be...
--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)

April 28, 2014 at 8:43 am

#1709195
RE: How i make ERD Diagram for payroll salary for employees

ahmed_elbarbary.2010 (4/28/2014)
Hi guys i want to make database for payroll only but i don't know how to make structure for this
suppose i want to calculate payroll every month for employees...
--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)

April 28, 2014 at 8:40 am

#1709194
RE: Calculate average through recursive CTE

Brandie Tarvin (4/28/2014)
Come to the Dark Side. We have cookies!
Heh... Mongo like cookies! 😀
--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)

April 28, 2014 at 8:31 am

#1709192
RE: update query very slow sql server

Just a thought...
The looping is going to cause a full table scan of a 100 Million row table for each and every loop. That's a shedload of I/O 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)

April 28, 2014 at 8:30 am

#1709191
RE: What is wrong with this syntax? Query will work, but CTE will not "compile"

Eirikur Eiriksson (4/8/2014)
hisakimatama (4/8/2014)
Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the" way 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)

April 27, 2014 at 7:55 pm

#1709054
RE: ALTER INDEX REORGANIZE Compacts pages that contain large object (LOB) data. Does rebuilding also do it?

Wow! Great question. Books Online specifically identifies what will occur with LOBs during a REORGANIZE but says nothing specific about LOBs during REBUILDs. It does say 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)

April 27, 2014 at 7:41 pm

#1709053
RE: More than 1 alphanumeric chars in a string

hunchback (4/8/2014)
Try:
SELECT
*
FROM
#employee
WHERE
Surname LIKE '%[^0-9a-zA-Z][^0-9a-zA-Z]%'
OR GivenName LIKE '%[^0-9a-zA-Z][^0-9a-zA-Z]%';
GO
Heh... simplicity at it's best. The only...
--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)

April 27, 2014 at 4:53 pm

#1709051
RE: More than 1 alphanumeric chars in a string

Crud post on my part... took it down. :blush:
--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)

April 27, 2014 at 4:45 pm

#1709050
RE: recursive queries - parent child

priestxandar (4/27/2014)
Hi Jeff,
Thanks for trying to help me, i read those articles you send me, but i cant figure out how to use the info inside to help my self....
--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)

April 27, 2014 at 1:40 pm

#1709045
RE: recursive queries - parent child

If it were me, I'd break the Parent and Child values up as true parent and child values and set them into an Adjacency list, something like this but missing...
--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)

April 27, 2014 at 12:24 am

#1709017
RE: Tables on diffrerent files

spaghettidba (4/26/2014)
yuvipoy (4/25/2014)
Is it a good practise to have my tables in different files.
Say i am having 10 master tables.
Can i create tables each one on 10 secondary files(.ndf) 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)

April 26, 2014 at 11:49 pm

#1709016
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Paul White (4/14/2014)
Jeff Moden (4/14/2014)
I agree. A CLR would be the best way and you made it easy enough for everyone to use. Thanks. The "Split" function...
--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)

April 26, 2014 at 12:19 pm

#1708986
RE: Performance related question

Wow! I'm not sure what I was thinking about when I wrote that mess. Looking back at it, it doesn't even make sense to me. :blush: 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)

April 26, 2014 at 9:24 am

#1708968
RE: Need set based method to insert missing records into table - right join doesn't work

dmckro (4/25/2014)
My point exactly! Thank you for your response. I'll take a look at it this afternoon.
I think you missed the point. 😉
--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)

April 25, 2014 at 8:22 pm

#1708929
RE: Switch from prod DBA to BI Admin or Cloud?

Are you any good at the other 2 jobs?
--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)

April 25, 2014 at 8:17 pm

#1708928

Viewing 15 posts - 23,761 through 23,775 (of 59,099 total)