Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,091 through 21,105 (of 59,098 total)

RE: How to find the needle in the haystack

tcronin 95651 (4/9/2015)
no blocking that was the first thing I looked for. I had dropped an unused index the night before on a table that the stored proc 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 9, 2015 at 2:04 pm

#1790003
RE: How to find the needle in the haystack

Eirikur Eiriksson (4/9/2015)
tcronin 95651 (4/9/2015)
I have baselines, just stunned to see this happen, I have been a dba for 20 years and 99% of the time this happens either blocking...
--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 9, 2015 at 2:01 pm

#1790001
RE: Float data types

PB_BI (4/9/2015)
Show your DBA that, if they continue to argue the point then they are a moron of the highest order.
Not really. Without using FLOAT datatypes, you calculate 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)

April 9, 2015 at 8:14 am

#1789873
RE: Anyone Tell me what regular Housekeeping is needed for SQL DB's

Grant Fritchey (4/9/2015)
Check Database Integrity
Database Backups
Log Backups
Backup Testing
Statistics Maintenance
Index Maintenance
Those are the basics I think.
Just to add to that fine list... Checks on performance and resource usage (usually against 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)

April 9, 2015 at 8:09 am

#1789872
RE: how to calculate date time

immaduddinahmed (4/9/2015)
hi,
my data is looks like this,
Date---------------------------------------A
2015-03-01 13:38:07.343----------------1
2015-03-01 14:04:04.460----------------1
2015-03-02 19:33:55.117----------------3
2015-03-02 19:33:55.117----------------4
2015-03-02 19:39:26.580----------------1
i want data looks like this
Date-------------------------------------------A
Day 1------------------------------------------2
Day 2------------------------------------------8
please can any one provide me a query.
please help me out
Thanks for...
--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 9, 2015 at 8:05 am

#1789870
RE: A Hazard of Using the SQL Update Statement

AncientCitySQL (4/8/2015)
Timing is everything... I just read this article the other day and made a mental note. Today, while studying for the 70-461 exam using, Itzik Ben-Gan's, Querying...
--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 8, 2015 at 9:05 pm

#1789760
RE: The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

I don't know why people insist on cluttering up triggers nor even most code with custom error handling especially when all most people do at best is rethrow 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)

April 8, 2015 at 8:34 pm

#1789759
RE: Employee status on first and last day of a pay period

CELKO (4/8/2015)
Absolute rubbish and you know it, Joe. What would you use instead?
Strings, with validation and verification. The validation is usually done with regular expressions and/or check digits....
--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 8, 2015 at 8:29 pm

#1789758
RE: Are the posted questions getting worse?

Brandie Tarvin (4/8/2015)
Jeff, what did you mean by "retro code" when you were talking about how hosed up SSMS got?
I'll see if I can find the links I was looking...
--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 8, 2015 at 4:39 pm

#1789733
RE: Reports that can be published by DBA team to help raise awareness of database environments

richard.bowles (4/8/2015)
Over the course of several years, we have been repeatedly asked by our manager to come up with some visual charts/graphs etc. that would offer some insight into 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)

April 8, 2015 at 3:26 pm

#1789717
RE: How to find the needle in the haystack

We've had similar problems in the past. It turned out to be tape backups (BERemote.exe to be specific) hitting the backups on the disks, which were in the wrong...
--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 8, 2015 at 2:59 pm

#1789708
RE: XML Nodes to retreive the child and its list of values.

Alan.B (4/8/2015)
Alan.B (4/8/2015)
pawan.clong10 (4/8/2015)
HI Alan Thanks for that quick help.
i really appreciated. well, i am actually able to retrieve the data
However, the data is coming with the same token Names...
--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 8, 2015 at 2:56 pm

#1789706
RE: Employee status on first and last day of a pay period

CELKO (4/8/2015)
What math do you on the employee identifier? None! It should never be a numeric;
Absolute rubbish and you know it, Joe. What would you use instead?
--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 8, 2015 at 2:26 pm

#1789697
RE: Movie Rental Database

You should also have a status table to provide the DRI necessary for the status of each DVD. Likewise, you should also have a category table for 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)

April 7, 2015 at 10:44 pm

#1789412
RE: Movie Rental Database

As a bit of a sidebar, if this is a typical problem being taught nowadays, then it's no wonder the industry is in a world of hurt when it comes...
--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 7, 2015 at 10:33 pm

#1789411

Viewing 15 posts - 21,091 through 21,105 (of 59,098 total)