Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,061 through 21,075 (of 59,072 total)

RE: Group data into 15 minute intervals

dwain.c (4/9/2015)
A general question here to Jeff and Joe then. Let's hear your thoughts.
I've written on Calendar tables[/url] and how they can be used (An Easter SQL[/url]). Clearly...
--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 6:14 pm

#1790061
RE: Optimize memory with varchar(max) datatype

I strongly recommend NOT using VARCHAR of any type for Old/New values in such a table. Consider using SQL_VARIANT, instead. You don't really want to audit blobs anyway.
--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 5:10 pm

#1790050
RE: Group data into 15 minute intervals

Bill Talada (4/8/2015)
SELECT crdate, DATEDIFF(MINUTE,'19000101', crdate) / 15 FROM sysobjects ORDER BY DATEDIFF(MINUTE,'19000101', crdate) / 15 WITH x AS ( SELECT DATEDIFF(MINUTE,'19000101', crdate) / 15 as QuarterHour FROM sysobjects ) SELECT QuarterHour, COUNT(*) FROM x GROUP by QuarterHour ORDER by QuarterHour ;
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 5:04 pm

#1790049
RE: Today's Random Word!

Ed Wagner (4/9/2015)
SQLRNNR (4/9/2015)
@##$@&*&%#@
WTF
Peer Review
--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 4:59 pm

#1790048
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

Viewing 15 posts - 21,061 through 21,075 (of 59,072 total)