Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,086 through 20,100 (of 59,072 total)

RE: Regular activities of SQL DBA (L1 person).....

Sgar... (7/21/2011)
The person as L1 support what will be the regular activities as soon as he goes to office ? what will be the regular issues you will face?
Owing 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 18, 2015 at 7:29 pm

#1813531
RE: Indexes with more writes than reads

lmarkum (7/17/2015)
I have inherited a database that is over-indexed, i.e. there are sometimes 10-20 indexes on a table. The performance is at times not great due to blocking from...
--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 18, 2015 at 7:08 pm

#1813530
RE: SQL Server 2008 Ran out of Disk Space

Peter19898 (7/17/2015)
Hi
One of our SQL servers ran out of disk space and we received an error stating that the transaction log file was full for one of our Sharepoint content...
--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 18, 2015 at 6:42 pm

#1813529
RE: Presenting Data

This is the most important...
One of the best things you can do as a developer or DBA is ensure you can write efficient queries that assemble data from a variety...
--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 18, 2015 at 12:28 pm

#1813514
RE: Records per hour within a time span

drew.allen (7/17/2015)
laudena (7/14/2015)
What about something like this?
SELECT month(DateField) as DteFld_Month, DAY(DateField) AS DteFld_Day, { fn HOUR(DateField) } AS DteFld_Hour, COUNT(MeasMyID) AS DupCount
FROM ...
--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 18, 2015 at 9:56 am

#1813499
RE: Today's Random Word!

SQLRNNR (7/16/2015)
clam
fn_clam 😀
--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 16, 2015 at 9:18 pm

#1813160
RE: Are the posted questions getting worse?

SQLRNNR (7/16/2015)
Ed Wagner (7/16/2015)
Luis Cazares (7/16/2015)
Alvin Ramard (7/16/2015)
Phil Parkin (7/16/2015)
.... up to and including the "F" word
Foxbase?
Foxpro?
Foxboro? Ok, that's not a bad word, I just dislike the NFL team...
--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 16, 2015 at 5:05 pm

#1813146
RE: Are the posted questions getting worse?

DBA From The Cold (7/16/2015)
The underground tour looks amazing (as you said Steve), booking a ticket on that
It's a lot of fun. I had a great time on it....
--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 16, 2015 at 9:01 am

#1813011
RE: No of Months between two dates in YYYYMM format

I still want to know what someone considers to be a month. DATEDIFF(mm,'20150630','20150701') will say that a month has passed when only 1 day will have passed. What...
--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 16, 2015 at 8:56 am

#1813008
RE: When to mess with CPU affinity?

swoozie (7/16/2015)
I have no Original system to compare to, unfortunately. What we are standing up is completely new. Short of hitting the guy over the head with a...
--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 16, 2015 at 8:50 am

#1813004
RE: When to mess with CPU affinity?

swoozie (7/15/2015)
We are standing up 2 new servers Active\Passive on top of Netapp (SAN) , we were going to dedicate 2 blades of the new server to SQL 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)

July 15, 2015 at 3:07 pm

#1812809
RE: slow performance

Grace09 (7/15/2015)
Jeff, the compilation Time is on 6/13. Thank you.
That means that the code only ran a little over 6,500 times a day. It DOES, however, have an average...
--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 15, 2015 at 3:00 pm

#1812807
RE: Populating SQL tables with entries from Windows folders

rmechaber (7/15/2015)
Jeff Moden (7/15/2015)
rmechaber (6/4/2015)
If you can CLR, this works well: https://nclsqlclrfile.codeplex.com/%5B/url%5D
Rich
Everytime I see that particular post, I can't help but ask why someone would spend so much time 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 15, 2015 at 2:49 pm

#1812805
RE: Populating SQL tables with entries from Windows folders

rmechaber (6/4/2015)
If you can CLR, this works well: https://nclsqlclrfile.codeplex.com/%5B/url%5D
Rich
Everytime I see that particular post, I can't help but ask why someone would spend so much time and effort duplicating what...
--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 15, 2015 at 11:51 am

#1812751
RE: Are the posted questions getting worse?

GilaMonster (7/15/2015)
Yes, asking people to write an efficient query when you don't entirely know what you need is a really good way to get a useless answer....
Heh... reminds me of...
--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 15, 2015 at 11:44 am

#1812748

Viewing 15 posts - 20,086 through 20,100 (of 59,072 total)